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 ae2h4 before being transmitted over the network.

For more information, see genpassword and Encoding prefix.

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.
Note:
  • The SQLDUMP utility does not support dumping a table containing a CLOB or BLOB column. A request to dump a table with a CLOB or BLOB column will result in an error message, and that table will be skipped.
  • To dump a table containing a CLOB or BLOB column, use the DB binary dump/ PROUTIL utility. For detailed information, see PROUTIL DUMP qualifier topic of the OpenEdge Data Management: Database Administration guide.