Routines for i_imprt.kb


AbortImportProcessing

File Name

i_imprt.kb

Syntax

None

Parameters

None

Returns

None

Side Effects

None

Description

Writes status and rolls back when import fails.

Dialog Forms Called

None


GetDBMSError

File Name

i_imprt.kb

Syntax

None

Parameters

None

Returns

None

Side Effects

None

Description

Returns the last DBMS error message text.

Dialog Forms Called

None


ImportCSVData

File Name

i_imprt.kb

Syntax

None

Parameters

None

Returns

None

Side Effects

None

Description

This function reads the CSV file, processes the file, and inserts all data. All records in the file are considered one unit of work. If the user chooses to abort the import, or if a failure occurs on a counter record update, then all transactions are rolled back. Otherwise, all transactions are committed.

Dialog Forms Called

None


RequestImportUtility

File Name

i_imprt.kb

Syntax

RequestImportUtility

Parameters

None

Returns

Nothing

Side Effects

None

Description

System action for import utility.

Dialog Forms Called

None


UpdateCountersTable

File Name

i_imprt.kb

Syntax

None

Parameters

tableName - name of table for which the counter must be updated

primaryKey - the primary key for the table

dataType - the data type of the primary key

Returns

None

Side Effects

None

Description

This function calls the appropriate function to update the counters table. There are two different functions to do this because primary keys may either be integer or character. This function makes the determination based on the data type of the primary key. If the update fails then the import must be aborted and all transactions will be rolled back. AbortImport:= TRUE. Assumptions (1) The name of the counter record in the Counters table must be the same as the table name. This is true for all TAM files with the exception of those that have been truncated due to the 15 character limit. However, in this case the first 15 characters are the same. (2) The first column in the CSV file is the primary key or Opaque ID for the file. --

Dialog Forms Called

None


WrapUpThisTable

File Name

i_imprt.kb

Syntax

None

Parameters

numSuccessCntr - number of successful inserts for this table

numFailureCntr - number of insert failures for this table

Returns

None

Side Effects

None

Description

Displays status and updates flags upon completion of a table in the CSV file.

Dialog Forms Called

None