Use the DB Alias tab to define the parameters needed for the nzload utility. The Optim™ solution supports the loader for delimited or fixed-length format
ASCII. Load is not supported for data that includes NCHAR or NVARCHAR
data types. The availability of certain options and fields might be
dependent upon your entries for related options and fields on the
tab. Also, if the source file specified on the General tab is created by using fast migration, only the options and fields
that are supported for fast migration files are available.
Mode
- Insert
- Insert rows from the source file into destination
tables.
- Replace
- Clear all data in the destination tables and replace
with rows from the source file.
File Type
- ASCII
- Generate an ASCII file of fixed-length rows.
- ASCII Delimited
- Generate an ASCII delimited file type to import data. If you select
this file type, select a valid delimiter.
- Delimiter
- Eliminating a scan for delimiters in character
data columns can improve load performance. To eliminate a scan, select
one of the following. The presence of the selected delimiter in the
source data causes a conversion error during the load process.
X'01' (No Pre-scan)
X'02' (No Pre-scan)
X'03' (No Pre-scan)
X'04' (No Pre-scan)
X'05' (No Pre-scan)
Scan while generating the loader
file. Select any of the following values from the Delimiter list:( ) * / ; ? | < > =
X'FA'
X'FB'
X'FC'
X'FD'
X'FE'
X'FF'
Options
- Perform Load
- Run the loader automatically after file conversion processing
is complete. Clear this check box to prepare the data in the appropriate
format and create the BAT file to run the loader. Before running the
loader, you must ensure that the tables are empty and edit the BAT
file to include the password information.
- Use Named Pipe
- In a Windows or UNIX environment, load performance
might be improved by using a named pipe. When this option is used,
the load process runs in a single phase rather than a two-stage process,
resulting in reduced elapsed time for load processing. As the row
data is loaded immediately after conversion to a loader format, space
requirements are also reduced significantly, as compared to the two-stage
load process. The solution creates the named pipe and writes the
file to it. The load utility reads the data from the named pipe and
submits the data to the loader.
- Delete files if Successful
- Fast Load Confirmation is not available. Delete the data files after the loader
completes successfully. This option is unavailable if you selected Use Named Pipe.
- Delete files if Failure
- Fast Load Confirmation is not available. Delete the data files if the loader does
not complete successfully. This option is unavailable if you selected Use Named Pipe.
- Load When Source is Empty
- Complete the load if a table to be loaded contains no rows, deleting
any rows from the target. If not selected, empty source tables are
skipped.
Max Error
The maximum number
of rows (up to 2147483647) that the loader can discard because of
errors. Stop processing when the specified number of rows is discarded.
- To end the process if a single row is discarded,
specify 1 as the maximum.
- To allow an unlimited number of rows to be discarded,
specify zero (0) or leave blank.
Work Path for data files
Default
directory path for temporary loader files.
Additional Loader Parameters
You can augment the loader arguments
created automatically by the Optim solution
with additional loader parameters. The parameters you create are appended
to the list created automatically, but are not validated before starting
the loader. For valid operands, see the database loader documentation.
If additional loader parameters are forced from within product options,
you cannot modify them.