File Name
Syntax
None
Parameters
None
Returns
None
Side Effects
None
Description
Writes status and rolls back when import fails.
Dialog Forms Called
None
File Name
Syntax
None
Parameters
None
Returns
None
Side Effects
None
Description
Returns the last DBMS error message text.
Dialog Forms Called
None
File Name
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
File Name
Syntax
RequestImportUtility
Parameters
None
Returns
Nothing
Side Effects
None
Description
System action for import utility.
Dialog Forms Called
None
File Name
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
File Name
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