Restrictions on external table options for data unloading

Not all external table options are supported for unloads.

The following external table options are not supported for unloads:
  • CtrlChars
  • FillRecord
  • IgnoreZero
  • Layout
  • LFinString
  • LogDir
  • MaxErrors
  • MaxRows
  • QuotedValue
  • RecordLength
  • RequireQuotes
  • SkipRows
  • TimeRoundNanos and TimeExtraZeros
  • TruncString
  • Y2Base
Also, the two-digit format of the DateStyle external table option is not supported for unloads.

The IncludeZeroSeconds external table option is used only for unloads.