PTF SO15185 has HOLDDATA action items associated with it.
One action item has the following comment :
Rename reserved column in the CA7_ZERO_RECORDS table to
make the JCL_RETRY column available to SQL queries. Run job AL2DBI05 to rename the reserved column to JCL_RETRY.
Running a CA Datacom CXX report does not show the renamed column. How can it be confirmed that the HOLDDATA action was performed correctly?
Release : 12.1
Component : CA-7
The SQL column would not appear in a CXX report.
Run the following query and it will show all the column names for the table:
//SQL EXEC PGM=DBSQLPR
//STEPLIB DD DISP=SHR,DSN=datacomhlq.CUSLIB
// DD DISP=SHR,DSN=datacomhlq.CAAXLOAD
//STDOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//OPTIONS DD *
//SYSIN DD *
SELECT * FROM CA7_ZERO_RECORDS;