DB Alias Tab for Netezza®

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.

Load Request Editor with DB alias for Netezza as the active tab. The elements are described in the following text.

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.



Feedback