IBM Database Add-Ins for Visual Studio  

Developing IBM Database SQL and SPL Procedures

With the IBM® Database Add-Ins for Visual Studio, you can develop scripts to create IBM database SQL and SPL procedures.

This section provides conceptual information and instructions for using the add-ins to create and change IBM database SQL and SPL procedures.

In this section:

IBM Database SQL and SPL Procedures
Information about developing IBM database SQL and SPL procedures.
DB2 SQL Procedures
Conceptual information about DB2® SQL procedures.
Array Parameters in DB2 SQL Procedures
Conceptual information about using array parameters in DB2 SQL procedures on connections to DB2 for Linux®, UNIX®, or Windows®, Version 9.7 or later servers.
IDS SPL Procedures
Conceptual information about IDS SPL procedures.
Creating SQL and SPL Procedures
Instructions for adding a new SQL or SPL procedure.
Creating SQL and SPL Procedures from Existing Procedures
Instructions for using an existing SQL or SPL procedure to create a new one.
Creating Versions of Native SQL Procedures
Instructions for adding a new version of a DB2 for z/OS® native SQL procedure.
Making Native SQL Procedure Versions Active
Instructions for activating a version of a DB2 for z/OS native SQL procedure.
SQL Procedure Definition Changes
Conceptual information about how the changes that you make to a DB2 SQL procedure definition affect the contents of the procedure definition script.
Changing SQL and SPL Procedure Definitions
Instructions for modifying an SQL or SPL procedure definition.
Changing SQL and SPL Procedure Properties
Instructions for changing the properties of an existing SQL or SPL procedure in your IBM database project.

.NET Development Forum   DB2 FAQs   IDS FAQs

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