| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | DB2SYS | Central Database System | nvarchar | 10 | 0 | CHAR | (N' ') | No | | SYDBSYS | Allow NULL? |
| 2 | DB2VERSION | Character Field Length = 10 | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CHAR10 | Allow NULL? |
| 3 | DB2RELEASE | DB2 release | nvarchar | 10 | 0 | CHAR | (N' ') | No | | DB2RELEASE | Allow NULL? |
| 4 | CHECKCLASS | DB2 for OS/390 check class for system check | nvarchar | 4 | 0 | CHAR | (N' ') | No | | DB2CKCLASS | Allow NULL? |
| 5 | CHECKNAME | DB2 for OS/390 DB system check - name of a check | nvarchar | 50 | 0 | CHAR | (N' ') | No | | DB2CHKNAME | Allow NULL? |
| 6 | CHECKSEQUENCE | Numeric 1-character | char | 1 | 0 | NUMC | (N'0') | No | | NUM1 | Allow NULL? |
| 7 | MODUSER | Normal SAP user or special user '#SAP#' | nvarchar | 12 | 0 | CHAR | (N' ') | No | | CKMOD_USER | Allow NULL? |
| 8 | MODDATE | Date of last modification | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DB2MODDATE | Allow NULL? |
| 9 | MODTIME | Time of last modification | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | DB2MODTIME | Allow NULL? |
| 10 | ACTIVE | Activation Indicator for Check Condition | char | 1 | 0 | CHAR | (N' ') | Yes | | CHKACTIV | Allow NULL? |
| 11 | MODFLAG | DB2/OS390: Shows if check in DB system check can be modified | char | 1 | 0 | CHAR | (N' ') | Yes | | DB2MODFLG | Allow NULL? |
| 12 | SEVERITY | DB2 for OS/390: Severity of error detected | char | 1 | 0 | CHAR | (N' ') | Yes | | DB2CHKSEV | Allow NULL? |
| 13 | PARAM | DB2 for OS/390: Paramter to be checked in DB system check | nvarchar | 50 | 0 | CHAR | (N' ') | No | | DB2PARAM | Allow NULL? |
| 14 | PARAM_UNIT | Unit of Check Value | char | 1 | 0 | CHAR | (N' ') | Yes | | CHKUNIT | Allow NULL? |
| 15 | OPERATOR | DB2 for OS/390: check operator (system check) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | DB2CKOP | Allow NULL? |
| 16 | CHECKVALUE_R3 | DB2 for OS/390: Parameter value in DB system check | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | DB2CHKVAL | Allow NULL? |
| 17 | CHECKVALUE | DB2 for OS/390: Parameter value in DB system check | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | DB2CHKVAL | Allow NULL? |
| 18 | CHECKVALUE_BW | DB2 for OS/390: Parameter value in DB system check | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | DB2CHKVAL | Allow NULL? |
| 19 | CHECK_UNIT | Unit of Check Value | char | 1 | 0 | CHAR | (N' ') | Yes | | CHKUNIT | Allow NULL? |
| 20 | ISNUMERIC | 'X' if parameter is numeric, ' ' otherwise | char | 1 | 0 | CHAR | (N' ') | Yes | | DB2NUMERIC | Allow NULL? |
| 21 | ERRORTXT | DB2 OS/390: Description of error reported by DB system check | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | DB2CHKDESC | Allow NULL? |
| 22 | CORRTXT | DB2 OS/390: corrective action for error in DB system check | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | DB2CHKCORR | Allow NULL? |
