Nonstop Database
HiRDB Version 9
UAP Development Guide
3020-6-456-10(E)
Contents
- Notices
- Preface
- 1. Overview
- 1.1 UAP development flow
- 1.2 UAP characteristics
- 1.2.1 UAP format
- 1.2.2 List of SQL statements usable in HiRDB
- 1.3 Interface with HiRDB
- 1.4 UAP operation environment
- 2. Database Operations
- 2.1 Database data expressions
- 2.1.1 Relational database tables
- 2.1.2 Object relational database tables
- 2.2 Cursor usage
- 2.3 Data retrieval
- 2.3.1 Retrieval from a single table
- 2.3.2 Retrieval from multiple tables
- 2.3.3 Retrieval of a table with FIX attribute
- 2.4 Data updating
- 2.4.1 Updating using a cursor
- 2.4.2 Updating with a condition specified
- 2.4.3 Updating a table with the FIX attribute
- 2.4.4 Updating a table with repetition columns
- 2.5 Data deletion
- 2.5.1 Deletion using a cursor
- 2.5.2 Deletion with a condition specified
- 2.5.3 Deleting all rows in a table
- 2.6 Data insertion
- 2.6.1 Inserting rows on a column basis
- 2.6.2 Inserting rows on a row basis (to a table with the FIX attribute)
- 2.6.3 Inserting rows into a table with repetition columns
- 2.7 Specific data search
- 2.7.1 Searching for data within a specified range of values
- 2.7.2 Searching for a specific character pattern
- 2.7.3 Searching for non-NULL data
- 2.7.4 Searching for data that satisfies multiple conditions
- 2.7.5 Searching for data using a Boolean predicate
- 2.7.6 Searching for data using a structured repetition predicate
- 2.7.7 Searching for data using a subquery
- 2.8 Data operations
- 2.8.1 Arithmetic operations on numeric data
- 2.8.2 Date and time data operations
- 2.9 Data processing
- 2.9.1 Data grouping
- 2.9.2 Data sorting
- 2.9.3 Duplicated data elimination
- 2.10 Outer joining of tables
- 2.11 Defining and manipulating a view table
- 2.12 Manipulating data in a table with abstract data types
- 2.12.1 SGMLTEXT type
- 2.12.2 XML type
- 2.12.3 User-defined abstract data types
- 3. UAP Design
- 3.1 Basic SQL configuration in a UAP
- 3.2 Overview of UAPs
- 3.2.1 UAP descriptive languages
- 3.2.2 Interface areas
- 3.2.3 Integrity constraints
- 3.2.4 Retrieval methods using SQL statements
- 3.2.5 Static and dynamic SQLs
- 3.3 Transaction control
- 3.3.1 Connection to and disconnection from a HiRDB system
- 3.3.2 Transaction startup and termination
- 3.3.3 Synchronization point setting and rollback
- 3.3.4 UAP transaction management in an OLTP environment
- 3.3.5 Moving a transaction
- 3.4 Locking
- 3.4.1 Units of locking
- 3.4.2 Lock modes
- 3.4.3 Lock period
- 3.4.4 Deadlocks and corrective measures
- 3.4.5 Unlocked conditional search
- 3.4.6 Non-locking of index key values
- 3.4.7 Locking uncommitted data to be deleted
- 3.4.8 Locking by UAPs
- 3.4.9 Lock sequence based on SQL statement and index types
- 3.4.10 Lock sequence for rows
- 3.4.11 Creating locked resources for index key values
- 3.5 Use of a cursor
- 3.5.1 Notes on table operations when a cursor is used
- 3.5.2 FOR UPDATE and FOR READ ONLY clauses
- 3.5.3 Cursor declarations and locks
- 3.5.4 Holdable cursor
- 3.5.5 Examples of cursor use
- 3.6 SQL error identification and corrective measures
- 3.6.1 Error identification
- 3.6.2 Automatic error identification
- 4. UAP Design for Improving Performance and Handling
- 4.1 Using indexes
- 4.1.1 Indexes and processing time
- 4.1.2 Index priority
- 4.1.3 Changing indexes during retrieval
- 4.1.4 Notes about index searches
- 4.2 Manipulation of tables
- 4.2.1 Tables with the FIX attribute
- 4.2.2 Tables used in numbering
- 4.2.3 Tables using character sets
- 4.3 Stored procedures and stored functions
- 4.3.1 Defining a stored procedure
- 4.3.2 Defining a stored function
- 4.3.3 Defining and deleting stored functions
- 4.4 Triggers
- 4.5 SQL optimization
- 4.5.1 SQL optimizing modes
- 4.5.2 Optimization method types
- 4.5.3 Specifying SQL optimization
- 4.5.4 Allocating floatable servers (HiRDB/Parallel Server only)
- 4.5.5 Grouping processing methods (HiRDB/Parallel Server only)
- 4.5.6 Join methods
- 4.5.7 Search Methods
- 4.5.8 Execution of subqueries with no external references
- 4.5.9 Execution of subqueries with external references
- 4.5.10 Preparing for application of hash join and subquery hash execution
- 4.5.11 Deriving high-speed search conditions
- 4.6 Data guarantee levels
- 4.6.1 Specifying the data guarantee level
- 4.6.2 Data guarantee level types
- 4.6.3 Example of search results when a data guarantee level is specified
- 4.7 Block transfer facility
- 4.8 Facilities using arrays
- 4.8.1 FETCH facility using arrays
- 4.8.2 INSERT facility using arrays
- 4.8.3 UPDATE facility using arrays
- 4.8.4 DELETE facility using arrays
- 4.9 Rapid grouping facility
- 4.9.1 Overview
- 4.9.2 Application criteria
- 4.9.3 Specification method
- 4.9.4 Tuning method
- 4.10 Multi-connection facility
- 4.11 Narrowed search
- 4.11.1 What is a narrowed search?
- 4.11.2 Preparations for executing a narrowed search
- 4.11.3 Search using lists
- 4.11.4 Action if a rollback occurs for a transaction that uses a list
- 4.11.5 Automatic list deletion at HiRDB startup and termination
- 4.11.6 Notes about using lists
- 4.12 File output facility for BLOB data
- 4.12.1 What is the file output facility for BLOB data?
- 4.12.2 Application criteria
- 4.12.3 Specification method
- 4.12.4 Notes about using the file output facility for BLOB data
- 4.12.5 Examples of using the file output facility for BLOB data
- 4.13 Partial update and retrieval of BLOB and BINARY data
- 4.13.1 About partial update and retrieval of BLOB and BINARY data
- 4.13.2 Examples of using the addition update and partial extraction facility for BLOB data
- 4.13.3 Notes about performing partial updating and retrieval of BLOB and BINARY data
- 4.14 Retrieve first n records facility
- 4.14.1 Overview
- 4.14.2 Notes
- 4.14.3 Checking the access path
- 4.15 Automatic reconnect facility
- 4.15.1 Application criteria
- 4.15.2 Reconnect timings
- 4.15.3 CONNECT processing during automatic reconnect
- 4.15.4 Notes about using the automatic reconnect facility
- 4.16 Locator facility
- 4.16.1 What is the locator facility?
- 4.16.2 Application standard
- 4.16.3 Usage method
- 4.16.4 Usage example
- 4.17 Facility for returning the total number of hits
- 4.17.1 Overview
- 4.17.2 Usage examples
- 4.17.3 Note
- 4.18 Retrieval, updating, or deletion with an RDAREA name specified
- 4.18.1 Overview of function
- 4.18.2 Example
- 4.18.3 Notes
- 4.19 Automatic numbering facility
- 4.19.1 About sequence generators
- 4.19.2 Defining a sequence generator
- 4.19.3 Deleting a sequence generator
- 4.19.4 Acquiring the sequence numbers generated by a sequence generator
- 4.19.5 Examples
- 4.19.6 Notes
- 5. Notes about Creating UAPs that Access Object Relational Databases
- 5.1 Using abstract data types and user-defined functions
- 5.2 Restrictions on functions provided by plug-ins
- 6. Client Environment Setup
- 6.1 Types of HiRDB clients
- 6.2 Environment setup procedure for HiRDB clients
- 6.3 HiRDB client installation
- 6.3.1 Installing a HiRDB client on a UNIX client
- 6.3.2 Installing a HiRDB client on a Windows client
- 6.4 Organization of directories and files for a HiRDB client
- 6.4.1 Directories and files for UNIX clients
- 6.4.2 Directories and files for Windows clients
- 6.5 Setting the hosts file
- 6.6 Client environment definitions (setting environment variables)
- 6.6.1 Environment setup format
- 6.6.2 Specifications for using a UAP under OLTP as the client
- 6.6.3 Client environment definitions
- 6.6.4 Environment definition information
- 6.6.5 Environment variables and connection types for HiRDB servers
- 6.7 Registering an environment variable group
- 6.7.1 Registering an environment variable group in a UNIX environment
- 6.7.2 Registering an environment variable group in a Windows environment (registry registration)
- 6.7.3 Registering an environment variable group in a Windows environment (file registration)
- 7. UAP Creation
- 7.1 Overview
- 7.1.1 UAP basic configuration
- 7.1.2 UAP configuration elements
- 7.2 Writing a UAP in C
- 7.2.1 Coding rules
- 7.2.2 Program example
- 7.3 Writing a UAP in COBOL
- 7.3.1 Coding rules
- 7.3.2 Program example
- 7.4 Writing a UAP in C++
- 7.4.1 Coding rules
- 7.5 Writing a UAP in OOCOBOL
- 7.5.1 Coding rules
- 7.6 Creating a UAP in 64-bit mode
- 8. Preparation for UAP Execution
- 8.1 UAP execution procedure
- 8.1.1 Executing a UAP written in C
- 8.1.2 Executing a UAP written in COBOL
- 8.2 Preprocessing
- 8.2.1 Overview
- 8.2.2 Preprocessing in UNIX
- 8.2.3 Preprocessing in Windows
- 8.2.4 Validating preprocessor declaration statements
- 8.2.5 Dispensing with the embedded SQL declare section
- 8.2.6 Specifying pointers as environment variables
- 8.2.7 Referencing structures
- 8.2.8 Use of pointers, structures, and structure qualifiers when the -E2 or -E3 option of the preprocessor is specified
- 8.3 Compiling and linking
- 8.3.1 Libraries for compiling and linking
- 8.3.2 Compiling and linking in UNIX
- 8.3.3 Compiling and linking in Windows
- 8.3.4 Compiling and linking when the multi-connection facility is used
- 8.4 Notes
- 8.4.1 Notes on UAP execution
- 8.4.2 Executing UAPs that use an X/Open-based API (TX_function)
- 8.4.3 UAP execution using the Unicode functionality of COBOL2002
- 8.4.4 Converting UAPs created with XDM/RD or UNIFY2000
- 8.4.5 Actions required when HiRDB is upgraded
- 9. Java Stored Procedures and Java Stored Functions
- 9.1 Overview
- 9.2 Procedure from external Java stored routine creation to execution
- 9.2.1 Creating an external Java stored routine
- 9.2.2 Registering the JAR file
- 9.2.3 Defining the external Java stored routine
- 9.2.4 Executing the external Java stored routine
- 9.3 Sample external Java stored routine programs
- 9.3.1 Sample program
- 9.3.2 Sample external Java stored routines provided with HiRDB
- 9.4 Notes about Java program creation
- 9.4.1 Using a Type 2 or 4 JDBC driver
- 9.4.2 Unsupported methods
- 9.4.3 Package, class, and method definitions
- 9.4.4 Parameter input/output mode mapping (Java stored procedures only)
- 9.4.5 Results-set return facility (Java stored procedures only)
- 9.4.6 Connection in a Java stored procedure
- 9.4.7 Releasing the result sets
- 9.5 Notes about testing and debugging
- 9.5.1 Java program for a Java stored procedure
- 9.5.2 Java program for a Java stored function
- 9.6 Notes about JAR file creation
- 9.6.1 Integrating Class files
- 9.6.2 Integrating Java files
- 10. C Stored Procedures and C Stored Functions
- 10.1 Overview
- 10.2 Procedure from external C stored routine creation to execution
- 10.2.1 Creating an external C stored routine
- 10.2.2 Registering the C library file
- 10.2.3 Defining the external C stored routine
- 10.2.4 Executing the external C stored routine
- 10.3 Sample external C stored routine programs
- 10.4 Limitations to C program creation
- 11. UAP Troubleshooting
- 11.1 Gathering error information
- 11.1.1 SQL tracing
- 11.1.2 Client error log facility
- 11.1.3 Facility for output of extended SQL error information
- 11.1.4 UAP statistical report facility
- 11.1.5 Command trace facility
- 11.1.6 SQL trace dynamic acquisition facility
- 11.1.7 Reconnect trace facility
- 11.2 UAP error recovery
- 12. Command Execution from UAPs
- 12.1 Overview
- 12.2 Preparations for executing commands from COMMAND EXECUTE
- 12.3 Command executability
- 13. Connection from an XDS Client
- 13.1 Overview of format of connection from an XDS client
- 14. HiRDB Access from ODBC Application Programs
- 14.1 ODBC application programs
- 14.2 Installing the ODBC2.0 driver
- 14.3 Installing the ODBC 3.5 driver and setting the environment variables
- 14.3.1 Installation
- 14.3.2 Setting the environment variables (in the Windows edition)
- 14.3.3 Determining the version number of the ODBC 3.5 driver
- 14.4 ODBC functions provided by HiRDB
- 14.5 ODBC function data types and HiRDB data types
- 14.6 Specifiability of attributes in the ODBC functions
- 14.7 Asynchronous execution of ODBC functions
- 14.8 Setting cursor libraries
- 14.9 File DSNs
- 14.10 Executing a UAP in Unicode
- 14.11 Tuning and troubleshooting
- 14.12 Facilities that cannot be used when HiRDB is accessed with ODBC
- 14.13 Notes about using the Linux edition of the HiRDB ODBC 3.5 driver
- 14.14 Automatic SQL statement generation by using .NET Framework Data Provider for ODBC
- 15. HiRDB Access from OLE DB Application Programs
- 15.1 Overview
- 15.2 Connection interface
- 15.2.1 Registry information
- 15.2.2 Connection properties
- 15.3 Schema information
- 15.4 Data type correspondences
- 15.5 Error handling procedures
- 15.5.1 Troubleshooting facility
- 15.6 Notes
- 16. HiRDB Access from ADO.NET-compatible Application Programs
- 16.1 Overview
- 16.1.1 HiRDB.NET Data Provider
- 16.1.2 Prerequisite programs for HiRDB.NET Data Provider
- 16.2 Installing HiRDB.NET Data Provider
- 16.2.1 Installation procedure
- 16.2.2 Files that are installed
- 16.2.3 Checking the version information
- 16.3 List of classes provided by HiRDB.NET Data Provider
- 16.4 List of members provided by HiRDB.NET Data Provider
- 16.4.1 List of HiRDBCommand members
- 16.4.2 List of HiRDBCommandBuilder members
- 16.4.3 List of HiRDBConnection members
- 16.4.4 List of HiRDBDataAdapter members
- 16.4.5 List of HiRDBDataReader members
- 16.4.6 List of HiRDBException members
- 16.4.7 List of HiRDBParameter members
- 16.4.8 List of HiRDBParameterCollection members
- 16.4.9 List of HiRDBProviderFactory members
- 16.4.10 List of HiRDBRowUpdatedEventArgs members
- 16.4.11 List of HiRDBRowUpdatingEventArgs members
- 16.4.12 List of HiRDBTransaction members
- 16.5 Interfaces of HiRDB.NET Data Provider
- 16.5.1 HiRDBCommand
- 16.5.2 HiRDBCommandBuilder
- 16.5.3 HiRDBConnection
- 16.5.4 HiRDBDataAdapter
- 16.5.5 HiRDBDataReader
- 16.5.6 HiRDBException
- 16.5.7 HiRDBParameter
- 16.5.8 HiRDBParameterCollection
- 16.5.9 HiRDBProviderFactory
- 16.5.10 HiRDBRowUpdatedEventArgs
- 16.5.11 HiRDBRowUpdatingEventArgs
- 16.5.12 HiRDBTransaction
- 16.6 Notes about HiRDB.NET Data Provider
- 16.6.1 Placing in global assembly cache
- 16.6.2 Notes about individual methods and properties
- 16.7 Data types of HiRDB.NET Data Provider
- 16.7.1 DbType and HiRDBType properties
- 16.7.2 Data types and accessories used by a UAP
- 16.7.3 Type conversion by HiRDB.NET Data Provider
- 16.8 Connection pooling function
- 16.9 Provider-independent codes using DbProviderFactory
- 16.10 Troubleshooting function of HiRDB.NET Data Provider
- 16.11 Example of a UAP using HiRDB.NET Data Provider
- 16.11.1 Connecting to the database
- 16.11.2 Executing the SQL statement
- 16.11.3 Executing a transaction
- 16.11.4 Executing a search statement
- 16.11.5 Executing the INSERT facility using arrays
- 16.11.6 Executing a repetition column
- 16.11.7 Checking for an error in SQL statements and acquiring error information
- 17. Type2 JDBC Driver
- 17.1 Installation and environment setup
- 17.1.1 Installing
- 17.1.2 Environment setup
- 17.1.3 Abbreviation of methods
- 17.2 JDBC1.0 facility
- 17.2.1 Driver class
- 17.2.2 Connection class
- 17.2.3 Statement class
- 17.2.4 PreparedStatement class
- 17.2.5 CallableStatement class
- 17.2.6 ResultSet class
- 17.2.7 ResultSetMetaData class
- 17.2.8 DatabaseMetaData class
- 17.2.9 SQLWarning class
- 17.3 JDBC2.0 basic facility
- 17.3.1 Result set enhancements
- 17.3.2 Batch updating
- 17.3.3 Added data types
- 17.4 JDBC2.0 Optional Package
- 17.4.1 Database connection using DataSource and JNDI
- 17.4.2 Connection pooling
- 17.4.3 Distributed transactions
- 17.5 JAR file access facility
- 17.5.1 Class name
- 17.5.2 Method name
- 17.6 Array class
- 17.7 Specifying a value when using a repetition column as the ? parameter
- 17.8 Functions provided by the HiRDB JDBC driver
- 17.8.1 Provided class
- 17.8.2 setBlockUpdate
- 17.8.3 getBlockUpdate
- 17.9 Notes on using the BLOB type
- 17.10 Setting system properties
- 17.10.1 Setting the array facility
- 17.10.2 Setting the maximum number of SQL search items or ? parameters
- 17.11 Connection information setup/acquisition interface
- 17.11.1 setDescription
- 17.11.2 getDescription
- 17.11.3 setDBHostName
- 17.11.4 getDBHostName
- 17.11.5 setEncodeLang
- 17.11.6 getEncodeLang
- 17.11.7 setUser
- 17.11.8 getUser
- 17.11.9 setPassword
- 17.11.10 getPassword
- 17.11.11 setXAOpenString
- 17.11.12 getXAOpenString
- 17.11.13 setXACloseString
- 17.11.14 getXACloseString
- 17.11.15 setRMID
- 17.11.16 getRMID
- 17.11.17 setXAThreadMode
- 17.11.18 getXAThreadMode
- 17.11.19 setCommit_Behavior
- 17.11.20 getCommit_Behavior
- 17.11.21 setBlockUpdate
- 17.11.22 getBlockUpdate
- 17.11.23 setLONGVARBINARY_Access
- 17.11.24 getLONGVARBINARY_Access
- 17.11.25 setSQLInNum
- 17.11.26 getSQLInNum
- 17.11.27 setSQLOutNum
- 17.11.28 getSQLOutNum
- 17.11.29 setSQLWarningLevel
- 17.11.30 getSQLWarningLevel
- 17.11.31 setClear_Env
- 17.11.32 getClear_Env
- 17.12 Data types and character codes
- 17.12.1 Data types
- 17.12.2 Character code conversion facility
- 17.13 Classes and methods with limitations
- 17.13.1 Driver class
- 17.13.2 Connection class
- 17.13.3 Statement class
- 17.13.4 PreparedStatement class
- 17.13.5 CallableStatement class
- 17.13.6 ResultSet class
- 17.13.7 ResultSetMetaData class
- 17.13.8 DatabaseMetaData class
- 17.13.9 Blob class
- 17.13.10 Array class
- 18. Type4 JDBC Driver
- 18.1 Installation and environment setup
- 18.1.1 Installation
- 18.1.2 Environment setup
- 18.1.3 Abbreviation of methods
- 18.2 Database connection using the DriverManager class
- 18.2.1 Registering the Driver class
- 18.2.2 Connecting to HiRDB with the getConnection method
- 18.3 Database connection using a DataSource object and JNDI
- 18.4 JDBC1.2 core API
- 18.4.1 Driver interface
- 18.4.2 Connection interface
- 18.4.3 Statement interface
- 18.4.4 PreparedStatement interface
- 18.4.5 CallableStatement interface
- 18.4.6 ResultSet interface
- 18.4.7 DatabaseMetaData interface
- 18.4.8 ResultSetMetaData interface
- 18.4.9 Blob interface
- 18.4.10 Array interface
- 18.4.11 SQLException interface
- 18.4.12 SQLWarning interface
- 18.4.13 Unsupported interfaces
- 18.5 JDBC2.1 Core API
- 18.5.1 Expansion of the result set
- 18.5.2 Batch update
- 18.5.3 Added data types
- 18.5.4 Unsupported interfaces
- 18.6 JDBC2.0 Optional Package
- 18.6.1 DataSource interface
- 18.6.2 ConnectionPoolDataSource interface
- 18.6.3 PooledConnection interface
- 18.6.4 XAConnection interface
- 18.6.5 XADataSource interface
- 18.6.6 XAResource interface
- 18.6.7 XAException interface
- 18.6.8 Unsupported interfaces
- 18.7 Connection information setup and acquisition interface
- 18.7.1 setDescription
- 18.7.2 getDescription
- 18.7.3 setDBHostName
- 18.7.4 getDBHostName
- 18.7.5 setJDBC_IF_TRC
- 18.7.6 getJDBC_IF_TRC
- 18.7.7 setTRC_NO
- 18.7.8 getTRC_NO
- 18.7.9 setUapName
- 18.7.10 getUapName
- 18.7.11 setUser
- 18.7.12 getUser
- 18.7.13 setPassword
- 18.7.14 getPassword
- 18.7.15 setXAOpenString
- 18.7.16 getXAOpenString
- 18.7.17 setXACloseString
- 18.7.18 getXACloseString
- 18.7.19 setLONGVARBINARY_Access
- 18.7.20 getLONGVARBINARY_Access
- 18.7.21 setSQLInNum
- 18.7.22 getSQLInNum
- 18.7.23 setSQLOutNum
- 18.7.24 getSQLOutNum
- 18.7.25 setSQLWarningLevel
- 18.7.26 getSQLWarningLevel
- 18.7.27 setXALocalCommitMode
- 18.7.28 getXALocalCommitMode
- 18.7.29 setSQLWarningIgnore
- 18.7.30 getSQLWarningIgnore
- 18.7.31 setHiRDBCursorMode
- 18.7.32 getHiRDBCursorMode
- 18.7.33 setNotErrorOccurred
- 18.7.34 getNotErrorOccurred
- 18.7.35 setEnvironmentVariables
- 18.7.36 getEnvironmentVariables
- 18.7.37 setEncodeLang
- 18.7.38 getEncodeLang
- 18.7.39 setMaxBinarySize
- 18.7.40 getMaxBinarySize
- 18.7.41 setStatementCommitBehavior
- 18.7.42 getStatementCommitBehavior
- 18.7.43 setLONGVARBINARY_AccessSize
- 18.7.44 getLONGVARBINARY_AccessSize
- 18.7.45 setLONGVARBINARY_TruncError
- 18.7.46 getLONGVARBINARY_TruncError
- 18.7.47 setStatementCloseBehavior
- 18.7.48 getStatementCloseBehavior
- 18.7.49 setHiRDBINI
- 18.7.50 getHiRDBINI
- 18.7.51 setBatchExceptionBehavior
- 18.7.52 getBatchExceptionBehavior
- 18.8 Data types
- 18.8.1 Mapping SQL data types
- 18.8.2 Mapping during retrieval data acquisition
- 18.8.3 Mapping when a ? parameter is set
- 18.8.4 Data conversion of TIME, DATE, and TIMESTAMP columns
- 18.8.5 Overflow handling
- 18.9 Character conversion facility
- 18.10 Supported client environment definitions
- 18.11 Connection information priorities
- 18.12 Migration from a Type2 JDBC driver
- 18.13 Migration from DABroker for Java
- 18.13.1 System properties related to the DABroker for Java-compatible facility
- 18.13.2 Items that are not compatible with a Type4 JDBC driver
- 18.14 JDBC interface method trace
- 18.14.1 Setup for trace acquisition
- 18.14.2 Acquisition rules
- 18.14.3 Output example
- 18.15 Exception trace log
- 18.15.1 Methods to be acquired and setup for log acquisition
- 18.15.2 Output formats
- 18.15.3 Output example and analysis method
- 18.15.4 Required memory size and file size
- 18.15.5 Notes
- 18.16 Example UAP that uses a JDBC driver
- 18.17 Estimating the memory requirements for using a JDBC driver
- 18.17.1 Estimating the Connection object size
- 18.17.2 Estimating the Statement object size
- 18.17.3 Estimating the PreparedStatement object size
- 18.17.4 Estimating the CallableStatement object size
- 18.17.5 Estimating the ResultSet object size
- 18.17.6 Estimating the size of trace objects
- 19. SQLJ
- 19.1 Overview
- 19.1.1 What is SQLJ?
- 19.1.2 Environment settings
- 19.2 SQLJ Translator
- 19.3 UAP coding rule
- 19.3.1 Labeling rule
- 19.3.2 SQL coding rule
- 19.3.3 SQL statements that can be used in SQLJ
- 19.3.4 Correspondence between HiRDB data types and SQLJ data types
- 19.3.5 Output variable settings (limited to the native interface edition)
- 19.3.6 Using data types when a cursor is declared (limited to the native interface edition)
- 19.3.7 Description of connection to and disconnection from a HiRDB server
- 19.3.8 Description of cursor-based retrieval
- 19.3.9 Receiving a dynamic result set
- 19.3.10 Using JDBC and SQLJ together
- 19.3.11 Creating and executing a UAP
- 19.3.12 Migrating an SQLJ source from the standard interface edition to the native interface edition
- 19.3.13 Notes about UAP development
- 19.4 Native Runtime
- 19.4.1 Package configuration
- 19.4.2 Public classes of Native Runtime
- 19.4.3 Cluster specifications
- 19.4.4 Coding examples using the native interface
- Appendixes
- A. SQL Communications Area
- A.1 Organization and contents of the SQL Communications Area
- A.2 Expanding the SQL Communications Area
- B. SQL Descriptor Area
- B.1 Organization and contents of the SQL Descriptor Area
- B.2 Expanding the SQL Descriptor Area
- C. Column Name Descriptor Area
- C.1 Organization and contents of the Column Name Descriptor Area
- C.2 Expanding the Column Name Descriptor Area
- D. Type Name Descriptor Area
- D.1 Organization of the Type Name Descriptor Area
- D.2 Contents of the Type Name Descriptor Area
- D.3 Expanding the Type Name Descriptor Area
- E. Character Set Descriptor Area
- E.1 Organization and contents of the character set descriptor area
- E.2 Expanding the character set descriptor area
- F. SQL Data Types and Data Descriptions
- F.1 SQL data types and C data descriptions
- F.2 SQL data types and COBOL data descriptions
- G. Data Dictionary Table Retrieval
- G.1 Examples of SQL statements for retrieval
- G.2 Data dictionary table details
- H. Functions provided by HiRDB
- H.1 Hash function for table partitioning
- H.2 Space conversion function
- H.3 Function for conversion to a DECIMAL signed normalized number
- H.4 Character code type specification function
- I. Scalar Functions That Can Be Specified in the Escape Clause
- J. Character Code Conversion Rules When Character Sets Are Used
- J.1 Converting shift JIS kanji codes to EBCDIK
- J.2 Converting EBCDIK to shift JIS kanji codes
- K. HiRDB SQL Tuning Advisor Environment Setup
- L. Maximum and Minimum HiRDB Values
- M. List of Sample UAPs
- Index
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.