Managing the generated LOAD statement data set


BMC AMI Unload enables you to manage the creation of the LOAD statement in all output formats except UNLOAD. How you manage this depends on the unload command that you use.

UNLOAD command

When you use the UNLOAD command, the default DD, SYSCNTL, receives the LOAD statement. You can change this DD name or DD name prefix by using the CNTLDDN option. 

You must include a SYSCNTL DD statement in your JCL (or a DD statement that matches the CNTLDDN option). The following considerations apply to SYSCNTL data sets:

  • We recommend that you do not use a partitioned data set (PDS).
  • If you specify multiple data sets, you must use the SYSCNTLn form of the DD name.
  • If you specify data control block (DCB) attributes, you must specify one of the following sets of attributes:
    • For fixed-length data sets, RECFM can be F, FB, or FBS. The logical record length (LRECL) must be a minimum of 80 bytes.
    • For variable-length data sets, RECFM can be V or VB. LRECL must be a minimum of 84 bytes.
  • If you do not specify DCB attributes, BMC AMI Unload uses DCB=(RECFM=FB,LRECL=80,BLKSIZE=3120).

UNLD command

When you use the UNLD command, the default DD, SYSPUNCH, receives the LOAD statement. You can change this DD name with the STMTDDN option. For more information, see STMTDDN.

Example

To change the DD name to MYDD, specify the following unload statement:

//SYSIN   DD  *
   UNLD DATA STMTDDN(MYDD) FROM TABLE <tableName>
//MYDD    DD  SYSOUT=X

The SYSPUNCH data set can have a record format (RECFM) of F, FB, V, VB, or U. The logical record length (LRECL) must be at least 80 bytes if fixed or undefined, or 84 bytes if variable. The block size must fit the requirements of the RECFM/LRECL combination. If the block size specified in the JCL is invalid for the RECFM/LRECL combination, BMC AMI Unload overrides the block size and sets a correct block size.

When multiple unload statements are in the same SYSIN, either specify individual SYSPUNCH DD statements and supply a different member name on each DD statement, or specify DISP=MOD or DISP=OLD.

You can allocate SYSPUNCH to DD DUMMY or SYSOUT, and write it to TAPE or DASD.

If the DD name specified is not allocated, BMC AMI Unload does not issue an error message and does not produce the LOAD statement.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*