The IQ Loader Interface uses default values for delimiters, null handling, and character sets when writing to the data file or pipe, and when generating the LOAD TABLE script.
Group |
Key |
Values |
Default |
Description |
|---|---|---|---|---|
iq_loader |
rowdelim |
Any string. '\n' for line break. |
' \n ' |
Line delimiter |
iq_loader |
coldelim |
Any string. '\t' for tab. |
' |@#& ' |
Column delimiter |
iq_loader |
nullreplace |
Any string. If empty, NULL clause is not added to the load script. |
' [NULL] ' |
String used for NULL values |
iq_loader |
characterset |
Any character set supported by IQ. |
' ' (=auto) |
Encoding used in data file |