Loading Options
To load a database defined with non-SQL DDL statements, you can use either:
FASTLOAD Utility Statement
To use FASTLOAD, you must write and compile a format program that specifies how to load the data. After executing the format program, you invoke the FASTLOAD utility statement, which loads record occurrences into the database and makes set connections using the output from the format program. It also builds indexes during the load process.
User-Written Program
You can also load a database by using DML commands in a user-written application. The application can be written in any of the languages CA IDMS/DB supports.
If you use a user-written program to load the database, you should organize the record occurrences in the input file so that they mimic the structure of the database. For example, you should sort the records so that a CALC record is followed by its VIA member record occurrences. Steps for organizing the input file appear in more detail later in this chapter.
Advantages of FASTLOAD
FASTLOAD is often more efficient than a user-written program for loading a database with complicated structures (for example, multiple-member sets or multi-level record relationships). Additionally, FASTLOAD does not require pre-sorted data. As part of its internal processing, FASTLOAD sorts the data at certain points during the load process.
|
Copyright © 2014 CA.
All rights reserved.
|
|