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

[Trademarks]

All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.