CA 7 - How to confirm PTF SO15185 HOLDDATA performed?

book

Article ID: 207851

calendar_today

Updated On:

Products

CA Workload Automation CA 7 Edition

Issue/Introduction

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?

    

Environment

Release : 12.1

Component : CA-7

Resolution

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 *                             
AUTHID=MFWA                                  
/*                                           
//SYSIN    DD *                              
SELECT * FROM CA7_ZERO_RECORDS;
/*