The V1REP06 table is used as a report that shows all table structures including classes and masking routines. The following table describes the columns in the V1REP06 table:
Column | Type | Length | Decimal | Domain |
---|---|---|---|---|
MACHINE_ID | CHARACTER | 10 | 0 | Machine ID |
COMPANY | CHARACTER | 10 | 0 | Company |
APPLICATION_ID | CHARACTER | 10 | 0 | Application ID |
FILE_TYPE | CHARACTER | 4 | 0 | File Type |
FILE_OR_TABLE_QUALIFIER | CHARACTER | 128 | 0 | File or Table Qualifier |
FILE_OR_TABLE_NAME | CHARACTER | 128 | 0 | File or Table Name |
RECORD_FORMAT | CHARACTER | 10 | 0 | Record Format |
GDG_VERSION | BINARY | 4 | 0 | GDG Version |
COLUMN_PROGRESSIVE | INTEGER | 4 | 0 | Column Progressive |
COLUMN_NAME | CHARACTER | 128 | 0 | Column Name |
COLUMN_LENGHT | BINARY | 9 | 0 | Column Length |
COLUMN_INTEGER_POSITIONS | BINARY | 4 | 0 | Column Integer Positions |
COLUMN_DECIMAL_POSITIONS | BINARY | 4 | 0 | Column Decimal Positions |
COLUMN_SIGN | CHARACTER | 1 | 0 | Column Sign |
COLUMN_TYPE | CHARACTER | 1 | 0 | Column Type |
COLUMN_NULL_CAPABLE | CHARACTER | 1 | 0 | Column Null Capable |
COLUMN_VARCHAR | CHARACTER | 1 | 0 | Column Varchar |
CLASS_DESCRIPTION | VARCHAR | 30 | 0 | Class Description |
ROUTINE_NAME | VARCHAR | 8 | 0 | Routine Name |