Preparing Stored Procedures

The following are tasks which must be completed before a stored procedure can be run on an XDB Server:

1. Prepare the application according to your embedded SQL documentation for creating stored procedure DLLs.
2. Define the stored procedure to the XDB Server. See Defining Stored Procedures under SQL Option.
3. Place the stored procedure DLL on the XDB Server machine in a location accessible by the XDB Server. The XDB Server uses the appropriate operating system call for loading the stored procedure, and searches the directory cited by the StProcLoadLib entry in the XDB.INI's server section for that stored procedure.