Kbase P21053: How to start the SQL explorer tool from 4GL?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/12/2003 |
|
Status: Unverified
GOAL:
How to connect to an SQL-92 database server from 4GL?
FACT(s) (Environment):
Progress 9.x
FIX:
The following 4GL code invokes the character version of the Progress SQL Explorer tool to connect to the sports database server and executes the statement "SELECT * FROM PUB.Customer" outputing its returned result into a text file:
DEFINE VARIABLE cExecutableCommand AS CHARACTER NO-UNDO.
ASSIGN
cExecutableCommand = "C:\PROGRESS\91D\bin\SQLEXP" + " " +
"-char -S sports -H xpshanshiry -db sports" + " " +
"-command ~"select * from pub.customer~" -outfile c:\DLCWRK\sqlresult.txt".
OS-COMMAND VALUE(cExecutableCommand).