Kbase P132167: SQL: Unable to execute SQL script using the SQL Explorer Tool from the command line.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/11/2009 |
|
Status: Verified
SYMPTOM(s):
SQL: Unable to execute SQL script using the SQL Explorer Tool from the command line.
The command just opens the SQL Explorer but fails to run the statements in the SQL script file.
The command syntax used from a proenv session is:
sqlexp -S ProtNumber -H HostName -db DatabaseName -user UserName -password UserPassword < FileName.sql
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
OpenEdge Category: SQL
CAUSE:
The command syntax used to execute the SQL statements in the SQL script file is incorrect.
FIX:
Use the correct syntax for the SQL character mode tool. For example:
sqlexp -char -db DatabaseName -S 12345 -infile FileName.sql -outfile FileName.out -user UserName -password UserPassword
Where:
FileName.sql is the file containing the SQL statements to be executed, and
FileName.out is the file containing the result set or the execution log generated by running the SQL statements in the script file