Kbase P22574: What is sql_env and when to use it?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/9/2008 |
|
Status: Verified
GOAL:
What is sql_env and when to use it?
FACT(s) (Environment):
Progress 9.1D
All Supported Operating Systems
Progress 9.1E
OpenEdge 10.x
FIX:
Starting with 9.1D06, there will be a sql_env in $DLC/bin (for windows, it is a bat in %DLC%\bin)directory. This script is designed to setup the environment for sql-92 products.
Customer can manually execute sql_env to have the above environment set up.
Note following:
1. JDKHOME must be set to point to JDK 1.3 and above installation for those platforms where no jdk shipped by PSC before running sql_env. JREHOME
will NOT be asked unless either DLC/jre or JDKHOME/jre exists.
2. sql_env should be run after the proenv script
3. sql_env is required on Linuxx86 for any sql-92 application even proserve is used to start up the database
4. sql_env is required on all platforms for any sql-92 jdbc or odbc application
5. sql_env is required on all Unix platforms for sql-92 Java stored procedure or trigger if the database is NOT started with the PROSERVE script.
6. sql_env is required on Windows platform for sql-92 Java stored procedure or trigger under the "proenv>" environment.