Compiling Stored Procedures under SQL Option

To compile a stored procedure under SQL Option, carry out the following steps:

1. 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.
2. The build settings for a particular program can be viewed and changed on the Visual Studio Properties page associated with the program.
3. 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.
4. SQL Option requires a LOADLIB directory to be able to find .dll files that execute as stored procedures. When Enterprise Developer compiles programs, it typically places the .dll files in a LOADLIB directory under the project directory.