Program BST05DBL does the following:
Use the command LOAD under DD BQLIN to load data into a BQL database.
During the execution of this command, the BQL does not accept any other requests.
You must stop the started task before loading data into the BQL database using BST05DBL.
DD BQLSAVE defines the sequential file containing the data to be loaded into the database. This file must be variable blocked.
The header of the records must have this structure:
Contents |
Position |
Length |
Format |
---|---|---|---|
Record length |
0 |
2 |
fixed |
Reserved for future use |
2 |
2 |
fixed 0 |
Table name |
4 |
8 |
character |
Reserved for future use |
12 |
4 |
character |
+------------------------------------------------------------+
|LOAD TABLE * | tablename,... -|
| DDNAME(ddname) | DSNAME(dsname) -|
| MEMBER(name) -|
| VOLUME(volume) -|
| UNIT(unit) -|
| GENFILE(nn) |
+------------------------------------------------------------+
Keyword |
Description |
---|---|
LOAD |
Introduces the load command |
TABLE * |
Specifies which of the data contained in the sequential file should be loaded into the tables of the database Code one or several table names to load only records of the specified tables. Code an asterisk ( * ) to load the records of all tables. |
DDNAME(ddname) |
DD name of the sequential file |
DSNAME(dsname) |
Dataset name of the sequential file |
MEMBER(name) |
Name of the member (if dsname is a PO dataset) |
VOLUME(volume) |
Volume where the sequential file is stored (if not cataloged) |
UNIT(unit) |
Unit where the sequential file can be accessed (if not cataloged) |
GENFILE(nn) |
Number of the generation file Note: GENFILE(nn) is required if the file to be loaded is a GEN file. |