FIELDS

Specifies the names of the fields for the XDB Server table being created. The syntax of the statement is:

FIELDS = field-name1 [, field-name2]. . .;  

where the field names are listed in order, and separated by commas (,).

The FIELDS command is optional if you are creating your own Batch Export file and you are querying all fields in a table. If specific fields are being queried, those fields must be specified using the FIELDS command.

For example:

FIELDS = e_no,lname,fname,street,city,st,zip,dept,payrate,com;

will export a file into a new table with field names similar to the EMPLOYEE table in the tutorial.