dbdump

The dbdump utility writes data from a isCOBOL SQL Server file to an output file.

Usage:

dbdump -f commands_file [-u user_name] [-a password] [-n] database_name

Where:

•	command_file is the script file containing the dump commands. Consult http://www.faircom.com/doc/isql/ (Data Unload Utility: dbdump -> The Commands File) for details on this kind of files. The following snippet shows a sample command_file:

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;

•	database_name is the name of the destination database

•	options can be one or more of the following:

o	-u user_name: user name to connect to the database.

o	-a password: password to connect to the database.

-n: parse the commands file and display errors, if any, without doing the database load.