Example

The following text file contains owner, table, and column information in the first line, and the table's schema in the second line. Subsequent lines contain raw data. Semicolons delimit columns. Single quotes qualify non-binary data; double quotes qualify binary data. The LONGVARCHAR and LONGVARBINARY columns display temporary file names (the data has been stored as file objects), and binary data is padded with "9".

"SYSADM"."EXPORT"."LOGINID";"SYSADM"."EXPORT"."REQUEST";"SYSADM"."EXPORT".
"REQUESTTIME";"SYSADM"."EXPORT"."ATTACHMENT";"SYSADM"."EXPORT"."BINARY_C";"SYSADM"."EXPORT"."DECIMAL_C"
SQL_CHAR(20);SQL_LONGVARCHAR;SQL_TIMESTAMP;SQL_FILE;SQL_BINARY(10);SQL_DECIMAL(10, 3)
'A_HOWARD ';'blobtmpdir2\\blbtmpf0.txt';'21-09-09 12:47:05.0';'C:\\DBMAKER\\4.0\\BIN\\WEBDB\\FO\\ZZ0B.GIF';"10"9;10.250
'A_HOWARD ';'blobtmpdir2\\blbtmpf1.txt';'21-09-22 10:14:21.0';'C:\\DBMAKER\\4.0\\BIN\\WEBDB\\FO\\ZZ0C.GIF';"20"9;13.550
'A_HOWARD ';'blobtmpdir2\\blbtmpf2.txt';'21-10-04 16:22:06.0';'C:\\DBMAKER\\4.0\\BIN\\WEBDB\\FO\\ZZ0D.GIF';"30"9;27.333


Related topic:

Data Transfer
Importing Data from Text