Examples: Stored procedures

View examples of Db2® for IBM® i procedures.

Example: Run CL commands that use SQL stored procedures and ODBC
Stored procedure support provides a means to run IBM i Control Language (CL) commands by using the SQL CALL statement.
Example: Stored procedure calls from Visual Basic with return values
The following example of Visual Basic source code shows how to call an Db2 for IBM i procedure and then retrieve the returned values into Visual Basic variables.
Example: Call an IBM i stored procedure by using Visual Basic
The Visual Basic programming examples listed below show an IBM i procedure call being prepared.
Example: Call CL command using SQL CALL statement
It is possible to run IBM i commands by using an SQL CALL statement. The two examples that are provided here apply to ODBC programs.
Tips: Run and call IBM i procedures
Use these tips for running and calling Db2 for IBM i procedures.

Parent topic: SQL and External procedures