Retrieve Record Formats (RTVRCDFMT) UDTF

Index

Schema IQUERY

RTVRCDFMT( library_name => '*LIBL', file_name => 'file-name' )

The Retrieve Record Formats (RTVRCDFMT) User Defined Table Function returns one for each record format located in the specified file.

Parameters

LIBRARY_NAME

The library name of the File. If unspecified, *LIBL is used.

FILE_NAME

The name of the file whose record formats are returned.

Examples

select format, record_length,text from table( iQuery.RTVRCDFMT('QIWS','QCUSTCDT')) fmts;

Column
Data Type
Description
FORMAT
VARCHAR(10)
The name of the record format.
TEXT_DESCRIPTION
VARCHAR(50) The Format Text description.
COLUMN_COUNT
int The number of columns (fields) that the record format contains.
RECORD_LENGTH
int The record length (in bytes) of the record format.
FORMAT_COUNT int The number of record formats returned by the UDTF.
FILE_TYPE VARCHAR(10)
The file attribute: PF, LF, DSPF, DDMF, PRTF, TAPF, etc.
FILE_TEXT_DESCRIPTION
VARCHAR(50) The Text Description of the File whose record formats are returned.
CREATE_DATE
timestamp
The File's creation date/time in TIMESTAMP format.