DB2 graphic QMF Version 8

Report registration table layout (Q.REPORTS)

Column Name Data Type Description
REPORT_OWNER CHAR(8) Report owner
REPORT_NAME VARCHAR(18) Report name
RESTRICTED CHAR(1) 'Y' restricts access to this report; 'N' allows shared access to this report
ENVIRONMENT CHAR(1) 'B' for batch; 'T' for TSO; 'C' for CICS
LANGUAGE CHAR(1) '1' or 'B' for OS/VS COBOL; '2' for VS COBOL II; 'C' for C
DB2_CONNECTION CHAR(1) 'C' for call attachment facility; 'T' for TSO attachment facility
PLAN_NAME CHAR(8) Plan name (optional)
PROGRAM_NAME CHAR(8) Program name
LOAD_LIBRARY VARCHAR(44) Load library name (optional)
VARIABLES CHAR(1) 'Y' if this report uses variables; 'N' otherwise
QUERY_OWNER CHAR(8) Owner of query that was converted into program
QUERY_NAME VARCHAR(18) Name of query that was converted into program
FORM_OWNER CHAR(8) Owner of form that was converted into program
FORM_NAME VARCHAR(18) Name of form that was converted into program
PROC_OWNER CHAR(8) Owner of procedure that was converted into program
PROC_NAME VARCHAR(18) Name of procedure that was converted into program
VARIABLE_LRECL SMALLINT LRECL of HOSTVARS DD for batch programs
DESCRIPTION VARCHAR(55) Description of this report
RDATE DATE Date of program registration
RTIME TIME Time of program registration
DATAOUT_LRECL SMALLINT LRECL of DATAOUT DD, or -1 if n/a
DATAIN_LRECL SMALLINT LRECL of DATAIN DD, or -1 if n/a
REPORT_LRECL SMALLINT LRECL of REPORTnn DDs, or -1 if n/a
NUM_REPORT_FILES SMALLINT Number of REPORTnn DDs used by program, or -1 if unknown or n/a
PROGRAM_TYPE CHAR(1) Type of program: 'P' print, 'D' display, 'N' no report, 'L' data layer, 'P' proc
Note:
For data retrieval purposes, a unique index should be created on columns REPORT_OWNER and REPORT_NAME.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004