Load Options

The Load Options screen displays when you select option 4 from the Extract/Load Menu. It lets you specify the table or view into which you are loading data and your load processing option. Enter SQL in the LOAD OPTION field to use SQL insert statements for loading the data, either online or batch. The SQL mode is especially useful for loading a table residing in a tablespace that contains several tables or for a view that can be updated. If SQL is selected, you must have at least INSERT authority on the table and possibly DELETE and UPDATE, depending on the Load Processing Options defined later. If the Db2 option is selected, you need the authority to execute IBM’s load utility.

Load Options Screen

File-AID for DB2 -------------------- Load Options ---------------------------
OPTION ===>                                                      SSID ===> DSN

Specify DB2 Table:
  Location ID ===>
  Creator      ===> USERID           (* for selection list)
  Table Name   ===> EMP2             (* for selection list)

Optional:
  Database     ===>
  Tablespace   ===>

Specify Load Option:
  Load Option ===> 1                (1 = SQL Insert Statements,
                                      2 = IBM DB2 Batch Load Utility)

Specify DB2 Table Area

Location ID

Location of the Db2 table.

Creator

ID of the person who created the Db2 table being used. Enter an asterisk (*) for a selection list.

Table Name

Name of the Db2 table, synonym, view, or alias being used for selection. Enter an asterisk (*) for a selection list.

Optional Area

Database

Name of the database to which you want your selection list confined.

Tablespace

Name of the tablespace to which you want your selection list confined.

Specify Load Option Area

Load Option

Specify the desired load option.

1	Uses SQL Insert statements. This option requires INSERT authority on the table.
2	Uses the IBM Db2 batch load utility. See also DB2 Batch Load Table.