CA-Datamacs/II CA-DATACOM/DB Interface › CA-Datamacs/II CA-DATACOM/DB Interface Statements › DATACOM

DATACOM

The DATACOM statement activates the CA-Datamacs/II interface and identifies which function will be performed:

*DM DATACOM {CREATE | UNLOAD | LOAD | MODIFY}  
*DM DATABASE NAME IS x------------------------------x  
*DM [VERSION {PROD xxx|TEST xxx|Txxx}  
*DM OVER-RIDE xxxx  
*DM DBID xxx  
*DM DATADICTIONARY DDID IS xxx  
*DM UIB x------------------------------x  
*DM CHECKPOINT EVERY number-of-recs RECORDS  
*DM MASTNM master-list-name  
*DM USING {VSAM|DASD|TAPE}  
*DM BACKOUT].

Parameters:

CREATE

This option is used to initially populate a table(s) or to add records to an existing table(s). The source of the data to be placed in the table will be built from the field generators specified. If no field generators are specified, then default values will be used.

UNLOAD

This option is used to selectively unload records from a table(s). CA-DATACOM/DB statements similar to record-at-a-time commands are coded to direct CA-Datamacs/II in the unloading of one or more tables. Records are written to a single output file as variable length records, which may then be used as the input file to a LOAD.

LOAD

This option is used to add records to a table. The source of the data is a blocked, variable length sequential input file (QSAM for MVS, with a DD name of DMIFILE). Field generators may be specified to modify any of the input fields with different test data.

MODIFY

This option is used when records are to be deleted or updated. When records are updated, the field generators are the source of the new data. A READ or SCAN command with the HOLD option specified must be used to retrieve the record prior to updating or deleting it.

CHECKPOINT

This option will release control and permanently commit any records added, deleted or changed by this CA-Datamacs/II batch run. In long batch runs, this can reduce the length of time to perform a BACKOUT operation due to an error. This command will only be performed by CA-DATACOM/DB if the logging option has been specified in the Master List. Also, depending on the Master List options chosen, this option may not be necessary. Consult with your DBA as to the necessity of using this option. The checkpoint will be issued each time the record count specified is reached, or when end-of-job occurs.

BACKOUT

This option will issue CA-DATACOM/DB commands to back out or undo any changes to the table at end-of-job. The backout will occur for all changes, or back to the last checkpoint. Consult with your DBA as to the availability and other considerations for using the BACKOUT facility.

DATABASE NAME IS

Specify the 1-32 character database occurrence name.

Use the VERSION keyword to select a particular database other than the default PROD status/version.

If the database is locked, use OVER-RIDE to enter the 1- to 4-character code to allow access to the protected occurrence.

DBID

Use this parameter for multiple databases defined with the same Datadictionary definition in the CXX (cloned databases). Enter the 3-position numeric database ID as specified in the System Resource Table (SRT).

UIB - User Information Block

This 1-to-32 byte field can be used to identify the requestor of CA-DATACOM/DB services. The information should be enclosed in quotes and will be left-justified and padded with spaces if necessary.

DATADICTIONARY DDID IS

Use this parameter for multiple datadictionaries. Enter a 3-position number between 1 and 999. The default value is the DATABASE-ID specified in the System Resource Table (SRT).

MASTNM

Use this parameter for a single user environment. The default master list name is DBTTLST.

USING {VSAM|DASD|TAPE}

These VSE options define the UNLOAD output file or the LOAD input file.

Abbreviations:

DATADICTIONARY = DATADICT
DATABASE = DB
VERSION  = VER

Mandatory entries:

DATABASE

Defaults:

VERSION = PROD
DDID = value in SRT(DATABASE-ID)

Optional keywords:

NAME, IS, EVERY