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 | Flag 1 |
| F LAG02 | CHARACTER | 1 | 0 | Flag 2 |
| F LAG03 | CHARACTER | 1 | 0 | Flag 3 |
| F LAG04 | CHARACTER | 1 | 0 | Flag 4 |
| F LAG05 | CHARACTER | 1 | 0 | Flag 5 |
| 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 |