How to get different output results for a RC/Query Column DetailReport?

Document ID : KB000011887
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Why does the RC/Query Column Detail Report look different?

 

Sample 1:

2016/11/07  10:49 2 SSID:DDD1 -------- RC/Q COLUMN DETAIL INQUIPAGE

LOCATION: LOCAL

 

CMD:

COLUMN: ID

TABLE: MSABFOT 

 

 

Sample 2:

2016/11/07  10:49 2 SSID:D1GP -------- 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 = 'RZZZMS0D' AND A.TBNAME LIKE 'MSABFOT_OLD' AND A.NAME='ID'

 

2016/11/07  10:49 2 SSID:D1GP     -------- RC/Q COLUMN DETAIL INQUIPAGE

LOCATION: LOCAL

 

CMD:

COLUMN: ID

TABLE: MSABFOT

Question:

Did you know why you get a different QFILE output of the RC/Query Column Detail ?

 

Answer:

Please check your 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 CA Profile Menu because they are shared by other CA products

 

 

Additional Information:

https://docops.ca.com/ca-rc-query-db2-zos/19/en