Nonstop Database, HiRDB Version 9 UAP Development Guide
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 |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.