To compile a stored procedure under SQL Option, carry out the following steps:
- The project used for stored procedure development should always be declared as "Uses SQL". To indicate that an existing project uses SQL, click
Project Settings on the
Project
menu, then select
Project uses SQL on the SQL tab.
- The build settings for a particular program can be viewed and changed on the Visual Studio Properties page associated with the program.
- To use the ECM SQL preprocessor, check the Preproc tab of the Build Settings dialog box and ensure that
EXEC SQL is checked. If additional directives are needed, for instance the PKGSET directive to emulate SET CURRENT PACKAGESET functionality, click the
More button next to the
EXEC SQL checkbox and specify the directives there.
- SQL Option requires a LOADLIB directory to be able to find
.dll files that execute as stored procedures. When
Studio Enterprise Edition compiles programs, it typically places the
.dll files in a LOADLIB directory under the project directory.
