INSERT subcommand syntax options

Insert Column condition list

You can repeat the INSERT subcommand within the same MODIFY statement. However, you cannot mix it with DELETE, UPDATE, or VERIFY subcommands in the same MODIFY statement.

Use INSERT to insert entries in the SYSCOPY or BMCXCOPY table using a list of SYSCOPY or BMCXCOPY column conditions to specify the insertion criteria. Only a single value might be specified for each column; that is, you might use only the equal to (=) operand for each column condition.

The following rules apply to insertions:

• You can insert only image copies or quiesce points (ICTYPE F, I, or Q).
• You cannot insert a backup copy unless the corresponding primary copy already exists in SYSCOPY or BMCXCOPY.
• You cannot specify the same START_RBA, database name, space name, DSNUM, and ICBACKUP as an existing row.
• You cannot specify the same data set name as an existing row if the existing data set is cataloged.
• You cannot specify the same data set name, file sequence number, and VOLSER as an existing row, if the existing data set, is not cataloged.
• You cannot insert an incremental copy without an existing prior full image copy with the same database name, table space name, DSNUM (or DSNUM 0), and the same backup type. There must not be any incremental copies that are missing the backup type between the incremental copy you want to insert and the full image copy.

You must specify all of the following SYSCOPY or BMCXCOPY columns when inserting a copy. When inserting a quiesce point, you need only specify those marked with an asterisk:

• DBNAME*
• TSNAME* (or IXNAME* for index entries)
• ICTYPE*
• either ICDATE* and ICTIME* or TIMESTAMP*
• START_RBA*
• DSNAME
• DEVTYPE
• SHRLEVEL
• ICUNIT

The following columns default to the values shown when not specified for an insertion:

• DSNUM—ALL for table spaces and the value of IXDSNUM for indexes
• TIMESTAMP—ICDATE and ICTIME
• ICDATE—TIMESTAMP date
• ICTIME—TIMESTAMP time
• ICBACKUP—blank, that is, local primary (LP)
• STYPE—blank
• PIT_RBA—binary zeros
• GROUP_MEMBER—group member name when data sharing, otherwise blank