Chapter 5

Data Unload Utility: dbdump

5.1INTRODUCTION

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.

The following figure shows the dbdump execution process.

Figure 5-1: dbdump Execution Process

dbdump

Commands file

Data file

c-treeSQL Engine

c-tree Plus

Database

5.2PREREQUISITES FOR DBDUMP

Before running dbdump, you need:

•A valid, readable commands file

FairCom Corporation

5-1