How to extract JTS table information using SQL?

Document ID : KB000072571
Last Modified Date : 05/03/2018
Show Technical Document Details
Question:
How to extract JTS table information using SQL?         
Answer:
You can extract the JTS information by using SQL.  Below is how the table names map to the JTS names: 

CMT       JTS SCS 
DST        JTS ADR 
PFT        JTS CCPF 
MST       JTS AMR 

Run with "SELECT*" first one at a time on each table to see the field names and then run again and select just the field names that you desire. 

//SQLEXEC EXEC PGM=DBSQLPR, 
// PARM='PRTWIDTH=999,INPUTWIDTH=72,ROWLIMIT=9999' 
//STEPLIB DD DISP=SHR,DSN=hlq.CUSLIB <- Datacom 
// DD DISP=SHR,DSN=hlq.CAAXLOAD <- Datacom 
//SYSPRINT DD SYSOUT=* 
//STDERR DD SYSOUT=* 
//STDOUT DD SYSOUT=* 
//OPTIONS DD DUMMY 
//SYSIN DD * 
SELECT * FROM SYSUSR.CAHD_0161_CMT; 
SELECT * FROM SYSUSR.CAHD_0161_DST; 
SELECT * FROM SYSUSR.CAHD_0161_MST; 
SELECT * FROM SYSUSR.CAHD_0161_PFT;

  As always, please contact CA Technologies support for CA Jobtrac Job Management if you have further questions.