Unloading a CA7 Datacom/DB Table in a sequential file

Products

• CA 7 Workload Automation
• Automic Automation Intelligence
• Unicenter Job Management Option
• iDash Workload Automation

Issue/Introduction

In CA7 R 11.x there is the possibility to copy/unload the Vsam JOB DB in a sequential file using an IDCAMS.

Is it possible to do the same copy/unload of a CA 7 Datacom/DB Table XXX and only this table, in a sequential file? 

 

 

Environment

Release : 12.x

Component : CA-7

Resolution

It is possible to do a copy/unload of a CA 7 Datacom/DB Table XXX in a sequential file, issuing the EXTRACT command of the DBUTLTY Datacom program. 

Below a sample job that will extract the CA7 Datacom/DB JOB Table: 

//STEP1    EXEC PGM=DBUTLTY,REGION=0M
//STEPLIB DD DISP=SHR,DSN=HLQ….CUSLIB
//        DD DISP=SHR,DSN=HLQ…..CAAXLOAD
//SYSPRINT DD  SYSOUT=*
//SNAPER   DD  SYSOUT=*
//SYSUDUMP DD  SYSOUT=*
//EXTR01   DD  DSN=HLQ….EXTRACT.JOB,
//             DISP=(NEW,CATLG),
//             SPACE=(CYL,(nn,nn),RLSE)
//CAOESTOP DD  SYSOUT=*
//SYSIN    DD  *
 COMM   OPTION=STATS,DBID=770
 EXTRACT AREA=JOB,DBID=770,DDNAME=EXTR01,SEQ=PHYSICAL,TABLE=JOB,
 UPDATE=NO
/*                                                               

no need to indicate a DCB for the output file as Datacom itself dynamically sets the correct one.

In this way the JOB Table will be available as a sequential file that can be provided as input to any other product/application that needs to acquire these data content for further processes. 

The record layout of each CA7 Datacom/DB Table can be found in member CAL2OPTN(AL2TRSLM).