SQLDUMP

SQLDUMP lets you dump SQL databases. The syntax for SQLDUMP (for UNIX and Windows) is:

sqldump -u username -a password -t table-name[,table-name...] database-url[-C charset][-F { comma | quote }][-f command-filename][-n error-check]

username, password

User authentication.

The SQLDUMP utility accepts all encoding prefixes supported by the genpassword utility for encoding passwords before transmitting them over the network to the OpenEdge SQL server for authentication. If the password is provided in plain text, it is encoded using aedh0 before being transmitted over the network.

For more information, see genpassword and Encoding prefix.

Note: If the server is running an OpenEdge database of release 12.8 or earlier, it does not support the aedh0 encoding prefix and cannot decode passwords encoded with it. The connection fails with an error message.

table-name [,table-name...]

One or more tables to dump. Multiple tables can be specified, in a comma-separated list. Specify a table of % to dump all tables. The -t option can be specified only if the -f option is not.

database-url

The database to which you want to connect, which has the following form:

progress:T:host-name:service-name:database-name

charset

The name of the character set of the tables to be dumped.

{ comma | quote }

If comma is specified, dump in comma-delimited format. If quote is specified, dump in quote-delimited format. The default is quote.

command-filename

Specifies the file where SQLDUMP reads commands on how and what to dump. The -f option can be specified only if the -t option is not.

error-check

Check for syntax errors without dumping any rows.