DB Alias Tab for SQL Server

Insert

Insert the rows from the source file into the destination tables. If the primary key values match, duplicate rows are discarded or inserted into the error file (if specified).

Replace

Clear all data in the destination tables and replace with rows from the source file.

Create

Create a discard file to use during the load process.

Max Errors

The number of rows (up to 999999999) 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.

Perform Load

Run the loader automatically after file conversion. Options to disable triggers and constraints apply. Clear to convert the data and create a BAT file. To run the loader, you must edit the BAT file to include password information, ensure that destination tables are empty, and run.

Delete files if Successful

Delete load files after the loader completes successfully. Fast load confirmation is not available.

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.

Delete files if Failure

Select to delete the load files if the loader does not complete successfully. Fast load confirmation is not available.

Never

Never disable database triggers for the loader.

Always

Disable database triggers during the load process and re-enable triggers when the process is completed.

Prompt

Display the Disabling Trigger/Constraint Confirmation dialog to list tables with associated triggers. Right-click the Status After Process column to enable or disable the corresponding trigger or constraint after the load completes.

Never

Never disable referential integrity constraints for the loader. This option causes a warning message when you run the loader.

Always

Disable constraints during the load process and re-enable constraints when the process is completed.

Prompt

Display the Disabling Trigger/Constraint Confirmation dialog to list tables with associated constraints. Right-click the Status During Process column to enable or disable the corresponding trigger or constraint during the load. Right-click the Status After Process column to enable or disable the corresponding trigger or constraint after the load completes.

You can augment the loader arguments created automatically 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.

Supply the -T parameter to instruct the loader to use the network logon as user ID and password. Otherwise, -U and -P parameters (user ID and password) are used when starting the loader.

Default directory path for temporary loader files.