OPTIONS clause

The OPTIONS clause enables you to configure preferences related to the data output.

The following diagram shows the syntax for the options clause.

Attention:
  • The OPTIONS clause is not a block and does not require a semicolon at the end.
  • The OPTIONS keyword at the beginning of the clause is optional.
Figure 1. options_clause

1?  OPTIONS
1 DATE DATE_X
1  DATEDELIM 'char'
1 TIME TIME_X
1  TIMEDELIM 'char'
1 TIMESTAMP TIMESTAMP_X
1  TIMESTAMPDELIM 'char1' 'char2'
1  SECFRAC
2.1 n
1  LLS
2.1! OFF
2.1 ON
1  DOUBLE
DELIM
2.1! BINARY
2.1 OFF
2.1 ON
1  NULL
2.1  'char1' 'char2'
2.1 OFF
1  NULLID
2.1 YES
2.1 NO
1  NULLPOS
2.1 AFTER
2.1 BEFORE
1  EOL
2.1! OFF
2.1 ON
2.1 'char'
1  XDS
2.1! OFF
2.1 ON