JCL to query the CA7 R12.0/12.1 Datacom database

Products

• CA 7 Workload Automation

Issue/Introduction

Is there JCL to run queries against the CA7 R12/12.1 Datacom database?

Environment

Release:
Component: 7

Resolution

The following is a sample base JCL to query the CA7 R12.0/12.1 database. This JCL can be tailored to your needs.

//STEP1 EXEC PGM=DBSQLPR 
//STEPLIB DD DISP=SHR,DSN=your Datacom/AD CUSLIB 
//                DD DISP=SHR,DSN=your Datacom/AD CAAXLOAD 
//SYSPRINT DD SYSOUT=* 
//STDOUT    DD SYSOUT=* 
//OPTIONS  DD * 
PRTWIDTH=255 
INPUTWIDTH=70 
ROWLIMIT=5000 
AUTHID=MFWA 
NOTYPE 
//SYSIN       DD * 

The database SQL table names can be found in CAL2OPTN(AL2SQLD).

In the following link you can read more about the options for the OPTIONS DD:

DBSQLPR Options