V1DCHFIL

The V1DCHFIL table is used for HSDCHFIL and HSURDFIL views. The following table describes the columns in the V1CHFIL 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
TYPNAME CHARACTER 128 0 ODBC Database Type Name
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 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
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 CHARACTER 10 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
PROCIDINP CHARACTER 5 0 process ID for input file
UNLINPTYP CHARACTER 4 0 unload input file type
UNLINPNAM CHARACTER 44 0 unload input file name
UNLINPVER BINARY 3 0 unload input file version
FMTSEL1 CHARACTER 8 0 format selector
SLTPGM CHARACTER 8 0 select program
UNLOUTTYP CHARACTER 4 0 unload output file type
UNLOUTNAM CHARACTER 44 0 unload output file name
UNLOUTVER BINARY 3 0 unload output file version
WRTPGM CHARACTER 8 0 write program for output
METHOD CHARACTER 10 0 Method