Previous Topic Next topic Print topic


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
Previous Topic Next topic Print topic