How to extract JTS table information using SQL?
book
Article ID: 72571
calendar_today
Updated On:
Products
Jobtrac
Issue/Introduction
How to extract JTS table information using SQL?
Environment
Release:
Component: JOBTRC
Resolution
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.
Feedback
thumb_up
Yes
thumb_down
No