Kbase P96180: SQL batch file to create dba user terminates without error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/2/2004 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
OpenEdge 10.x
Progress 9.1x
SYMPTOM(s):
Batch terminates without error
Using SQL batch file to create dba user
Using sysprogress account for access to database
Using -infile to call batch job
sqlexp -char -infile <infile name.sql> -outfile report.txt -db <dbname> -S <port#> -u <user name> -password <user password>
CAUSE:
Infile not pointing to location of batch job
FIX:
Set explicit path for file used with -infile in command line arguments
Example:
sqlexp -char <path to infile>/-infile name.sql -outfile report.txt -db <dbname> -S <port#> -u <user name> -p <user password>