Filter
Top Products
ISQL and Tools
5-2 FairCom Corporation
• SELECT privileges on the tables named in the commands file
5.3 DBDUMP COMMAND LINE SYNTAX
The dbdump command accepts the commands file name, the database name and a command
option.
Syntax
dbdump -f commands_file [-n] database_name
Options
-f commands_file
Specifies the file containing dbdump commands.
-n
Parse the commands file and display errors, if any, without exporting data. If the parsing is suc-
cessful a message, No errors in the commands file. displays on stdout.
database
Name of the database.
5.4 DATA FILE FORMATS
The output data file can be defined to be having one of the following record formats:
• Variable length records
• Fixed length records
For both these types of records an optional field delimiter and an optional record delimiter can
be specified. The field delimiter, when specified, should be a single character. By default,
comma is the field delimiter. The record delimiter can be specified in the commands file and it
can be more than one character. By default, the newline character, \n, is the record delimiter.
5.5 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