Home
SQL File Import online help Prev Page Prev Page
Introduction
About SQL File Import
Version history
Contact us
Supported database engines
Using SQL File Import
Home page
Task Wizard
Select source data
Files as source data
CSV source data files
Excel source data files
Enter file search patterns
Connect to database
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
Database scripts
Select table to upload into
Map data to table columns
Review script results
Transaction options
Logging options
Finalise
Run task
Scheduling a task
Options
Scripting
Global variables
OnBeforeUpload function
OnAfterUpload function
Support functions
Data functions
Log functions
String functions
Date and time functions
Date-Time format strings
File functions

Global variables

SQL File Import defines a few global variables in the scripting engine, that can be used to retrieve and set additional details regarding the import process.
 
Variable name
 		Description
DMLType
 		This is the type of operation to perform on the row during the import process. Allowed values are as follows:
· dtInsert - indicates that this row is to be inserted  
· dtUpdate - indicates that this row is to be updated  
· dtDelete - indicates that this row is to be deleted  

For dmlUpdate and dmlDelete types, at least one target column needs to have the IsKeyField value set to True.

Default value is dtInsert.
SkipRecord
 		Set this value to True if you want SQL File Import to skip this row during the import.

Default value is False.
RowIndex
 		This is the current row number for the source data row that's being processed. It is incremented by SQL File Import for each new row.
_globalValues
 		This is a global array of 100 variants that you can use to store any additional details you want.