Features of a Stored Procedure

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