Is there JCL to run queries against the CA7 R12/12.1 Datacom database?
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 *
//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: