The IQ Loader Interface uses default values for delimiters, null handling and character set when writing to the data file or pipe, and when generating the LOAD TABLE script. The default values can be specified in the ETL Server INI files as follows:
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 |
