The ANURDFLF table is used for file fields and is populated during the Load DB2 Table Information and Analyze File/Copybook Relationship phases. The following table describes the columns in the ANURDFLF table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| MCRECID | SMALLINT | 2 | 0 | machine/company ID |
| FILRECID | INTEGER | 4 | 0 | file ID |
| FLDRECID | INTEGER | 4 | 0 | field ID |
| FLDDISPL | INTEGER | 4 | 0 | field displ. |
| FLDNAME | CHAR | 128 | 0 | field name |
| FLDLEN | INTEGER | 4 | 0 | field length |
| FLDINT | SMALLINT | 2 | 0 | field integer |
| FLDDEC | SMALLINT | 2 | 0 | field decimal |
| FLDSIGN | CHAR | 1 | 0 | field sign |
| FLDTYPE | CHAR | 1 | 0 | field type |
| FLDNAT | CHAR | 1 | 0 | field nature |
| FLJUSTIFY | CHAR | 1 | 0 | Justify flag |
| CLATYPE | SMALLINT | 2 | 0 | field class |
| INFOPROV | CHAR | 3 | 0 | information origin |
| MINVAL | CHAR | 33 | 0 | minimum value |
| MAXVAL | CHAR | 33 | 0 | maximum value |
| AVGVAL | DECIMAL | 18 | 0 | average value |
| SPEDIFVAL | INTEGER | 4 | 0 | number of different values |
| USERPGM | CHAR | 10 | 0 | user program |
| HASSPE | CHAR | 1 | 0 | spectrum presence flag |
| FLSPE | CHAR | 1 | 0 | spectrum calculation flag |
| LOGMON | CHAR | 1 | 0 | logging enabled |
| DCMON | CHAR | 1 | 0 | data corruption enabled |
| LOGALARM | CHAR | 1 | 0 | logging alarm |
| DCALARM | CHAR | 1 | 0 | data corruption alarm |
| NULLCAP | CHAR | 1 | 0 | null capable field |
| VARLEN | CHAR | 1 | 0 | field with variable length |
| ISANAG | CHAR | 1 | 0 | demographic field |
| ESTCARD | INTEGER | 4 | 0 | estimated cardinality |
| ESTCLA | SMALLINT | 2 | 0 | estimated class |
| SAMPVAL | CHAR | 33 | 0 | sample value |
| SAMPNBR | INTEGER | 4 | 0 | sample OCCURS |
| FLDTXT | CHAR | 50 | 0 | text |
| ISKEY | CHAR | 1 | 0 | primary key |
| FLCLAVAL | CHAR | 1 | 0 | use class value |
| ANAGPRO | CHAR | 3 | 0 | demographic provider |
| TYPNAME | CHAR | 128 | 0 | ODBC Data Type Name |
| TYPNUM | DECIMAL | 5 | 0 | ODBC Data Type Number |