Syntax
<output_column_list> ::= <
output_column> | <output_column> <output_column_list>Use
Use this syntax rule in a
DATAEXTRACT command to describe the columns to be unloaded of a source table and the representation of the data records in the data stream.Rules
Definition of the source table:
create table customer (cno char (4), name char (6) NOT NULL, zip integer, city char (11), PRIMARY KEY (cno))
Unload command:
DATAEXTRACT * from customer
OUTFIELDS
cno 01-04
name 06-12
zip 14-18
city 20-31
OUTFILE 'customer.data' FORMATTED;