FairCom ISQL

Data Unload Utility: dbdump

This chapter describes the c-treeSQL database dump utility, dbdump.

dbdump writes the data in a database to a file. The format of the exported data is specified by the record description given in an input command file to dbdump.

Both dbload and dbdump commands files use DEFINE RECORD statements with similar syntax to specify the format of loaded or exported data records. The commands file specifies the data file, the format of data records, and the destination (or source) database columns and tables for the data.

Prerequisites for dbdump

Before running dbdump, you need:

• A valid, readable commands file
• SELECT privileges on the tables named in the commands file

In This Chapter dbdump Command-Line Syntax Data File Formats The Commands File Examples