How to submit the LOAD statement
You submit the LOAD statement only through the batch command facility. You must run the batch command facility in local mode.
How LOAD works
The LOAD utility reads records sequentially from an input file whose external name is SYS001.
The specifications in the syntax tell the LOAD utility how to interpret each record in SYS001 and which table(s) to load. The LRECL parameter controls whether the input file is fixed or variable length.
When to use LOAD
Use the LOAD utility to load an SQL-defined database for the first time or to expand it afterwards.
When not to use LOAD
Do not use the LOAD utility to load a non-SQL-defined database. Instead, use the FASTLOAD utility.
When to use a phased or stepped LOAD
Considerations for using the LOAD utility for a phased or stepped load and detailed loading procedures are discussed in the CA IDMS Database Administration Guide.
SYS001 input file contents
The LOAD utility does not perform any type of data translation against the input records within the SYS001 file. As a result, each column value in the SYS001 file must be in the proper internal format as specified by the corresponding column's data format. For example, if a column has a format of DECIMAL(5), the corresponding field in the SYS001 record must be a valid packed decimal number occupying 3 bytes.
Sorting intermediate work files
If you run the load process in steps or phases, use the sort parameters in the SYSPCH file to sort the intermediate files.
Checking error messages
Use the CA IDMS Messages and Codes Guide to locate messages associated with return codes received from the LOAD utility. Additionally, other useful information about any errors that occurred during LOAD processing are generated on the listing produced by the LOAD utility.
|
Copyright © 2014 CA.
All rights reserved.
|
|