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.