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

Support functions

The scripting engine has a set of built-in functions to make scripting easier for you. The functions can be categorised into the following groups:

· data functions  
These functions help you read and write data from the source data files.  
 
· log functions  
These functions help you log your own messages in the SQL File Import execution log.  
 
· string functions  
These functions help you manipulate, extract, and format strings.  
 
· date and time functions  
These functions help you read and format date and time values.  
 
· file functions  
These functions help you copy, delete, retrieve file metadata, and compress files.