Application Development Guide

Appendix C. DB2DARI and DB2GENERAL Stored Procedures and UDFs

  • DB2DARI Stored Procedures
  • Using the SQLDA in a Client Application
  • Using Host Variables in a DB2DARI Client
  • Using the SQLDA in a Stored Procedure
  • Data Structure Manipulation
  • Summary of Data Structure Usage
  • Input/Output SQLDA and SQLCA Structures
  • Return Values for DB2DARI Stored Procedures
  • DB2GENERAL UDFs and Stored Procedures
  • Supported SQL Data Types
  • Classes for Java Stored Procedures and UDFs
  • COM.ibm.db2.app.StoredProc
  • COM.ibm.db2.app.UDF
  • COM.ibm.db2.app.Lob
  • COM.ibm.db2.app.Blob
  • COM.ibm.db2.app.Clob
  • NOT FENCED Stored Procedures
  • Example Input-SQLDA Programs
  • How the Example Input-SQLDA Client Application Works
  • C Example: V5SPCLI.SQC
  • How the Example Input-SQLDA Stored Procedure Works
  • C Example: V5SPSRV.SQC

    • This chapter describes how you can write DB2DARI and DB2GENERAL parameter style stored procedures and DB2GENERAL UDFs.

    [ Top of Page | Previous Page | Next Page ]