V3URDFLF

The V3URDFLF table is used for ANURDFLF and HSURDFIL views. The following table describes the columns in the V3URDFLF 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
TSNAME CHARACTER 24 0 tablespace name
DBNAME CHARACTER 24 0 database name
OBID BINARY 4 0 OBID
APPLID CHARACTER 10 0 application ID
FILTXT CHARACTER 50 0 text
FREQLOG CHARACTER 1 0 logging frequency
FREQSPE CHARACTER 1 0 sampling frequency
FREQCORR CHARACTER 1 0 data corruption frequency
NUMREC BINARY 9 0 number of records
PROCID CHARACTER 5 0 process ID
UNLFILTYP CHARACTER 4 0 unload file type
UNLFILNAM CHARACTER 44 0 unload file name
UNLFILVER BINARY 3 0 unload file version
RECLEN BINARY 5 0 length of record
FMTSEL CHARACTER 8 0 format selector
DATEANA CHARACTER 8 0 date of analysis
DATECAL CHARACTER 8 0 date of last calculation
DATELOG CHARACTER 8 0 date of last log
DATESPE CHARACTER 8 0 date of last spectrum
DATECORR CHARACTER 8 0 date of last data corruption
MBFTYP CHARACTER 1 0 type of file
ANALYSIS CHARACTER 1 0 analysis state
RECANAL BINARY 9 0 number of record Analyzed
CPYLIB CHARACTER 44 0 associated copybook PDS
CPYNAME CHARACTER 10 0 associated copybook name
IOAREANAME CHARACTER 30 0 I/O area name
IOAREAPRG BINARY 3 0 I/O area progressive
INFOPROV CHARACTER 3 0 information provider
FILNICK CHARACTER 10 0 nickname of file
LOGMON CHARACTER 1 0 logging enabled for file
LOGALARM CHARACTER 1 0 logging alarm for file
FLANAG CHARACTER 1 0 is demographic
COENAB CHARACTER 1 0 data consistency
DATECO CHARACTER 8 0 consistency date
FANAGPRO CHARACTER 3 0 demographic provider
FILCAT CHARACTER 10 0 file category
FLAG01 CHARACTER 1 0 FB or VB flag
F LAG02 CHARACTER 1 0 currently unused
F LAG03 CHARACTER 1 0 currently unused
F LAG04 CHARACTER 1 0 currently unused
F LAG05 CHARACTER 1 0 currently unused
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
FLDNAT CHARACTER 1 0 field nature
FLDTNUM DECIMAL 5 0 ODBC Data Type Number
FLDTNAME CHARACTER 128 0 ODBC Data Type Name
FLJUSTIFY CHARACTER 1 0 justify flag
CLATYPE BINARY 3 0 field class
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
DCMON CHARACTER 1 0 data corruption enabled
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