Mapping of external table options
You can specify external table options as part of an SQL command, on the command line for the nzload command, or in the control file for the nzload command. The option names depend on where you specify them.
The following table lists the equivalent external table options that you can specify for SQL commands, on the command line for the nzload command, or in the control file for the nzload command. Option names are not case sensitive.
| External table options for SQL commands | External table options for the nzload command: command line | External table options for the nzload command: control file |
|---|---|---|
| Not applicable | -bf | badfile bf |
| BoolStyle | -boolStyle | boolstyle |
| Compress | -compress | compress |
| CRinString | -crInString | crinstring |
| CtrlChars | -CtrlChars | ctrlchars |
| DataObject | -df | datafile |
| DateDelim | -dateDelim | datedelim |
| DateStyle | -dateStyle | datestyle |
| DateTimeDelim | -dateTimeDelim | datetimedelim |
| DecimalDelim | -decimaldelim | decimaldelim |
| DelimDelimiter | -delim -delimiter |
delim delimiter |
| Encoding | -encoding | encoding |
| EscapeEscapeChar | -escape -escapeChar |
escape escapechar |
| FillRecord | -fillRecord | fillrecord |
| Format | -format | format |
| IgnoreZero | -ignoreZero | ignorezero |
| IncludeHeader | Not applicable | Not applicable |
| IncludeZeroSeconds | Not applicable | Not applicable |
| Layout | -layout | layout |
| Not applicable | -lf | logfile lf |
| LFinString | -lfInString | lfinstring |
| LogDir | -outputDir | outputdir |
| MaxErrors | -maxErrors | maxerrors |
| MaxRows | -maxRows | maxrows |
| MeridianDelim | -meridianDelim | meridiandelim |
| NullValue | -nullValue | nullvalue |
| QuotedValue | -quotedValue | quotedvalue |
| RecordDelim | -recdelim | recorddelim |
| RecordLength | -reclength | recordlength |
| RemoteSource | -host | Not applicable |
| RequireQuotes | -requireQuotes | requirequotes |
| SkipRows | -skipRows | skiprows |
| SocketBufSize | -fileBufSize -fileBufByteSize |
socketbufsize |
| TimeDelim | -timeDelim | timedelim |
| TimeRoundNanos TimeExtraZeros |
-timeRoundNanos -timeExtraZeros |
timeroundnanos timeextrazeros |
| TimeStyle | -timeStyle | timestyle |
| TruncString | -truncString | truncstring |
| Y2Base | -y2Base | y2base |
For descriptions of most of the external table options in the table, see External table options. For descriptions of external table options and other options for the nzload command, see nzload command syntax and nzload control file.