ANLICLOG

The ANLICLOG table is used for file fields, and is populated during the Life Cycle phase. The following table describes the columns in the ANLICLOG table:

Column Type Length Decimal Domain
MCRECID SMALLINT 2 0 machine/company ID
FILRECID INTEGER 4 0 file ID
FILLIB CHAR 128 0 file library
FILTYPE CHAR 4 0 file type
FILNAME CHAR 128 0 file name
FILVER SMALLINT 2 0 file version
RECFMT CHAR 10 0 format of record
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
DATETIME TIMESTMP 10 0 logging date/time