HSURDFIL

The HSURDFIL table is used for the file list and is populated during the Load Data Store Information phase and Work with Data Store phase. The following table describes the columns in the HSURDFIL table:

Column Type Length Decimal Domain
MCRECID BINARY 4 0 machine/company ID
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
FILRECID BINARY 9 0 file ID
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 128 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
DCMON CHARACTER 1 0 data corruption enabled
LOGALARM CHARACTER 1 0 logging alarm
DCALARM CHARACTER 1 0 data corruption alarm
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 BINARY 4 0 file category
FLAG01 CHARACTER 1 0 FB or VB flag
FLAG02 CHARACTER 1 0 currently unused
FLAG03 CHARACTER 1 0 currently unused
FLAG04 CHARACTER 1 0 currently unused
FLAG05 CHARACTER 1 0 currently unused
TYPNAME CHARACTER 128 0 ODBC Database Type Name