sysLib.unloadTable

The system function sysLib.unloadTable unloads information from a relational database table and inserts it into a file. It is supported only in Java environments.


sysLib.unloadTable syntax diagram

filename

Is a quoted string (CHAR variable or literal) specifying the name of an output file.

selectStatement

Specifies which rows to copy into filename.

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 load information from a file and insert it into a relational database table, use the sysLib.loadTable function.

Related reference
File and database (system words)
sysLib.loadTable
System words in alphabetical order