FairCom ISQL

The Commands File

The commands file specifies:

• Record format for the output file
• Query which is to be used for exporting data

There is no file naming convention for the commands file. For example, the commands file name to load the ORDERS table could be orders.cmd.

The commands file must contain the following parts:

• The DEFINE RECORD statement
• The FOR RECORD statement

The syntax definition for the commands file is as shown:

dbdump_commands:

define_record_statement

for_record_statement

The following is sample commands file showing dump instructions.

DEFINE RECORD ord_rec AS

( ord_no, item_name, date, item_qty ) FIELD DELIMITER ' ' ;

FOR RECORD ord_rec dump into ord_dat

USING SELECT order_no, product, order_date, qty

FROM items;

In This Section The DEFINE RECORD Statement The FOR RECORD Statement