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. You can specify default values 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 |
