Why does the RC/Query for Db2 for z/OS (RCQ) Column Detail Report look different?
Sample 1:
2016/11/07 10:49 2 SSID:ssid -------- RC/Q COLUMN DETAIL INQUIPAGE
LOCATION: LOCAL
CMD:
COLUMN: xx
TABLE: xxxxxxx
Sample 2:
2016/11/07 10:49 2 SSID:ssid -------- RC/Q COLUMN DETAIL INQUIPAGE
LOCATION: LOCAL
SQL STATEMENT GENERATING THIS REPORT:
SELECT A.NAME A.TBNAME A.TBCREATOR A.COLNO A.COLTYPE A.LENGTH
A.SCALE A.NULLS A.COLCARD A.HIGH2KEY A.LOW2KEY A.UPDATES A.REMARKS
A.DEFAULT A.KEYSEQ A.FOREIGNKEY A.FLDPROC A.LABEL B.TYPE B.COLCOUNT
B.CREATEDBY A.STATSTIME A.DEFAULTVALUE A.COLCARDF A.COLSTATUS
A.LENGTH2 A.TYPESCHEMA A.TYPENAME A.SOURCETYPEID A.CREATEDTS
A.STATS_FORMAT A.HIDDEN A.PARTKEY_COLSEQ A.PARTKEY_ORDERING
A.ALTEREDTS A.CCSID A.RELCREATED A.PERIOD
FROM SYSIBM.SYSCOLUMNS A,SYSIBM.SYSTABLES B
WHERE ( A.TBCREATOR = B.CREATOR AND A.TBNAME = B.NAME ) AND
A.TBCREATOR = 'xxxxxxxx' AND A.TBNAME LIKE 'xxxxxxxx' AND A.NAME='xx'
2016/11/07 10:49 2 SSID:ssid -------- RC/Q COLUMN DETAIL INQUIPAGE
LOCATION: LOCAL
CMD:
COLUMN: xx
TABLE: xxxxxxx
Did you know why you get a different QFILE output of the RC/Query Column Detail?
Check the RC/Query PROFILE settings for the RC/QUERY Profile Variable PRINT PARAMETER field PRINT SQL PAGE.
With this parameter you can specify whether a page displaying the SQL statement will be included in the printout when you
use batch reporting or print an online report with the QPRINT command.
Valid values are:
N No, do not include a page displaying the SQL statement.
Y Yes, include a page displaying the SQL statement.
NOTE: The other print parameters are specified through the Profile Menu because they are shared by other products