MASSADD can run in Single User mode if NO is specified for the MULTUSE= keyword. Execute DBUTLTY using the following command format:
►►─ MASSADD ─ DBID=n ─ ,DEVICE= ─┬─ DISK ─┬─┬─────────────────┬───────────────► ├─ TAPE ─┤ └─┬─ ,BLKSIZE= ─┬─┘ └─ Snnn ─┘ └─ n ─────────┘ ►─ ,DTFNAME=d,TABLE=t ─┬───────────────────────┬─────────────────────────────► └─ ,LABEL= ─┬─ YES ◄ ─┬─┘ └─ NO ────┘ ►─┬─────────────────────────┬─┬────────────────────────┬─────────────────────► └─ ,MULTUSE= ─┬─ YES ◄ ─┬─┘ └─ ,REWIND= ─┬─ YES ◄ ─┬─┘ └─ NO ────┘ └─ NO ────┘ ►─┬─────────────────────────────┬────────────────────────────────────────────►◄ └─ ,STARTAFT= ─┬─ 0 ◄ ──────┬─┘ └─ nnnnnnnn ─┘
Command
Invokes the function to accept input records for a single table and add those records to the table.
Required Keywords
Specifies the database identifier for the database containing the table to which the records are being added.
DATACOM-ID of the database
(No default)
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).
DISK, TAPE, Snnn (Certain values from previous versions are still accepted but are treated as DISK.)
(No default)
Specifies the z/VSE JCL TLBL/DLBL name for the input data set. If DEVICE=TAPE, this name must match the name which 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.
Any name valid to z/VSE JCL specifications
(No default)
Specifies the table in the database to which the records are to be added.
DATACOM-NAME of the table in the database specified
(No default)
Optional Keywords
Specifies whether or not tape labels are to be processed. We recommend that labels always be used.
Note: LABEL= has no effect when DEVICE=DISK.
NO or YES
YES
CA Datacom/DB reads the block size value specified on the input file and ignores a valid BLKSIZE= value assigned in a MASSADD function. We recommend not using the BLKSIZE= keyword. This keyword was previously required and therefore, for convenience, CA Datacom/DB continues to accept it and check for a valid value. Should an invalid value be assigned to the BLKSIZE= keyword, CA Datacom/DB returns an error message.
1 to 32767
(No default)
Specifies whether the add commands are to be directed to the Multi-User Facility.
MASSADD directs its input to the Multi-User Facility. Direct commands to the Multi-User Facility when adding records to a table defined with integrity constraints.
MASSADD executes as a Single User job. In Single User mode, logging is not supported, and you do not have a log file to restart to ensure that the data and Index Areas are synchronized. Before using MASSADD, obtain a backup of the area in case you need to reload and try the function again.
NO or YES
YES
If DEVICE=TAPE (either TAPE or the Snnn form), YES indicates the tape is to be rewound before the OPEN and after the CLOSE. NO indicates no rewind before the OPEN or after the CLOSE. If omitted, the tape is rewound before the OPEN and rewound with unload after the CLOSE. NO allows the stacking of backups on one tape.
Note: REWIND= has no effect when DEVICE=DISK.
NO or YES
The tape is rewound before the OPEN and rewound with unload after the CLOSE.
Specifies a number of records to skip in the input data set before beginning to add records.
Any 1- to 8-character integer
0
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|