ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Sample SQL job to report all datasets listed in the ADR table

book

Article ID: 236771

calendar_today

Updated On:

Products

Jobtrac

Issue/Introduction

Is there a Jobtrac report that can show or list  all the dataset names from the ADR table?

 

Environment

Release : 11.0

Component :

Resolution

There is not a Jobtrac report that will show all the dataset names from the ADR table.  You can run a SQL job to produce a list of this information from the ADR table.  The sample SQL job below will list the ADR, AMR, CCPF and SCS tables as they exist on the Datacom database: 

//*                                                              
//* LIST ADR (DST), AMR (MST), CCPF (PFT) AND SCS (CMT) TABLES   
//*                                                              
//REPORT  EXEC PGM=DBSQLPR,                                      
//                  PARM='PRTWIDTH=999,INPUTWIDTH=72,ROWLIMIT=9999'        
//STEPLIB    DD DISP=SHR,DSN=DATACOM.CUSLIB           
//                   DD DISP=SHR,DSN=DATACOM.CAAXLOAD         
//SYSPRINT DD SYSOUT=*                                           
//STDERR    DD SYSOUT=*                                           
//STDOUT    DD SYSOUT=*                                           
//OPTIONS   DD DUMMY                                              
//SYSIN        DD *                                                  
*$ROW                                                            
SELECT * FROM SYSUSR.CAHD_0161_DST ;                             
SELECT * FROM SYSUSR.CAHD_0161_MST ;                             
SELECT * FROM SYSUSR.CAHD_0161_PFT ;                             
SELECT * FROM SYSUSR.CAHD_0161_CMT ;  

Use the first SELECT statement to generate just the ADR table information.