How to Use

REPLACE (Replace All Data in a Table) › REPLACE › How to Use

How to Use

Multi-User mode is required to execute this command. Execute the REPLACE function using the following command format.

►►─ REPLACE ─ TABLE=t,DBID=n,DTFNAME=d,MULTUSE=YES,SORT=n ────────────────────►

 ►─┬─────────────────────────┬─┬───────────────────────┬──────────────────────►
   └─ ,DEVICE= ─┬─ DISK ───┬─┘ └─ ,LABEL= ─┬─ YES ◄ ─┬─┘
                ├─ TAPE ◄ ─┤               └─ NO ────┘
                └─ Snnn ───┘

 ►─┬───────────────────────────────────────┬─┬────────────────────────┬───────►
   └─ ,OPTION1='PRINT=CRITICAL,ROUTE=LOG' ─┘ └─ ,REWIND= ─┬─ YES ◄ ─┬─┘
                                                          └─ NO ────┘

 ►─┬──────────────────────┬─┬──────────────────────┬──────────────────────────►◄
   └─ ,SLACK= ─┬─ 0 ◄ ──┬─┘ └─ ,SORTWK= ─┬─ 3 ◄ ─┬─┘
               └─ nnnn ─┘                └─ n ───┘

Command

REPLACE: Invokes the function to load one table in a multiple table area with new data, replacing all current data for that table.

Required Keywords

,DBID=

Identifies the database containing the table to be loaded.

Valid Entries:: DATACOM-ID of the database
Default Value:: (No default)

,DEVICE=

Specifies the device type for the input data set.

When DEVICE=TAPE is specified, the system logical unit (SYS) number must be 5 (SYS005).

Use the Snnn entry to specify a specific SYS number (for tape only).

Valid Entries:: DISK, TAPE, Snnn (Certain values from previous versions are still accepted but are treated as DISK.)
Default Value:: (No default)

,DTFNAME=

Specifies the z/VSE JCL TLBL/DLBL name for the input data set.

If DEVICE=TAPE, this name must match the name that you code in your z/VSE JCL TLBL statement. Otherwise, this name must match the name you code in your z/VSE JCL DLBL statement.

Valid Entries:: Any name valid to z/VSE JCL specifications
Default Value:: (No default)

,MULTUSE=YES

Specifying MULTUSE=YES is required when executing the REPLACE function.

Valid Entries:: YES
Default Value:: (No default)

,SORT=

Sorting index entries is required.

To estimate the value to enter, multiply the number of keys in the table by the number of records to be sorted and add 30 percent. For example, if the table contains 2 keys and you are sorting 1000 records, the value you specify should be at least 2600. The value you specify is passed to the sort routine and can affect the amount of runtime used by the sort. If you use multiple LOAD or REPLACE statements in a single step, place the largest sort value first.

Note: Do not specify over 99 million unless you verify that the sort package you are using allows a larger number.

Valid Entries:: 0 to 99999999999
Default Value:: (No default)

TABLE=

Indicates a single table is to be loaded.

Valid Entries:: DATACOM-NAME of a table in the database and area being loaded
Default Value:: (No default)

Optional Keywords

,LABEL=

If DEVICE=TAPE (either TAPE or the Snnn form), specifies whether tape labels are processed. We recommend that you always use labeled tapes.

Note: LABEL= has no effect when DEVICE=DISK.

Valid Entries:: NO or YES
Default Value:: YES

,OPTION1=

Specifies the statistics display option to be passed to the sort program (see the SORT= parameter).

The OPTION1= parameter is highly recommended to obtain warning and critical messages if a problem occurs.

NOF: Corresponds to the NOFLAG parameter of the IBM sort. Only critical messages are to be displayed on the console.
'(I)': Specifies that informational and critical messages are to be displayed on the printer and the console.
'(U)': Specifies that only critical messages are to be directed to both the printer and the console.

NOF, '(I)', and '(U)' correspond to the Syncsort MSG options of CC, SC and CB respectively.

This parameter also accepts any three-character (including the surrounding parentheses) FLAG parameter that can be processed by the IBM sort. See your IBM sort manual for details.

Valid Entries:: NOF, '(I)', or '(U)'
Default Value:: NOF

,REWIND=

If DEVICE=TAPE (either TAPE or the Snnn form), YES indicates the tape is to be rewound before OPEN and after CLOSE. NO indicates no rewind before OPEN or after CLOSE. If omitted, the tape is rewound before the OPEN and rewound with unload after the CLOSE.

Note: REWIND= has no effect when DEVICE=DISK.

Valid Entries:: NO or YES
Default Value:: The tape is rewound before the OPEN and rewound with unload after the CLOSE.

,SLACK=

Specifies the number of bytes to reserve in each data block for future expansion of records in that block, or for addition of records when using a space reclamation option. The number entered applies only to blocks loaded to an area during this execution of the REPLACE function. Blocks not loaded with data use the SLACK value specified in the AREA definition in CA Datacom/DB.

Valid Entries:: A number that is less than the block size
Default Value:: 0

,SORTWK=

Specifies the number of sort work areas.

Note: Do not specify a 2-digit number unless the sort package you are using allows a 2-digit number. Sort packages that do not support a 2-digit number can fail in an unpredictable manner, if you specify a 2-digit number.

Valid Entries:

0 to 99

Note: Do not use two-digit numbers unless the SORT package to be used supports the larger number.

Default Value: