FORMAT clause

The FORMAT clause allows you to select the output format of the data.

The following syntax diagram shows the FORMAT clause.

Attention: The FORMAT clause is not a block and does not require a semicolon at the end.
Figure 1. format_clause

1  FORMAT
1!  DEL?  INTO
2.1 tablename
2.1 qualifier.tablename?  MODIFIED BY del_modifiers
1  IXF?  INTO
2.1 tablename
2.1 qualifier.tablename?  MODIFIED BY ixf_modifiers
1  DELIMITED?  delimited_option
1  ASC 
2.1  INTO
2.2.1 tablename
2.2.1 qualifier.tablename
2.1  MODIFIED BY asc_modifiers
1  DSNTIAUL 
2.1  INTO
2.2.1 tablename
2.2.1 qualifier.tablename
1  XML 
2.1! COLATTVAL
2.1 COLATTVAL_XML
2.1 ROWTAGSTRING "tagname"
1  MIGRATION?  INTO
2.1 tablename
2.1 qualifier.tablename
1  JSON
1  ORC
1  PARQUET
1  EXTERNAL
2.1 TEXT
2.1 FIXED
2.1 BINARY
2.1  USING ( ext_options )
Continuation of the FORMAT DELIMITED option:
Figure 2. delimited_option

1 ?  INTO
2.1 tablename
2.1 qualifier.tablename
2.1 
2.2.1 
2.2.2.1 SEP
2.2.2.1 COLDEL
2.2.2.1 'char'
2.2.2.1 x'XX'
2.2.1 
2.2.2.1 DELIM
2.2.2.1 CHARDEL
2.2.2.1 'char'
2.2.2.1 x'XX'
2.1  MODIFIED BY delimited_modifiers
2.1 NULL DELIM
2.1  NULLVAL "value"
Continuation of the FORMAT EXTERNAL option:
Figure 3. ext_options

1  DECPLUSBLANK
2.1 PLUS
2.1 BLANK
1  QUOTEDVALUE
2.1 NO
2.1 SINGLE
2.1 DOUBLE
1  IGNOREZERO
2.1 FALSE
2.1 TRUE
2.1 KEEP
1  REMOTESOURCE
2.1 LOCAL
2.1 YES
2.1 GZIP
2.1 LZ4
1  TRIMBLANKS
2.1 NONE
2.1 LEADING
2.1 TRAILING
2.1 BOTH
1 
2.1 CRINSTRING
2.1 CTRLCHARS
2.1 FILLRECORD
2.1 LFINSTRING
2.1 NOLOG
2.1 REQUIREQUOTES
2.1 STRICTNUMERIC
2.1 TIMEROUNDNANOS
2.1 TRUNCSTRING
2.1 FALSE
2.1 TRUE
1  ENCODING DBCS_GRAPHIC
1 
2.1 CARDINALITY
2.1 MAXERRORS
2.1 MAX_ROWS
2.1 SKIPROWS
2.1 SOCKETBUFSIZE
1 nn
1 
2.1 LOGDIR
2.1 NULLVALUE
1 "value"
1 
2.1 DECIMALDELIM
2.1 DELIMITER
2.1 ESCAPECHAR
2.1 RECORDDELIM
1 'char'
1 
2.1 S3
2.1 AZURE
1 "alias"