Informix Stored Procedure Language (SPL) is an extension to SQL that provides flow control such as looping and branching. An SPL procedure is a routine written in SPL and SQL that does not return a value.

SPL procedure definitions provide the following information:

• The procedure name.
• Parameter attributes.
• Optionally, information about the SQL procedure that is used when the procedure is called. This information can include run-time options.

Important: If you use Visual Studio 2008, do not create stored procedures with names that are longer than 39 characters. Stored procedures with names that are longer than 39 characters can cause errors when you use the Visual Studio 2008 debugger and other components.

The following code shows an example CREATE PROCEDURE statement for a simple SPL procedure:

   CREATE PROCEDURE add_price (arg INT);
    

See Also

Developing IBM Database SQL and SPL Procedures | IBM Procedure Designer | Managing Procedures, Functions, and Objects

.NET Development Forum   developerWorks: Visual Studio .NET   IDS FAQs

© Copyright IBM Corporation 2002, 2019. All Rights Reserved.