Try OpenEdge Now
skip to main content
SQL Development
Stored Procedures and Triggers : Setting up OpenEdge SQL for stored procedures and triggers
 

Setting up OpenEdge SQL for stored procedures and triggers

OpenEdge ships with one of two scripts—$DLC/bin/sql_env or %DLC%\bin\sql_env.bat% to facilitate setting up the appropriate environment if you plan to use OpenEdge SQL to run stored procedures and triggers.
To run sql_env, the Java jdkl.4.x must be installed. The JDKHOME environment variable must be pointed to it on all platforms in which OpenEdge does not ship the jdk (IBM AIX, Unixware, Linuxx86).
The sql_env script should be executed after proenv.
* Enabling stored procedures on 64-bit platform databases