A stored procedure is similar to any other SQL application.
The following restrictions apply to stored procedures:
- A C or COBOL stored procedure must be a dynamic link library (DLL) when built to run under Windows server.
- To use SQL Procedure Language, you need to have a C compiler installed since the SQL statements generate a C program.
- The following SQL statements are not allowed in a stored procedure:
- CONNECT
- DISCONNECT
- SET CONNECTION