How do I find the logical database names that are in CA Workload Automation CA 7 Edition r12/12.1 Datacom database DBID=770?
Run the following SQL JCL.
//LISTDB EXEC PGM=DBSQLPR
//STEPLIB DD DISP=SHR,DSN=your.CA7.DATACOM.CUSLIB
// DD DISP=SHR,DSN=your.CA7.DATACOM.CAAXLOAD
//SYSPRINT DD SYSOUT=*
//SNAPPER DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//OPTIONS DD *
STRDELIM=A
PRTWIDTH=255
INPUTWIDTH=70
ROWLIMIT=50
AUTHID=MFWA
NOTYPE
//SYSIN DD *
SELECT DISTINCT DB FROM CA7_JOB ;
//
The output will be displayed in the STDOUT dd and the output below shows that there are 3 logical database names called CA7LVL1R12, CA7TEST and CA7DEV.
INPUT STATEMENT:
SELECT DISTINCT DB FROM CA7_JOB ;
DB
________________
CA7LVL1R12
CA7TEST
CA7DEV
___ 3 rows returned ___