List of Sample UAPs

The following table lists the sections where sample UAPs can be found.

Table M-1 List of sample UAPs

Classification	Description	Section
Creating stored routines	Numbering using a stored procedure	4.2.2(7)
	Defining and calling an SQL stored procedure	4.3.1(3)
	Using the results-set return facility to define and call an SQL statement procedure	4.3.1(6)(c)
	Defining and calling an SQL stored function	4.3.2(2)
	External Java stored routine program	9.3
	Java stored procedure program that uses the results-set return facility	9.4.5(3)
	External C stored routine program	10.3
Using arrays	Coding the FETCH facility using arrays	4.8.1(4)
	Coding the INSERT facility using arrays	4.8.2(4)
	Coding the UPDATE facility using arrays	4.8.3(4)
	Coding the DELETE facility using arrays	4.8.4(4)
Using the multi-connection facility	Coding the multi-connection facility	4.10(3)
Using the locator facility	Coding the locator facility	4.16.4
Creating UAPs in C language	Example of basic operation	7.2.2(1)
	Example that uses a user-defined SQL descriptor area	7.2.2(2)
	Example of manipulating LOB data	7.2.2(3)
	Eliminating the embedded SQL declare section	8.2.5(2)
	Example that uses the structures of C language	8.2.7(3)
	Using hash partitioning	H.1(5)
	Retrieving records	HiRDB First Step Guide
Creating UAPs in COBOL	Example of basic operation	7.3.2(1)
	Example that uses a row interface	7.3.2(2)
	Example that uses the TYPE, TYPEDEF, and SAME AS clauses	7.3.2(3)
	Retrieving records	HiRDB First Step Guide
Executing commands from UAPs	UAP that loads data	12.2
Using the HiRDB.NET data provider	Connecting to the database	16.11.1
	Executing SQL statements	16.11.2
	Executing transactions	16.11.3
	Executing retrieval statements	16.11.4
	Executing the INSERT facility by using arrays	16.11.5
	Executing repetition columns	16.11.6
	Checking for an error in SQL statements and acquiring error information	16.11.7
Using DataSource and JNDI (Type2 JDBC driver)	Registering DataSource into JNDI	17.4.1(3)
	Acquiring DataSource from JNDI	17.4.1(4)
	Connecting to the database	17.4.1(5)
Using DataSource and JNDI (Type4 JDBC driver)	Registering DataSource into JNDI	18.3(3)
	Acquiring DataSource from JNDI	18.3(4)
	Connecting to the database	18.3(5)
Using a JDBC driver	UAP that uses a JDBC driver	18.16
Using SQLJ	Coding connection to and disconnection from a HiRDB server	19.3.7
	Coding data retrieval using the cursor	19.3.8
	Receiving a dynamic result set	19.3.9
	Operation with JDBC	19.3.10
	Coding that uses a native interface	19.4.4
	Retrieving records	HiRDB First Step Guide

Appendix M. List of Sample UAPs