The following are tasks which must be completed before a stored procedure can be run on an XDB Server:
- Prepare the application according to your embedded SQL documentation for creating stored procedure DLLs.
- Define the stored procedure to the XDB Server. See
Defining Stored Procedures under SQL Option.
- 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.