Syntax
<column_id> ::= <valCOLUMN_NAME> | <valCOLUMN_ID>
valCOLUMN_NAME |
Column name |
valCOLUMN_ID |
Column ID |
Use
In a command for unloading application data, use it to assign a column of the source table to a data field of the
data stream.DATAEXTRACT cno, name, zip, place FROM customer
OUTFIELDS
cno 01-04
name 06-12
zip 14-18
place 20-31
OUTFILE 'customer.data' FORMATTED
The column number
valCOLUMN_ID indicates the position of the column in the SELECT statement.DATAEXTRACT cno, name, zip, place FROM customer
OUTFIELDS
1 01-04
2 06-12
3 14-18
4 20-31
OUTFILE 'customer.data' FORMATTED