MODIFY command


This section provides information about the subcommands and options available with the MODIFY command, including syntax diagrams, option descriptions, and usage information.

The following rules apply when using the MODIFY command:

  • You can use only valid SYSCOPY or BMCXCOPY columns and values. For a description of the columns and valid values, see the description of SYSIBM.SYSCOPY in the IBM DB2 for z/OS SQL Reference. For a description of the BMCXCOPY table, see Common-utility-tables.
  • Index space copies are registered in the SYSCOPY table (COPY YES indexes) or in the BMCXCOPY table (all other indexes). Only full copies are allowed for indexes so many semantic rules do not apply to indexes.
  • You cannot use MODIFY to delete a primary copy without deleting its backup.
  • In a column condition list, you can specify a column only once. If you specify a column more than once, an error message and return code of 8 is issued. If you need multiple conditions on the same column, such as in a WHERE clause, code a second WHERE clause. The WHERE clauses are interpreted as if the word or were between them to form a complex condition.

    MODIFY TABLESPACE A.B
    DELETE WHERE START_RBA < X'1000'
    WHERE START_RBA > X'3000'

    The preceding example is logically the same as START_RBA < X'1000' OR START_RBA > X'3000'. A row from SYSCOPY or BMCXCOPY is selected if it satisfies any of the WHERE clauses for the subcommand.

MODIFY command syntax diagrams

MODIFY command global syntax

3_MODIFY_command_global_syntax.png

MODIFY command object list syntax

GUID-1F04E3F2-0819-4674-A5AC-7A84314BC9DD-low.png

MODIFY command object options syntax

3_MODIFY_command_object_options_syntax_SPE1911.png

MODIFY command global options syntax

GUID-B93A9DBB-8A66-47F2-932C-16207187C5F2-low.png

MODIFY command syntax diagram—DELETE specification

image-2024-8-28_10-19-12.png


MODIFY command syntax diagram—INSERT specification

GUID-CD37E61D-5A47-4208-8DCA-87191F38C061-low.png

MODIFY command syntax diagram—UPDATE specification

GUID-914F2F74-BA9C-4C98-9E79-36B38202EE19-low.png

MODIFY command syntax diagram—VERIFY specification

GUID-01EBD7AB-3B4E-46A0-8115-4DE57FC66234-low.png

MODIFY command syntax diagram—Column condition list

3_MODIFY_Column condition list_SPE2110.png


Operand

Meaning

Validity

=

Equal to

Less than or equal to

Valid for all conditions

<>

¬ =

Not equal to

Invalid for INSERT, UPDATE SET

Valid for all other subcommands

<

Less than

>

Greater than

>=

Greater than or equal to

Legend

Column condition

Value

Description

ICTYPE

Q

Quiesce point

F

Full image copy

I

Incremental copy

i

Hidden incremental copy

f

Hidden Full image copy

m


EXPORT or IMPORT

b


INDEP or SIMULATE progress reporting

e


INDEP or SIMULATE progress reporting

p


INDEP or SIMULATE progress reporting

ICBACKUP

LP

Local site primary

LB

Local site backup

RP

Recovery site primary

RB

Recovery site backup

SHRLEVEL





C

Change

R

Reference

N or M

Reset no incremental

T

Tape unit

D

Disk unit

ICUNIT

T

Tape unit

D

Disk unit

STYPE






C

DFSMS concurrent copy

W

REORG LOG(NO) with ICTYPE F

X

REORG LOG(YES) with ICTYPE F

R

LOAD REPLACE LOG(YES) with ICTYPE F

S

LOAD REPLACE LOG(NO) with ICTYPE F

V

Instant Snapshot copy registered in BMXCOPY

COPY_TYPE


X

EXPORT

I

IMPORT

This section contains the following topics:

 

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