How to get different output results for a RC/Query Column Detail Report

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

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?

Resolution

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