GENERATE LOAD

Generates schema files to UNLOAD and LOAD one or more tables in a DBEnvironment.

Scope

SQLGEN Only

SQLGEN Syntax

>> [GENERATE] LOAD Unload Schema File Name or '//' to STOP command >> UnloadSchemaFile Load Schema File Name or '//' to STOP command >> LoadSchemaFile Prefix for Unloaded Data File Names >> UNLDPrefix UPDATE STATISTICS after Loading (n/y)? { N [O] Y [ES]} Internal or External Format (Int/Ext) >> { INT [ERNAL] EXT ERNAL } NULL Indicator (?) >> NullIndicator Prefix for DESCRIPTION File Names >> DESCPrefix Owner Name >> OwnerName Do you wish to specify Table Names for each Owner (n/y)? { N [O] Y [>ES]} Table Name for Owner OwnerName >> TableName

Parameters

UnloadSchemaFile: is the name of the schema file where SQLGEN places the commands that UNLOAD the data into data files.
LoadSchemaFile: is the name of the schema file where SQLGEN places the commands that LOAD the data back into tables.
UNLDPrefix: is the prefix used to name files containing the unloaded data (max: 11 bytes).
NO or YES: respond NO if no UPDATE is desired; respond YES to UPDATE STATISTICS after the LOAD.
INTERNAL or EXTERNAL: indicates the format you want the UNLOAD/LOAD to use.
NULLIndicator: is the symbol you choose to use for the NULL indicator. The default is a question mark (external format only).
DESCPrefix: is the prefix used to name description files (external format only; max: 11 bytes).
OwnerName: is the name of the owner whose tables you wish to LOAD/UNLOAD.
NO or YES: respond NO to select all table names for the owner; respond YES to specify certain tables for the named owner.
TableName: is the name of a table you wish to UNLOAD/LOAD.

Description

GENERATE LOAD builds two command files. One contains commands for unloading data from selected tables into files. The other contains commands for loading the data in the files back into tables.
EXTERNAL or INTERNAL format can be selected and used. Optionally, you can UPDATE STATISTICS after the LOAD.
LOAD EXTERNAL requires a prefix for naming description files and a NULL indicator.

Example

   >> load



   ALLBASE/SQL Command Generator for LOAD



   Unload Schema File Name or '//' to STOP command >>puruld

   Load Schema File Name or '//' to STOP command >> purld

   Prefix for Unloaded Data File Names >> purch

   UPDATE STATISTICS after Loading (n/y)?  yes

   Internal Format or External Format (Int/Ext) >> int



   Please enter Owner Names. Type @ for all, ? for a list of

   Owner Names, or RETURN to quit.



   Owner Name >> purchdb

   Do you wish to specify Table Names for each Owner(n/y)? n



   Generating [Int] commands for PURCHDB.INVENTORY

   Generating [Int] commands for PURCHDB.ORDERITEMS

               .                            .

   Owner Name >>   Return 

   >>

UNLOAD Schema File Produced

   UNLOAD TO INTERNAL purch1 FROM PURCHDB.INVENTORY;



   UNLOAD TO INTERNAL purch2 FROM PURCHDB.ORDERITEMS;



   UNLOAD TO INTERNAL purch3 FROM PURCHDB.ORDERS;

             .                       .

   COMMIT WORK;

LOAD Schema File Produced

   SET AUTOCOMMIT ON;



   LOAD FROM INTERNAL purch1 TO PURCHDB.INVENTORY;



   UPDATE STATISTICS FOR TABLE PURCHDB.INVENTORY;



   LOAD FROM INTERNAL purch2 TO PURCHDB.ORDERITEMS;



   UPDATE STATISTICS FOR TABLE PURCHDB.ORDERITEMS;

                .                     .

   COMMIT WORK;