SYB_DB_OPT_TPL - ASE DBA Cockpit Template: Schedule Stroed Procedures
ASE DBA Cockpit Template: Schedule Stroed Procedures information is stored in SAP table SYB_DB_OPT_TPL.
It is part of development package SMSYB in software component BC-DB-SYB. This development package consists of objects that can be grouped under "SYBASE Database Monitor".
It is part of development package SMSYB in software component BC-DB-SYB. This development package consists of objects that can be grouped under "SYBASE Database Monitor".
Fields for table SYB_DB_OPT_TPL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TPL_ID | 4 Byte Signed Integer | X | INT4 | INT4 | 4 | |
| TPL_VERSION | 4 Byte Signed Integer | X | INT4 | INT4 | 4 | |
| DB_OPTION | SYB: Object Name (Index, Table, Partition, ...) | X | SYBOBJNAME | CHAR | 256 | |
| DATABASE_NAME | SYB: DB Name | X | SYBDBNAME | CHAR | 60 | |
| VALUE | General Flag | FLAG | CHAR | 2 | ||
| RECOMMENDATION | R/2 table | CHAR5 | CHAR | 10 |