The MUF must be active when you execute this command. Execute the REPLACE function using the following command format.
►►─ REPLACE ─ TABLE=t,DBID=n,DDNAME=d,MULTUSE=YES,SORT=n ─────────────────────► ►─┬──────────────────────────┬─┬─────────────────────────┬───────────────────► └─ ,LOADPTN= ─┬─ FAIL ◄ ─┬─┘ └─ ,OPTION1= ─┬─ NOF ◄ ─┬─┘ └─ SKIP ───┘ ├─ '(I)' ─┤ └─ '(U)' ─┘ ►─┬─────────────────────┬─┬─────────────┬─┬──────────────────────┬───────────► └─ ,SLACK= ─┬─ 0 ◄ ─┬─┘ └─ ,SORTDD=n ─┘ └─ ,SORTWK= ─┬─ 3 ◄ ─┬─┘ └─ nnn ─┘ └─ n ───┘ ►─┬────────────────────────┬─────────────────────────────────────────────────►◄ └─ ,UNIT= ─┬─ SYSDA ◄ ─┬─┘ └─ c ───────┘
Command
Invokes the function to load one table in a multiple table area with new data, replacing all current data for that table.
Required Keywords
Identifies the database containing the table to be loaded.
DATACOM-ID of the database
(No default)
Specifies the JCL DDname for the input data set.
A DDNAME is not acceptable for sequential input or output files if it is a name reserved for a CA Datacom area. Names with the following patterns are therefore not acceptable for DDNAME=:
The DDNAME= value is verified for acceptability to protect you from unintentionally causing data corruption. The DDNAME check is the default but optional. You can prevent the DDNAME check by using a DBSIDPR parameter (DBUTLTY_EDIT_DATA_SET=) for individual MUF environments. However, we recommend that you allow the DDNAME check.
The data corruption risk involves not the DDNAME itself but the content of the data set. For example, suppose that you used the CXX DDNAME as the output of a backup. You then copied the CXX DD statement and changed the DDNAME of the copy to be acceptable, avoiding the DDNAME= error. The backup would, however, then overlay the CXX data set, which is not the intent of a backup.
If you specify an unacceptable name for DDNAME=, message DB10059E is generated. For more information about DB10059, see the CA Datacom/DB Message Reference Guide.
Note: We recommend that you allow DDNAME= check protection. You can, however, disable DDNAME= protection. To disable protection, assemble the DBSIDPR module used for this CA Datacom environment and specify NONE for the DBUTLTY_EDIT_DATA_SET= parameter. The default is DBUTLTY_EDIT_DATA_SET=FULL_1, which allows DDNAME= protection. For more information about DBSIDPR and DBUTLTY_EDIT_DATA_SET=, see the CA Datacom/DB Database and System Administrator Guide.
Any name valid to JCL specifications
(No default)
Specifying MULTUSE=YES is required when executing the REPLACE function.
YES
(No default)
Sorting index entries is required.
The OPTION1= parameter is highly recommended to obtain warning and critical messages if a problem occurs.
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.
0 to 99999999999
(No default)
Indicates a single table is to be loaded.
DATACOM-NAME of a table in the database and area being loaded
(No default)
Optional Keywords
Specifies how the utility handles a rejected row for a table partition. If it is set to SKIP, the row is ignored with no error condition. If it is set to FAIL, the row is dumped, and the utility function terminates.
FAIL or SKIP
FAIL
Specifies the statistics display option to be passed to the sort program (see the SORT= parameter).
Corresponds to the NOFLAG parameter of the IBM sort. Only critical messages are to be displayed on the console.
Specifies that informational and critical messages are to be displayed on the printer and the console.
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.
NOF, '(I)', or '(U)'
NOF
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 Datadictionary.
A number that is less than the block size
0
Specifies an optional DD statement, provided to the SORT that redirects SYSPRINT-type output from the SYSPRINT DD (used by DBUTLTY) to this optional DD statement.
printed output directed to optional DD statement
printed output directed to SYSPRINT, intermixed with DBUTLTY output
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.
0 to 99
Note: Do not use two-digit numbers unless the SORT package to be used supports the larger number.
3
Specifies the unit name for sort work areas. The parameter is always edited, but is only used when the SORT= parameter is specified as not zero.
1- to 8-character unit name
SYSDA
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|