The HSURDFIL table is used for the file list and is populated during the Load Data Store Information phase and Work with Data Store phase. The following table describes the columns in the HSURDFIL table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| MCRECID | BINARY | 4 | 0 | machine/company ID |
| FILLIB | CHARACTER | 128 | 0 | file library |
| FILTYPE | CHARACTER | 4 | 0 | file type |
| FILNAME | CHARACTER | 128 | 0 | file name |
| FILVER | BINARY | 3 | 0 | file version |
| RECFMT | CHARACTER | 10 | 0 | format of record |
| FILRECID | BINARY | 9 | 0 | file ID |
| TSNAME | CHARACTER | 24 | 0 | tablespace name |
| DBNAME | CHARACTER | 24 | 0 | database name |
| OBID | BINARY | 4 | 0 | OBID |
| APPLID | CHARACTER | 10 | 0 | application ID |
| FILTXT | CHARACTER | 50 | 0 | text |
| FREQLOG | CHARACTER | 1 | 0 | logging frequency |
| FREQSPE | CHARACTER | 1 | 0 | sampling frequency |
| FREQCORR | CHARACTER | 1 | 0 | data corruption frequency |
| NUMREC | BINARY | 9 | 0 | number of records |
| PROCID | CHARACTER | 5 | 0 | process ID |
| UNLFILTYP | CHARACTER | 4 | 0 | unload file type |
| UNLFILNAM | CHARACTER | 128 | 0 | unload file name |
| UNLFILVER | BINARY | 3 | 0 | unload file version |
| RECLEN | BINARY | 5 | 0 | length of record |
| FMTSEL | CHARACTER | 8 | 0 | format selector |
| DATEANA | CHARACTER | 8 | 0 | date of analysis |
| DATECAL | CHARACTER | 8 | 0 | date of last calculation |
| DATELOG | CHARACTER | 8 | 0 | date of last log |
| DATESPE | CHARACTER | 8 | 0 | date of last spectrum |
| DATECORR | CHARACTER | 8 | 0 | date of last data corruption |
| MBFTYP | CHARACTER | 1 | 0 | type of file |
| ANALYSIS | CHARACTER | 1 | 0 | analysis state |
| RECANAL | BINARY | 9 | 0 | number of record analyzed |
| CPYLIB | CHARACTER | 44 | 0 | associated copybook PDS |
| CPYNAME | CHARACTER | 10 | 0 | associated copybook name |
| IOAREANAME | CHARACTER | 30 | 0 | I/O area name |
| IOAREAPRG | BINARY | 3 | 0 | I/O area progressive |
| INFOPROV | CHARACTER | 3 | 0 | information provider |
| FILNICK | CHARACTER | 10 | 0 | nickname of file |
| LOGMON | CHARACTER | 1 | 0 | logging enabled |
| DCMON | CHARACTER | 1 | 0 | data corruption enabled |
| LOGALARM | CHARACTER | 1 | 0 | logging alarm |
| DCALARM | CHARACTER | 1 | 0 | data corruption alarm |
| FLANAG | CHARACTER | 1 | 0 | is demographic |
| COENAB | CHARACTER | 1 | 0 | data consistency |
| DATECO | CHARACTER | 8 | 0 | consistency date |
| FANAGPRO | CHARACTER | 3 | 0 | demographic provider |
| FILCAT | BINARY | 4 | 0 | file category |
| FLAG01 | CHARACTER | 1 | 0 | FB or VB flag |
| FLAG02 | CHARACTER | 1 | 0 | currently unused |
| FLAG03 | CHARACTER | 1 | 0 | currently unused |
| FLAG04 | CHARACTER | 1 | 0 | currently unused |
| FLAG05 | CHARACTER | 1 | 0 | currently unused |
| TYPNAME | CHARACTER | 128 | 0 | ODBC Database Type Name |