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?
Release : 12.x
Component : CA-7
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).