Kbase P65460: Dump and Load for SQL-92 tables, sqldump and sqlload
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/22/2010 |
|
Status: Verified
GOAL:
sqldump and sqlload for SQL92 tables
GOAL:
Ascii dump and load for SQL-92 tables
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
"sqldump" is the utility for Ascii dump of SQL92 tables. The format of the records in the resulting file, of extension .dsql, is similar to the Progress 4GL .d file format. "sqlload" is the utility for loading data from a .dsql file.
The command below will create a dump file for all tables that user "tucker" (password "sulky") has authority to access and which name start with "cust" or "sale" and which owner's name start with "t", within the database "salesdb".
The code page for the dump files will be here ISO8859-2; if the "-C" option is not given, then the code page will be as set by the client's SQL_CLIENT_CHARSET environment variable.
sqldump -u tucker -a sulky -C ISO8859-2 -t t%.cust%, t%.sale% progress:T:thunder:4077:salesdb
The command below will load the first 1000 records (because of the optional
"-m 1000") of each file generated by the above "sqldump" within a database named "mysales".
sqlload -u tucker -a sulky -C ISO8859-2 -t t%.cust%, t%.sale% -m 1000 progress:T:thunder:5066:mysales
If the option "-n" is added to the sqlload command (prior to the database named in the JDBC-style URL:dbtype:T"host:portnum:dbname), no records would be loaded but the command would be checked for any syntax error.