ANURDFLF

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