V1URDFLF

The V1URDFLF table is used for ANURDFLF and HSURDFIL views. The following table describes the columns in the V1URDFLF table:

Column Type Length Decimal Domain
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
MCRECID BINARY 4 0 machine/company ID
FILRECID BINARY 9 0 file ID
FLDRECID BINARY 9 0 field ID
FLDDISPL BINARY 5 0 field displacement
FLDNAME CHARACTER 128 0 field name
FLDLEN BINARY 5 0 field length
FLDINT BINARY 3 0 field integer
FLDDEC BINARY 3 0 field decimal
FLDSIGN CHARACTER 1 0 field sign
FLDTYPE CHARACTER 1 0 field type
FLDTNUM DECIMAL 5 0 ODBC Data Type Number
FLDTNAME CHARACTER 128 0 ODBC Data Type Name
FLDNAT CHARACTER 1 0 field nature
FLJUSTIFY CHARACTER 1 0 justify flag
CLATYPE BINARY 3 0 field class
INFOPROV CHARACTER 3 0 information origin
MINVAL CHARACTER 33 0 minimum value
MAXVAL CHARACTER 33 0 maximum value
AVGVAL DECIMAL 18 0 average value
SPEDIFVAL BINARY 5 0 number of different values
USERPGM CHARACTER 10 0 user program
HASSPE CHARACTER 1 0 spectrum presence flag
FLSPE CHARACTER 1 0 spectrum calculation flag
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
NULLCAP CHARACTER 1 0 null capable field
VARLEN CHARACTER 1 0 field with variable length
ISANAG CHARACTER 1 0 demographic field
ESTCARD BINARY 9 0 estimated cardinality
ESTCLA BINARY 3 0 estimated class
SAMPVAL CHARACTER 33 0 sample value
SAMPNBR BINARY 9 0 sample OCCURS
FLDTXT CHARACTER 50 0 text
ISKEY CHARACTER 1 0 primary key
FLCLAVAL CHARACTER 1 0 use class value
ANAGPRO CHARACTER 3 0 demographic provider