FIELDS

Restriction: This topic applies to Windows environments only.

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 Batch Import command is required for every transaction when importing a file that does not include the table headings (as specified with the HEADING Batch Import command). If field names are provided in the file being imported, those names can be used as default field names. Otherwise the field names must be specified.

For example:

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

will import a file into a new table with field names similar to the EMPLOYEE table in the TUTORIAL location.