The db_seqtable table contains metadata about flat files .
| Column Name | Column Datatype | Column Null Option | Column Comment |
| dbrep_iid | integer | not null | The unique ID of the flat file. |
| dbrep_aligned | integer1 | with null | Aligned if IBMCOMP has been selected as the method of creating the source file. |
| dbrep_ibmcomp | integer1 | with null | Indicates whether the source file was created with the IBMCOMP system directive specified. |
| dbrep_endian | smallint | with null | The types of supported endian:
Big endian - 0 Little endian - 1 Mixed endian - 2 |
| dbrep_mode | smallint | with null | The types of supported file modes:
Fixed - 0 Variable - 1 Mixed - 2 |
| dbrep_floatformat | integer | with null | The supported float formats:
IEEE standard. IBM standard. |
| dbrep_codepage | integer | with null | The supported codepages:
EBCDIC_US_ENGLISH = 37, EBCDIC_AUSTRIAN_GERMAN = 273, EBCDIC_DANISH_NORWEGIAN = 277, EBCDIC_FINNISH_SWEDISH = 278, EBCDIC_ITALIAN = 280, EBCDIC_SPANISH = 284, EBCDIC_UK_ENGLISH = 285, EBCDIC_FRENCH = 297, EBCDIC_INTERNATIONAL = 500, EBCDIC_ICELANDIC = 871, ASCII_US_ENGLISH = 437, ASCII_MULTILINGUAL = 850, ASCII_PORTUGUESE = 860, ASCII_CANADIAN_FRENCH = 863, ASCII_NORWEGIAN = 865 |
| dbrep_location | varchar(127) | with null | The location of the sequential file used. |
| dbrep_generatorpath | varchar(128) | with null | The path to generated extract program. |
Product Name: Data Transformer
Table Type: Table