sysLib.loadTable

The system function sysLib.loadTable loads information from a file and inserts it into a relational database table. It is supported only in Java environments. The file must have been created using the sysLib.unloadTablefunction.

sysLib.unloadTable syntax diagram

filename

is a quoted string (CHAR variable or literal) specifying a file that contains the input data.

insertintoClause

Specifies the table and columns in which to store the new data.

delimiter

Is a quoted string (CHAR variable or literal) containing a delimiter symbol.

Standard delimiter symbols are commas and quotation marks. The following delimiter symbols are not allowed:

ASCII characters
The numbers 0-9
Backslash
New line character

To unload information from a relational database table and insert it into a file, use the sysLib.unloadTable function.