Defining DB2 Records › How Do You Maintain DB2 Infostorage Records? › INSERT: Creating DB2 Records › Syntax › Parameters

Parameters

The INSERT subcommand takes the following parameters:

*

Specifies the last record processed since you established the CONTROL(DB2) setting. However, only the record ID is reinstated, none of the field values are retained. The asterisk does not work with multiple records or masking.

recid

Names the record ID of the DB2 record you want to insert. You cannot mask this field. For SAFELIST records, the recid must be in the form: SAFELIST.qualifier. The qualifier makes the record key unique since there can be multiple SAFELIST records for each DB2 subsystem.

SYSID(sysid)

Names the one‑ to four‑character subsystem ID of the DB2 record that you want to insert. Any value that you specify with the SYSID parameter can contain asterisks or a trailing dash, however, CA ACF2 Option for DB2 treats these characters as part of the SYSID itself and not as a mask.

You can use the asterisk, however, to create a DB2 record that is shared among DB2 subsystems. For example, you can create a record with a SYSID of DB2* to represent more than one DB2 subsystem. CA ACF2 Option for DB2 uses this record for any DB2 subsystem ID that begins with DB2.

If you do not specify this parameter, CA ACF2 Option for DB2 uses the record with the SYSID value specified with the SET command. If you did not specify a SYSID with the SET command, CA ACF2 Option for DB2 displays the message INVALID REQUEST ‑ UNDEFINED SYSID.

USYSID(sysid)

Specifies subsystem ID of an existing record that you want to use as a model when CA ACF2 Option for DB2 creates the new DB2 record. Any value that you specify with the USYSID parameter can contain asterisks or a trailing dash, however, CA ACF2 Option for DB2 treats these characters as part of the subsystem ID itself and not as a mask.

This time‑saving feature lets you insert a record that is similar to a record previously defined for another subsystem ID. You can change any fields and values that differ using the INSERT subcommand or a subsequent CHANGE subcommand.

field1,field2,...,fieldn

Specifies the fields and any values to change in the new record from the model record. For the specific field names in each record, see the previous description of the DB2 record fields.

ADD

For DB2 EXITS records only, ADD adds the specified fields and values to the existing fields and values copied from the model record. If a field already exists in the model, the new value replaces the copied value. ADD is the default.

For DB2 OPTS records, ADD is invalid because CA ACF2 Option for DB2 creates default field values that you cannot add values to. Use the REP parameter instead.

REP

Replaces a value of a corresponding field in the model record. If the specified field was not copied from the model record, that field and its value are added to the record.

DEL

For DB2 EXITS records only, DEL deletes any specified fields and values from the newly copied model record.

For DB2 OPTS records, DEL is invalid because CA ACF2 Option for DB2 creates default field values that cannot be deleted.