Contents

• Notices

• Preface

• Part 1: Environment Setup (Common)

  • 1. Overview of Application Program Development and Execution

    • 1.1 Procedure and prerequisites for application program development

      • 1.1.1 Programming languages for application programs

      • 1.1.2 Character encoding

      • 1.1.3 Application program development environment

    • 1.2 Application program execution modes

  • 2. Designing Client Definitions

    • 2.1 Specification formats for operands in the client definition

    • 2.2 Contents of operands in the client definition

      • 2.2.1 Operands related to system configuration

      • 2.2.2 Operands related to application program status monitoring

      • 2.2.3 Operands related to performance

      • 2.2.4 Operands related to SQL

    • 2.3 Operand specification rules

    • 2.4 Notes about using the function for centrally managing client definitions

  • 3. Setting Up an Environment for the JDBC Driver

    • 3.1 Environment setup procedure for the JDBC driver

      • 3.1.1 Installing Java Runtime Environment or Java Development Kit

      • 3.1.2 Installing the JDBC driver

      • 3.1.3 Specifying the CLASSPATH environment variable

      • 3.1.4 Checking the value of the TZ environment variable

      • 3.1.5 Granting the write permission for the trace file output destination directory

      • 3.1.6 Setting system properties

      • 3.1.7 Reviewing the scope of scans by antivirus software

    • 3.2 Handling unresponsive application programs

    • 3.3 Upgrading the JDBC driver (replacing the JAR file)

    • 3.4 Replacing the JDBC driver with a revised version

    • 3.5 Changing the time of the OS on a machine on which the JDBC driver has been installed

    • 3.6 Uninstalling the JDBC driver

  • 4. Setting Up an Environment for an HADB Client (If the ODBC Driver and CLI Functions Are Used)

    • 4.1 HADB client environment setup procedure

      • 4.1.1 HADB client for Windows

      • 4.1.2 HADB client for Linux

    • 4.2 Installing and uninstalling an HADB client

      • 4.2.1 HADB client for Windows

      • 4.2.2 HADB client for Linux

    • 4.3 Specifying environment variables

      • 4.3.1 HADB client for Windows

      • 4.3.2 HADB client for Linux

    • 4.4 Creating a client definition

      • 4.4.1 How to create a client definition

      • 4.4.2 Notes about changing a client definition

      • 4.4.3 Choosing a client definition

    • 4.5 Handling unresponsive application programs

    • 4.6 Upgrading an HADB client

      • 4.6.1 Preparations before upgrading an HADB client

      • 4.6.2 Notes about upgrading

      • 4.6.3 How to upgrade an HADB client

      • 4.6.4 Tasks to be performed after upgrading

    • 4.7 Downgrading an HADB client version (restoring the previous version)

      • 4.7.1 Preparations before downgrading an HADB client

      • 4.7.2 Notes about downgrading

      • 4.7.3 Downgrade procedure

      • 4.7.4 Tasks to be performed after downgrading

    • 4.8 Replacing HADB client with a revised version

      • 4.8.1 Procedure for replacing HADB client with a revised version

    • 4.9 Changing the OS time on a client machine

      • 4.9.1 Notes (changing the OS time)

      • 4.9.2 How to advance the OS time on a client machine

      • 4.9.3 How to restore the OS time on a client machine

• Part 2: Application Program Creation (Common)

  • 5. Designs Related to Improvement of Application Program Performance

    • 5.1 How to retrieve tables

      • 5.1.1 About table scans

      • 5.1.2 About index scans

      • 5.1.3 About key scans

    • 5.2 B-tree indexes and text indexes used during execution of SQL statements

      • 5.2.1 Priority and selection rules for indexes

      • 5.2.2 Examples of indexes that are used during retrieval of a table

      • 5.2.3 Examples of indexes that are used during retrieval of a table (examples of index priority)

      • 5.2.4 Cases where an index is not used

      • 5.2.5 How to check the index used during execution of an SQL statement

      • 5.2.6 Notes on searching using a text index

    • 5.3 Range indexes used during execution of SQL statements

      • 5.3.1 Conditions under which range indexes are used during execution of an SQL statement

      • 5.3.2 Examples of range indexes used during retrieval

      • 5.3.3 How to check the range index used during execution of an SQL statement

    • 5.4 How to evaluate the search conditions when indexes are used

      • 5.4.1 Evaluation method when B-tree indexes are used

      • 5.4.2 Evaluation method when range indexes are used

    • 5.5 Table joining methods

      • 5.5.1 About nested-loop join

      • 5.5.2 About hash join

      • 5.5.3 Characteristics of the joining methods

    • 5.6 How to process subqueries

      • 5.6.1 Methods for processing subqueries that do not contain an external reference column

      • 5.6.2 Characteristics of the methods for processing subqueries that do not contain an external reference column

      • 5.6.3 Methods for processing subqueries that contain an external reference column

      • 5.6.4 Characteristics of the methods for processing subqueries that contain an external reference column

    • 5.7 Grouping methods

      • 5.7.1 Hash grouping

      • 5.7.2 Sort grouping

      • 5.7.3 Characteristics of each type of grouping

    • 5.8 Methods for processing set operations

      • 5.8.1 Hash execution

      • 5.8.2 Work table execution

      • 5.8.3 Characteristics of the methods for processing set operations

    • 5.9 Method for processing SELECT DISTINCT

      • 5.9.1 Hash execution

      • 5.9.2 Work table execution

      • 5.9.3 Characteristics of the methods for processing SELECT DISTINCT

    • 5.10 Considerations when executing an SQL statement that creates work tables

      • 5.10.1 Types of work tables

      • 5.10.2 Work tables created when SQL statements are executed

      • 5.10.3 Number of work tables that are created

    • 5.11 Equivalent exchange of search conditions

      • 5.11.1 Equivalent exchange for OR conditions (removing from the OR conditions)

      • 5.11.2 Equivalent exchange for OR conditions (converting to IN conditions)

      • 5.11.3 Equivalent exchange for OR conditions (equivalent exchange to derived tables for which the UNION ALL set operation is specified)

      • 5.11.4 Equivalent exchange for scalar operations

      • 5.11.5 Equivalent exchange for an IN predicate

      • 5.11.6 Equivalent exchange for a HAVING clause (converting to the WHERE clauses)

      • 5.11.7 Equivalent exchange for search conditions in SQL statements that specify derived queries (transposition to the WHERE clause of a derived query)

    • 5.12 Considerations when searching an archivable multi-chunk table

      • 5.12.1 Tips for searching an archivable multi-chunk table

      • 5.12.2 Using the datetime information of the archive range column to narrow the search range

      • 5.12.3 Notes about specifying JOIN (joined table)

      • 5.12.4 Equivalent exchange of SQL statements that search archivable multi-chunk tables

    • 5.13 Expanding internal derived tables

    • 5.14 Improving performance by batch transfer of retrieval results

    • 5.15 Batch transfer of dynamic parameter values

  • 6. Tuning Application Programs

    • 6.1 How to use access paths (how to use SQL statement execution plans)

      • 6.1.1 About access paths

      • 6.1.2 How to check access paths

      • 6.1.3 Examples of access paths

      • 6.1.4 Information displayed in the tree view

      • 6.1.5 Information displayed in the details view

      • 6.1.6 Information output in identification information view (SQL statement identification information)

      • 6.1.7 Information displayed for an access path (alphabetical order)

• Part 3: Application Program Creation (JDBC)

  • 7. Creating Application Programs

    • 7.1 JDBC driver provided by HADB

      • 7.1.1 Scope of JDBC standards compliance

      • 7.1.2 Package name and directory structure of the JAR file

    • 7.2 Basic procedure for application program processing

    • 7.3 How to connect to the HADB server

      • 7.3.1 Using the getConnection method of the DriverManager class to connect to the HADB server

      • 7.3.2 Using the getConnection method of the DataSource class to connect to the HADB server

      • 7.3.3 Connection information priorities

    • 7.4 Retrieving data (executing the SELECT statement)

      • 7.4.1 How to retrieve data

      • 7.4.2 How to use dynamic parameters

    • 7.5 Adding, updating, or deleting data (executing the INSERT, UPDATE, or DELETE statement)

    • 7.6 Data processing

      • 7.6.1 Mapping data types

      • 7.6.2 Data conversion process

      • 7.6.3 Overflow handling

      • 7.6.4 Conversion of character encoding

    • 7.7 Troubleshooting

      • 7.7.1 JDBC interface method traces

      • 7.7.2 Exception trace log

    • 7.8 Scalar functions that can be specified in the escape clause

  • 8. The JDBC 1.2 API

    • 8.1 Driver interface

      • 8.1.1 List of the methods in the Driver interface

      • 8.1.2 acceptsURL(String url)

      • 8.1.3 connect(String url, Properties info)

      • 8.1.4 getMajorVersion()

      • 8.1.5 getMinorVersion()

      • 8.1.6 getPropertyInfo(String url, Properties info)

      • 8.1.7 jdbcCompliant()

      • 8.1.8 Escape clause

    • 8.2 Connection interface

      • 8.2.1 List of the methods in the Connection interface

      • 8.2.2 clearWarnings()

      • 8.2.3 close()

      • 8.2.4 commit()

      • 8.2.5 createStatement()

      • 8.2.6 createStatement(int resultSetType, int resultSetConcurrency)

      • 8.2.7 createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)

      • 8.2.8 getAutoCommit()

      • 8.2.9 getCatalog()

      • 8.2.10 getHADBConnectionID()

      • 8.2.11 getHADBConnectionSerialNum()

      • 8.2.12 getHADBOrderMode()

      • 8.2.13 getHADBSQLHashFltSize()

      • 8.2.14 getHADBSQLHashTblSize()

      • 8.2.15 getHADBSQLMaxRthdNum()

      • 8.2.16 getHADBTransactionID()

      • 8.2.17 getHoldability()

      • 8.2.18 getMetaData()

      • 8.2.19 getSchema()

      • 8.2.20 getTransactionIsolation()

      • 8.2.21 getTypeMap()

      • 8.2.22 getWarnings()

      • 8.2.23 isClosed()

      • 8.2.24 isReadOnly()

      • 8.2.25 isValid(int timeout)

      • 8.2.26 nativeSQL(String sql)

      • 8.2.27 prepareStatement(String sql)

      • 8.2.28 prepareStatement(String sql, int resultSetType, int resultSetConcurrency)

      • 8.2.29 prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)

      • 8.2.30 rollback()

      • 8.2.31 setAutoCommit(boolean autoCommit)

      • 8.2.32 setCatalog(String catalog)

      • 8.2.33 setHADBAuditInfo(int pos,String userinfo)

      • 8.2.34 setHADBOrderMode(int mode)

      • 8.2.35 setHADBSQLHashFltSize(int areaSize)

      • 8.2.36 setHADBSQLHashTblSize(int areaSize)

      • 8.2.37 setHADBSQLMaxRthdNum(int rthdNum)

      • 8.2.38 setHoldability(int holdability)

      • 8.2.39 setReadOnly(boolean readOnly)

      • 8.2.40 setSchema(String schema)

      • 8.2.41 setTransactionIsolation(int level)

    • 8.3 Statement interface

      • 8.3.1 List of the methods in the Statement interface

      • 8.3.2 addBatch(String sql)

      • 8.3.3 cancel()

      • 8.3.4 clearBatch()

      • 8.3.5 clearWarnings()

      • 8.3.6 close()

      • 8.3.7 closeOnCompletion()

      • 8.3.8 execute(String sql)

      • 8.3.9 executeBatch()

      • 8.3.10 executeLargeBatch()

      • 8.3.11 executeLargeUpdate(String sql)

      • 8.3.12 executeQuery(String sql)

      • 8.3.13 executeUpdate(String sql)

      • 8.3.14 getConnection()

      • 8.3.15 getFetchDirection()

      • 8.3.16 getFetchSize()

      • 8.3.17 getHADBSQLSerialNum()

      • 8.3.18 getHADBStatementHandle()

      • 8.3.19 getLargeMaxRows()

      • 8.3.20 getLargeUpdateCount()

      • 8.3.21 getMaxFieldSize()

      • 8.3.22 getMaxRows()

      • 8.3.23 getMoreResults()

      • 8.3.24 getQueryTimeout()

      • 8.3.25 getResultSet()

      • 8.3.26 getResultSetConcurrency()

      • 8.3.27 getResultSetHoldability()

      • 8.3.28 getResultSetType()

      • 8.3.29 getUpdateCount()

      • 8.3.30 getWarnings()

      • 8.3.31 isClosed()

      • 8.3.32 isCloseOnCompletion()

      • 8.3.33 isPoolable()

      • 8.3.34 setCursorName(String name)

      • 8.3.35 setEscapeProcessing(boolean enable)

      • 8.3.36 setFetchDirection(int direction)

      • 8.3.37 setFetchSize(int rows)

      • 8.3.38 setLargeMaxRows(long max)

      • 8.3.39 setMaxFieldSize(int max)

      • 8.3.40 setMaxRows(int max)

      • 8.3.41 setQueryTimeout(int seconds)

      • 8.3.42 Notes about the Statement interface

    • 8.4 PreparedStatement interface

      • 8.4.1 List of the methods in the PreparedStatement interface

      • 8.4.2 addBatch()

      • 8.4.3 clearParameters()

      • 8.4.4 execute()

      • 8.4.5 executeLargeUpdate()

      • 8.4.6 executeQuery()

      • 8.4.7 executeUpdate()

      • 8.4.8 getHADBSQLSerialNum()

      • 8.4.9 getHADBStatementHandle()

      • 8.4.10 getMetaData()

      • 8.4.11 getParameterMetaData()

      • 8.4.12 setAsciiStream(int parameterIndex, InputStream x, int length)

      • 8.4.13 setBigDecimal(int parameterIndex, BigDecimal x)

      • 8.4.14 setBinaryStream(int parameterIndex, InputStream x, int length)

      • 8.4.15 setBoolean(int parameterIndex, boolean x)

      • 8.4.16 setByte(int parameterIndex, byte x)

      • 8.4.17 setBytes(int parameterIndex, byte[] x)

      • 8.4.18 setCharacterStream(int parameterIndex, Reader reader, int length)

      • 8.4.19 setDate(int parameterIndex, Date x)

      • 8.4.20 setDate(int parameterIndex, Date x, Calendar cal)

      • 8.4.21 setDouble(int parameterIndex, double x)

      • 8.4.22 setFloat(int parameterIndex, float x)

      • 8.4.23 setInt(int parameterIndex, int x)

      • 8.4.24 setLong(int parameterIndex, long x)

      • 8.4.25 setNull(int parameterIndex,int sqlType)

      • 8.4.26 setObject(int parameterIndex, Object x)

      • 8.4.27 setObject(int parameterIndex, Object x, int targetSqlType)

      • 8.4.28 setObject(int parameterIndex, Object x, int targetSqlType, int scale)

      • 8.4.29 setShort(int parameterIndex, short x)

      • 8.4.30 setString(int parameterIndex, String x)

      • 8.4.31 setTime(int parameterIndex, Time x)

      • 8.4.32 setTime(int parameterIndex, Time x, Calendar cal)

      • 8.4.33 setTimestamp(int parameterIndex, Timestamp x)

      • 8.4.34 setTimestamp(int parameterIndex, Timestamp x, Calendar cal)

      • 8.4.35 Notes about the PreparedStatement interface

    • 8.5 ResultSet interface

      • 8.5.1 List of the methods in the ResultSet interface

      • 8.5.2 absolute(int row)

      • 8.5.3 afterLast()

      • 8.5.4 beforeFirst()

      • 8.5.5 clearWarnings()

      • 8.5.6 close()

      • 8.5.7 findColumn(String columnName)

      • 8.5.8 first()

      • 8.5.9 getAsciiStream(int columnIndex)

      • 8.5.10 getAsciiStream(String columnName)

      • 8.5.11 getBigDecimal(int columnIndex)

      • 8.5.12 getBigDecimal(String columnName)

      • 8.5.13 getBinaryStream(int columnIndex)

      • 8.5.14 getBinaryStream(String columnName)

      • 8.5.15 getBoolean(int columnIndex)

      • 8.5.16 getBoolean(String columnName)

      • 8.5.17 getByte(int columnIndex)

      • 8.5.18 getByte(String columnName)

      • 8.5.19 getBytes(int columnIndex)

      • 8.5.20 getBytes(String columnName)

      • 8.5.21 getCharacterStream(int columnIndex)

      • 8.5.22 getCharacterStream(String columnName)

      • 8.5.23 getConcurrency()

      • 8.5.24 getCursorName()

      • 8.5.25 getDate(int columnIndex)

      • 8.5.26 getDate(int columnIndex, Calendar cal)

      • 8.5.27 getDate(String columnName)

      • 8.5.28 getDate(String columnName, Calendar cal)

      • 8.5.29 getDouble(int columnIndex)

      • 8.5.30 getDouble(String columnName)

      • 8.5.31 getFetchDirection()

      • 8.5.32 getFetchSize()

      • 8.5.33 getFloat(int columnIndex)

      • 8.5.34 getFloat(String columnName)

      • 8.5.35 getHoldability()

      • 8.5.36 getInt(int columnIndex)

      • 8.5.37 getInt(String columnName)

      • 8.5.38 getLong(int columnIndex)

      • 8.5.39 getLong(String columnName)

      • 8.5.40 getMetaData()

      • 8.5.41 getObject(int columnIndex)

      • 8.5.42 getObject(String columnName)

      • 8.5.43 getObject(int columnIndex,Class<T> type)

      • 8.5.44 getObject(String columnLabel,Class<T> type)

      • 8.5.45 getRow()

      • 8.5.46 getShort(int columnIndex)

      • 8.5.47 getShort(String columnName)

      • 8.5.48 getStatement()

      • 8.5.49 getString(int columnIndex)

      • 8.5.50 getString(String columnName)

      • 8.5.51 getTime(int columnIndex)

      • 8.5.52 getTime(int columnIndex, Calendar cal)

      • 8.5.53 getTime(String columnName)

      • 8.5.54 getTime(String columnName, Calendar cal)

      • 8.5.55 getTimestamp(int columnIndex)

      • 8.5.56 getTimestamp(int columnIndex, Calendar cal)

      • 8.5.57 getTimestamp(String columnName)

      • 8.5.58 getTimestamp(String columnName, Calendar cal)

      • 8.5.59 getType()

      • 8.5.60 getWarnings()

      • 8.5.61 isAfterLast()

      • 8.5.62 isBeforeFirst()

      • 8.5.63 isClosed()

      • 8.5.64 isFirst()

      • 8.5.65 isLast()

      • 8.5.66 last()

      • 8.5.67 next()

      • 8.5.68 previous()

      • 8.5.69 relative(int rows)

      • 8.5.70 setFetchDirection(int direction)

      • 8.5.71 setFetchSize(int rows)

      • 8.5.72 wasNull()

      • 8.5.73 Fields supported by the ResultSet interface

      • 8.5.74 Notes about the ResultSet interface

    • 8.6 DatabaseMetaData interface

      • 8.6.1 List of the methods in the DatabaseMetaData interface

      • 8.6.2 allProceduresAreCallable()

      • 8.6.3 allTablesAreSelectable()

      • 8.6.4 autoCommitFailureClosesAllResultSets()

      • 8.6.5 dataDefinitionCausesTransactionCommit()

      • 8.6.6 dataDefinitionIgnoredInTransactions()

      • 8.6.7 deletesAreDetected(int type)

      • 8.6.8 doesMaxRowSizeIncludeBlobs()

      • 8.6.9 generatedKeyAlwaysReturned()

      • 8.6.10 getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)

      • 8.6.11 getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)

      • 8.6.12 getCatalogs()

      • 8.6.13 getCatalogSeparator()

      • 8.6.14 getCatalogTerm()

      • 8.6.15 getClientInfoProperties()

      • 8.6.16 getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)

      • 8.6.17 getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)

      • 8.6.18 getConnection()

      • 8.6.19 getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable)

      • 8.6.20 getDatabaseMajorVersion()

      • 8.6.21 getDatabaseMinorVersion()

      • 8.6.22 getDatabaseProductName()

      • 8.6.23 getDatabaseProductVersion()

      • 8.6.24 getDefaultTransactionIsolation()

      • 8.6.25 getDriverMajorVersion()

      • 8.6.26 getDriverMinorVersion()

      • 8.6.27 getDriverName()

      • 8.6.28 getDriverVersion()

      • 8.6.29 getExportedKeys(String catalog, String schema, String table)

      • 8.6.30 getExtraNameCharacters()

      • 8.6.31 getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern)

      • 8.6.32 getFunctions(String catalog, String schemaPattern, String functionNamePattern)

      • 8.6.33 getIdentifierQuoteString()

      • 8.6.34 getImportedKeys(String catalog, String schema, String table)

      • 8.6.35 getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)

      • 8.6.36 getJDBCMajorVersion()

      • 8.6.37 getJDBCMinorVersion()

      • 8.6.38 getMaxBinaryLiteralLength()

      • 8.6.39 getMaxCatalogNameLength()

      • 8.6.40 getMaxCharLiteralLength()

      • 8.6.41 getMaxColumnNameLength()

      • 8.6.42 getMaxColumnsInGroupBy()

      • 8.6.43 getMaxColumnsInIndex()

      • 8.6.44 getMaxColumnsInOrderBy()

      • 8.6.45 getMaxColumnsInSelect()

      • 8.6.46 getMaxColumnsInTable()

      • 8.6.47 getMaxConnections()

      • 8.6.48 getMaxCursorNameLength()

      • 8.6.49 getMaxIndexLength()

      • 8.6.50 getMaxLogicalLobSize()

      • 8.6.51 getMaxProcedureNameLength()

      • 8.6.52 getMaxRowSize()

      • 8.6.53 getMaxSchemaNameLength()

      • 8.6.54 getMaxStatementLength()

      • 8.6.55 getMaxStatements()

      • 8.6.56 getMaxTableNameLength()

      • 8.6.57 getMaxTablesInSelect()

      • 8.6.58 getMaxUserNameLength()

      • 8.6.59 getNumericFunctions()

      • 8.6.60 getPrimaryKeys(String catalog, String schema, String table)

      • 8.6.61 getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)

      • 8.6.62 getProcedures(String catalog, String schemaPattern, String procedureNamePattern)

      • 8.6.63 getProcedureTerm()

      • 8.6.64 getPseudoColumns(String catalog,String schemaPattern,String tableNamePattern,String columnNamePattern)

      • 8.6.65 getResultSetHoldability()

      • 8.6.66 getRowIdLifetime()

      • 8.6.67 getSchemas()

      • 8.6.68 getSchemas(String catalog, String schemaPattern)

      • 8.6.69 getSchemaTerm()

      • 8.6.70 getSearchStringEscape()

      • 8.6.71 getSQLKeywords()

      • 8.6.72 getSQLStateType()

      • 8.6.73 getStringFunctions()

      • 8.6.74 getSuperTables(String catalog, String schemaPattern, String tableNamePattern)

      • 8.6.75 getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)

      • 8.6.76 getSystemFunctions()

      • 8.6.77 getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)

      • 8.6.78 getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)

      • 8.6.79 getTableTypes()

      • 8.6.80 getTimeDateFunctions()

      • 8.6.81 getTypeInfo()

      • 8.6.82 getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)

      • 8.6.83 getURL()

      • 8.6.84 getUserName()

      • 8.6.85 getVersionColumns(String catalog, String schema, String table)

      • 8.6.86 insertsAreDetected(int type)

      • 8.6.87 isCatalogAtStart()

      • 8.6.88 isReadOnly()

      • 8.6.89 locatorsUpdateCopy()

      • 8.6.90 nullPlusNonNullIsNull()

      • 8.6.91 nullsAreSortedAtEnd()

      • 8.6.92 nullsAreSortedAtStart()

      • 8.6.93 nullsAreSortedHigh()

      • 8.6.94 nullsAreSortedLow()

      • 8.6.95 othersDeletesAreVisible(int type)

      • 8.6.96 othersInsertsAreVisible(int type)

      • 8.6.97 othersUpdatesAreVisible(int type)

      • 8.6.98 ownDeletesAreVisible(int type)

      • 8.6.99 ownInsertsAreVisible(int type)

      • 8.6.100 ownUpdatesAreVisible(int type)

      • 8.6.101 storesLowerCaseIdentifiers()

      • 8.6.102 storesLowerCaseQuotedIdentifiers()

      • 8.6.103 storesMixedCaseIdentifiers()

      • 8.6.104 storesMixedCaseQuotedIdentifiers()

      • 8.6.105 storesUpperCaseIdentifiers()

      • 8.6.106 storesUpperCaseQuotedIdentifiers()

      • 8.6.107 supportsAlterTableWithAddColumn()

      • 8.6.108 supportsAlterTableWithDropColumn()

      • 8.6.109 supportsANSI92EntryLevelSQL()

      • 8.6.110 supportsANSI92FullSQL()

      • 8.6.111 supportsANSI92IntermediateSQL()

      • 8.6.112 supportsBatchUpdates()

      • 8.6.113 supportsCatalogsInDataManipulation()

      • 8.6.114 supportsCatalogsInIndexDefinitions()

      • 8.6.115 supportsCatalogsInPrivilegeDefinitions()

      • 8.6.116 supportsCatalogsInProcedureCalls()

      • 8.6.117 supportsCatalogsInTableDefinitions()

      • 8.6.118 supportsColumnAliasing()

      • 8.6.119 supportsConvert()

      • 8.6.120 supportsConvert(int fromType, int toType)

      • 8.6.121 supportsCoreSQLGrammar()

      • 8.6.122 supportsCorrelatedSubqueries()

      • 8.6.123 supportsDataDefinitionAndDataManipulationTransactions()

      • 8.6.124 supportsDataManipulationTransactionsOnly()

      • 8.6.125 supportsDifferentTableCorrelationNames()

      • 8.6.126 supportsExpressionsInOrderBy()

      • 8.6.127 supportsExtendedSQLGrammar()

      • 8.6.128 supportsFullOuterJoins()

      • 8.6.129 supportsGetGeneratedKeys()

      • 8.6.130 supportsGroupBy()

      • 8.6.131 supportsGroupByBeyondSelect()

      • 8.6.132 supportsGroupByUnrelated()

      • 8.6.133 supportsIntegrityEnhancementFacility()

      • 8.6.134 supportsLikeEscapeClause()

      • 8.6.135 supportsLimitedOuterJoins()

      • 8.6.136 supportsMinimumSQLGrammar()

      • 8.6.137 supportsMixedCaseIdentifiers()

      • 8.6.138 supportsMixedCaseQuotedIdentifiers()

      • 8.6.139 supportsMultipleOpenResults()

      • 8.6.140 supportsMultipleResultSets()

      • 8.6.141 supportsMultipleTransactions()

      • 8.6.142 supportsNamedParameters()

      • 8.6.143 supportsNonNullableColumns()

      • 8.6.144 supportsOpenCursorsAcrossCommit()

      • 8.6.145 supportsOpenCursorsAcrossRollback()

      • 8.6.146 supportsOpenStatementsAcrossCommit()

      • 8.6.147 supportsOpenStatementsAcrossRollback()

      • 8.6.148 supportsOrderByUnrelated()

      • 8.6.149 supportsOuterJoins()

      • 8.6.150 supportsPositionedDelete()

      • 8.6.151 supportsPositionedUpdate()

      • 8.6.152 supportsRefCursors()

      • 8.6.153 supportsResultSetConcurrency(int type, int concurrency)

      • 8.6.154 supportsResultSetHoldability(int holdability)

      • 8.6.155 supportsResultSetType(int type)

      • 8.6.156 supportsSavepoints()

      • 8.6.157 supportsSchemasInDataManipulation()

      • 8.6.158 supportsSchemasInIndexDefinitions()

      • 8.6.159 supportsSchemasInPrivilegeDefinitions()

      • 8.6.160 supportsSchemasInProcedureCalls()

      • 8.6.161 supportsSchemasInTableDefinitions()

      • 8.6.162 supportsSelectForUpdate()

      • 8.6.163 supportsStatementPooling()

      • 8.6.164 supportsStoredFunctionsUsingCallSyntax()

      • 8.6.165 supportsStoredProcedures()

      • 8.6.166 supportsSubqueriesInComparisons()

      • 8.6.167 supportsSubqueriesInExists()

      • 8.6.168 supportsSubqueriesInIns()

      • 8.6.169 supportsSubqueriesInQuantifieds()

      • 8.6.170 supportsTableCorrelationNames()

      • 8.6.171 supportsTransactionIsolationLevel(int level)

      • 8.6.172 supportsTransactions()

      • 8.6.173 supportsUnion()

      • 8.6.174 supportsUnionAll()

      • 8.6.175 updatesAreDetected(int type)

      • 8.6.176 usesLocalFilePerTable()

      • 8.6.177 usesLocalFiles()

    • 8.7 ResultSetMetaData interface

      • 8.7.1 List of the methods in the ResultSetMetaData interface

      • 8.7.2 getCatalogName(int column)

      • 8.7.3 getColumnClassName(int column)

      • 8.7.4 getColumnCount()

      • 8.7.5 getColumnDisplaySize(int column)

      • 8.7.6 getColumnLabel(int column)

      • 8.7.7 getColumnName(int column)

      • 8.7.8 getColumnType(int column)

      • 8.7.9 getColumnTypeName(int column)

      • 8.7.10 getPrecision(int column)

      • 8.7.11 getScale(int column)

      • 8.7.12 getSchemaName(int column)

      • 8.7.13 getTableName(int column)

      • 8.7.14 isAutoIncrement(int column)

      • 8.7.15 isCaseSensitive(int column)

      • 8.7.16 isCurrency(int column)

      • 8.7.17 isDefinitelyWritable(int column)

      • 8.7.18 isNullable(int column)

      • 8.7.19 isReadOnly(int column)

      • 8.7.20 isSearchable(int column)

      • 8.7.21 isSigned(int column)

      • 8.7.22 isWritable(int column)

    • 8.8 SQLException interface

    • 8.9 SQLWarning interface

      • 8.9.1 Creating an SQLWarning object

      • 8.9.2 Releasing SQLWarning objects

    • 8.10 Unsupported interfaces

  • 9. The JDBC 2.1 Core API

    • 9.1 Scope of support for the result set extended functions

    • 9.2 Scope of support for batch update functionality

      • 9.2.1 SQL statements that can use the batch update functionality

      • 9.2.2 Batch update functionality with the Statement class

      • 9.2.3 Batch update functionality with the PreparedStatement class

      • 9.2.4 Notes

    • 9.3 Added data types

    • 9.4 Unsupported interfaces

  • 10. The JDBC 2.0 Optional Package

    • 10.1 HADB's scope of support for the functions added in the JDBC 2.0 Optional Package

    • 10.2 DataSource interface

      • 10.2.1 List of the methods in the DataSource interface

      • 10.2.2 getConnection()

      • 10.2.3 getConnection(String username, String password)

      • 10.2.4 getLoginTimeout()

      • 10.2.5 getLogWriter()

      • 10.2.6 setLoginTimeout(int seconds)

      • 10.2.7 setLogWriter(PrintWriter out)

    • 10.3 ConnectionPoolDataSource interface

      • 10.3.1 List of the methods in the ConnectionPoolDataSource interface

      • 10.3.2 getLoginTimeout()

      • 10.3.3 getLogWriter()

      • 10.3.4 getPooledConnection()

      • 10.3.5 getPooledConnection(String user, String password)

      • 10.3.6 setLoginTimeout(int seconds)

      • 10.3.7 setLogWriter(PrintWriter out)

    • 10.4 PooledConnection interface

      • 10.4.1 List of the methods in the PooledConnection interface

      • 10.4.2 addConnectionEventListener(ConnectionEventListener listener)

      • 10.4.3 close()

      • 10.4.4 getConnection()

      • 10.4.5 removeConnectionEventListener(ConnectionEventListener listener)

    • 10.5 Connection information setup and acquisition interface

      • 10.5.1 List of the methods in the connection information setup and acquisition interface

      • 10.5.2 getApName()

      • 10.5.3 getEncodeLang()

      • 10.5.4 getInterfaceMethodTrace()

      • 10.5.5 getNotErrorOccurred()

      • 10.5.6 getPassword()

      • 10.5.7 getSQLWarningKeep()

      • 10.5.8 getTraceNumber()

      • 10.5.9 getUser()

      • 10.5.10 getHostName()

      • 10.5.11 getPort()

      • 10.5.12 setApName(String name)

      • 10.5.13 setEncodeLang(String lang)

      • 10.5.14 setInterfaceMethodTrace(boolean flag)

      • 10.5.15 setNotErrorOccurred(boolean mode)

      • 10.5.16 setPassword(String password)

      • 10.5.17 setSQLWarningKeep(boolean mode)

      • 10.5.18 setTraceNumber(int num)

      • 10.5.19 setUser(String user)

      • 10.5.20 setHostName(String name)

      • 10.5.21 setPort(int port)

  • 11. The JDBC 3.0 API

    • 11.1 HADB's scope of support for the functions added in the JDBC 3.0 API

    • 11.2 ParameterMetaData interface

      • 11.2.1 List of the methods in the ParameterMetaData interface

      • 11.2.2 getParameterClassName(int param)

      • 11.2.3 getParameterCount()

      • 11.2.4 getParameterMode(int param)

      • 11.2.5 getParameterType(int param)

      • 11.2.6 getParameterTypeName(int param)

      • 11.2.7 getPrecision(int param)

      • 11.2.8 getScale(int param)

      • 11.2.9 isNullable(int param)

      • 11.2.10 isSigned(int param)

    • 11.3 Unsupported interfaces

  • 12. The JDBC 4.0 API

    • 12.1 HADB's scope of support for the functions added in the JDBC 4.0 API

      • 12.1.1 Automatic loading of java.sql.Driver

      • 12.1.2 Wrapper pattern

      • 12.1.3 SQL exception extension

      • 12.1.4 Connection management

      • 12.1.5 Added scalar functions

    • 12.2 Wrapper interface

      • 12.2.1 List of the methods in the Wrapper interface

      • 12.2.2 isWrapperFor(Class<?> iface)

      • 12.2.3 unwrap(Class<T> iface)

    • 12.3 SQL exception extension function

    • 12.4 Unsupported interfaces

  • 13. The JDBC 4.1 API

    • 13.1 HADB's scope of support for the functions added in the JDBC 4.1 API

      • 13.1.1 try-with-resources statement

      • 13.1.2 Closing Statement objects when their dependent objects close

  • 14. The JDBC 4.2 API

    • 14.1 HADB's scope of support for the functions added in the JDBC 4.2 API

      • 14.1.1 Large update counts

• Part 4: Application Program Creation (ODBC)

  • 15. Creating Application Programs

    • 15.1 ODBC driver provided by HADB

      • 15.1.1 ODBC driver version with which the HADB ODBC driver is compliant

      • 15.1.2 System configuration

      • 15.1.3 About conversion of character encoding

      • 15.1.4 About using the ODBC cursor library

    • 15.2 HADB ODBC driver environment setup

      • 15.2.1 Specifying data sources

      • 15.2.2 Registering the registry key

      • 15.2.3 Deleting data sources

    • 15.3 Correspondence between data types

      • 15.3.1 Correspondence between ODBC's SQL data types and HADB's data types

      • 15.3.2 Correspondence between ODBC's SQL data types and C data types

      • 15.3.3 Notes about data type conversion

    • 15.4 Information that is returned in the event of an error

    • 15.5 Limitations

      • 15.5.1 ROW specification

      • 15.5.2 AUTOCOMMIT specifications

      • 15.5.3 Notes about the maximum number SQL processing real threads

    • 15.6 Notes

      • 15.6.1 Effects of update operations on a retrieval using a cursor

      • 15.6.2 Notes on using the HADB ODBC driver in ODBC 2.x applications

  • 16. ODBC Functions

    • 16.1 List of ODBC functions

    • 16.2 Notes about SQLxxx and SQLxxxW functions

    • 16.3 Connecting to the data source

      • 16.3.1 SQLAllocHandle

      • 16.3.2 SQLConnect, SQLConnectW

      • 16.3.3 SQLDriverConnect, SQLDriverConnectW

      • 16.3.4 SQLBrowseConnect, SQLBrowseConnectW

    • 16.4 Acquiring driver and data source information

      • 16.4.1 SQLDataSources, SQLDataSourcesW

      • 16.4.2 SQLDrivers, SQLDriversW

      • 16.4.3 SQLGetInfo, SQLGetInfoW

      • 16.4.4 SQLGetFunctions

      • 16.4.5 SQLGetTypeInfo, SQLGetTypeInfoW

    • 16.5 Specifying and obtaining driver options

      • 16.5.1 SQLSetConnectAttr, SQLSetConnectAttrW

      • 16.5.2 SQLGetConnectAttr, SQLGetConnectAttrW

      • 16.5.3 SQLSetEnvAttr

      • 16.5.4 SQLGetEnvAttr

      • 16.5.5 SQLSetStmtAttr, SQLSetStmtAttrW

      • 16.5.6 SQLGetStmtAttr, SQLGetStmtAttrW

    • 16.6 Specifying descriptor values

      • 16.6.1 SQLGetDescField, SQLGetDescFieldW

      • 16.6.2 SQLGetDescRec, SQLGetDescRecW

      • 16.6.3 SQLSetDescField, SQLSetDescFieldW

      • 16.6.4 SQLSetDescRec

      • 16.6.5 SQLCopyDesc

    • 16.7 Creating SQL requests

      • 16.7.1 SQLPrepare, SQLPrepareW

      • 16.7.2 SQLBindParameter

      • 16.7.3 SQLGetCursorName, SQLGetCursorNameW

      • 16.7.4 SQLSetCursorName, SQLSetCursorNameW

      • 16.7.5 SQLDescribeParam

      • 16.7.6 SQLNumParams

    • 16.8 Executing SQL statements

      • 16.8.1 SQLExecute

      • 16.8.2 SQLExecDirect, SQLExecDirectW

      • 16.8.3 SQLNativeSql, SQLNativeSqlW

      • 16.8.4 SQLParamData

      • 16.8.5 SQLPutData

    • 16.9 Acquiring execution results and execution result information

      • 16.9.1 SQLRowCount

      • 16.9.2 SQLNumResultCols

      • 16.9.3 SQLDescribeCol, SQLDescribeColW

      • 16.9.4 SQLColAttribute, SQLColAttributeW

      • 16.9.5 SQLBindCol

      • 16.9.6 SQLFetch

      • 16.9.7 SQLFetchScroll

      • 16.9.8 SQLGetData

      • 16.9.9 SQLSetPos

      • 16.9.10 SQLBulkOperations

      • 16.9.11 SQLMoreResults

      • 16.9.12 SQLGetDiagField, SQLGetDiagFieldW

      • 16.9.13 SQLGetDiagRec, SQLGetDiagRecW

    • 16.10 Acquiring system information for the data source

      • 16.10.1 SQLColumnPrivileges, SQLColumnPrivilegesW

      • 16.10.2 SQLColumns, SQLColumnsW

      • 16.10.3 SQLForeignKeys, SQLForeignKeysW

      • 16.10.4 SQLPrimaryKeys, SQLPrimaryKeysW

      • 16.10.5 SQLProcedureColumns, SQLProcedureColumnsW

      • 16.10.6 SQLProcedures, SQLProceduresW

      • 16.10.7 SQLSpecialColumns, SQLSpecialColumnsW

      • 16.10.8 SQLStatistics, SQLStatisticsW

      • 16.10.9 SQLTablePrivileges, SQLTablePrivilegesW

      • 16.10.10 SQLTables, SQLTablesW

    • 16.11 Terminating execution of SQL statements

      • 16.11.1 SQLFreeStmt

      • 16.11.2 SQLCloseCursor

      • 16.11.3 SQLCancel

      • 16.11.4 SQLEndTran

    • 16.12 Disconnecting from the data source

      • 16.12.1 SQLDisconnect

      • 16.12.2 SQLFreeHandle

    • 16.13 Information types that can be specified for InfoType in SQLGetInfo and SQLGetInfoW

    • 16.14 Attributes that can be specified in SQLSetConnectAttr, SQLSetConnectAttrW, SQLGetConnectAttr, and SQLGetConnectAttrW

    • 16.15 Attributes that can be specified in SQLSetEnvAttr and SQLGetEnvAttr

    • 16.16 Attributes that can be specified in SQLSetStmtAttr, SQLSetStmtAttrW, SQLGetStmtAttr, and SQLGetStmtAttrW

    • 16.17 Attributes that can be specified in SQLGetDescField, SQLGetDescFieldW, SQLSetDescField, and SQLSetDescFieldW

    • 16.18 Attributes that can be specified in DiagIdentifier of SQLGetDiagField and SQLGetDiagFieldW

  • 17. Troubleshooting

    • 17.1 Information used for troubleshooting

      • 17.1.1 Messages output by BI tools and ODBC modules

      • 17.1.2 ODBC traces

      • 17.1.3 HADB ODBC driver trace information

      • 17.1.4 Messages output by the HADB server and HADB client

      • 17.1.5 SQL trace information

    • 17.2 Troubleshooting procedure

      • 17.2.1 Handling errors

      • 17.2.2 Troubleshooting tips

    • 17.3 Settings for outputting HADB ODBC driver trace information

      • 17.3.1 Configuration in ODBC Data Source Administrator

      • 17.3.2 Configuration using environment variables

      • 17.3.3 Relative priority of configuration in ODBC Data Source Administrator and environment variables

    • 17.4 Information output as HADB ODBC driver trace information

      • 17.4.1 About trace levels

      • 17.4.2 Information output when trace level is 1

      • 17.4.3 Information output when trace level is 2

    • 17.5 Notes about HADB ODBC driver trace information

• Part 5: Application Program Creation (CLI Functions)

  • 18. Creating Application Programs

    • 18.1 Designing application programs

      • 18.1.1 Flow of application program processing

      • 18.1.2 Transaction control

      • 18.1.3 Flow of processing using dynamic parameters

      • 18.1.4 Effects of update operations on a retrieval using a cursor

      • 18.1.5 Evaluation and handling of SQL statement errors

    • 18.2 How to use the CLI functions

      • 18.2.1 Connecting to and disconnecting from the HADB server

      • 18.2.2 Referencing data

      • 18.2.3 Using dynamic parameters

      • 18.2.4 Adding, updating, or deleting data

      • 18.2.5 Canceling SQL processing that is executing

      • 18.2.6 Notes about using the CLI functions

    • 18.3 Compiling and linking application programs

  • 19. CLI Functions

    • 19.1 List of CLI functions and common rules

      • 19.1.1 List of CLI functions

      • 19.1.2 Common rules

    • 19.2 CLI functions for connecting to and disconnecting from the HADB server

      • 19.2.1 a_rdb_SQLAllocConnect() (allocate a connection handle)

      • 19.2.2 a_rdb_SQLConnect() (establish a connection)

      • 19.2.3 a_rdb_SQLSetConnectAttr() (set connection attributes)

      • 19.2.4 a_rdb_SQLDisconnect() (close a connection)

      • 19.2.5 a_rdb_SQLFreeConnect() (release a connection handle)

    • 19.3 CLI functions for controlling transactions

      • 19.3.1 a_rdb_SQLCancel() (cancel SQL processing)

      • 19.3.2 a_rdb_SQLEndTran() (terminate the transaction)

    • 19.4 CLI functions for execution of SQL statements

      • 19.4.1 a_rdb_SQLAllocStmt() (allocate a statement handle)

      • 19.4.2 a_rdb_SQLBindArrayParams() (bind dynamic parameters in batch mode)

      • 19.4.3 a_rdb_SQLBindCols() (associate retrieval result columns)

      • 19.4.4 a_rdb_SQLBindParams() (associate dynamic parameters)

      • 19.4.5 a_rdb_SQLCloseCursor() (close the cursor)

      • 19.4.6 a_rdb_SQLDescribeCols() (acquire information about the retrieval result columns)

      • 19.4.7 a_rdb_SQLDescribeParams() (acquire dynamic parameter information)

      • 19.4.8 a_rdb_SQLExecDirect() (preprocess and execute an SQL statement)

      • 19.4.9 a_rdb_SQLExecute() (execute a preprocessed SQL statement)

      • 19.4.10 a_rdb_SQLFetch() (fetch a row)

      • 19.4.11 a_rdb_SQLFreeStmt() (release a statement handle)

      • 19.4.12 a_rdb_SQLNumParams() (acquire the number of dynamic parameters)

      • 19.4.13 a_rdb_SQLNumResultCols() (acquire the number of retrieval result columns)

      • 19.4.14 a_rdb_SQLPrepare() (preprocess an SQL statement)

    • 19.5 CLI functions for data type conversion

      • 19.5.1 a_rdb_CNV_charBINARY() (convert to BINARY-type data)

      • 19.5.2 a_rdb_CNV_charDATE() (convert to DATE-type data)

      • 19.5.3 a_rdb_CNV_charDECIMAL() (convert to DECIMAL-type data)

      • 19.5.4 a_rdb_CNV_charTIME() (convert to TIME-type data)

      • 19.5.5 a_rdb_CNV_charTIMESTAMP() (convert to TIMESTAMP-type data)

      • 19.5.6 a_rdb_CNV_charVARBINARY() (convert to VARBINARY-type data)

      • 19.5.7 a_rdb_CNV_BINARYchar() (convert BINARY-type data)

      • 19.5.8 a_rdb_CNV_DATEchar() (convert DATE-type data)

      • 19.5.9 a_rdb_CNV_DECIMALchar() (convert DECIMAL-type data)

      • 19.5.10 a_rdb_CNV_TIMEchar() (convert TIME-type data)

      • 19.5.11 a_rdb_CNV_TIMESTAMPchar() (convert TIMESTAMP-type data)

      • 19.5.12 a_rdb_CNV_VARBINARYchar() (convert VARBINARY-type data)

    • 19.6 Correspondence to the SQL data types

      • 19.6.1 Correspondences among SQL data types, symbolic literals, and values

      • 19.6.2 Correspondences between SQL data types and data descriptions

      • 19.6.3 Correspondence to the VARCHAR type

      • 19.6.4 VARBINARY type

    • 19.7 Data types used in the CLI functions

      • 19.7.1 a_rdb_SQLColumnInfo_t structure (column information)

      • 19.7.2 a_rdb_SQLNameInfo_t structure (name information)

      • 19.7.3 a_rdb_SQLDataType_t structure (data type information)

      • 19.7.4 a_rdb_SQLInd_t (indicator)

      • 19.7.5 a_rdb_SQLParameterInfo_t structure (parameter information)

      • 19.7.6 a_rdb_SQLResultInfo_t structure (SQL results information)

    • 19.8 Return values of the CLI functions

• Appendixes

  • A. Sample Application Program

    • A.1 Overview of sample application program

    • A.2 Preparations before executing the sample application program

    • A.3 How to create the SAMPLE table

    • A.4 Sample application program execution procedure

  • B. Structure of HADB Client Directories

    • B.1 HADB clients for Windows

    • B.2 HADB clients for Linux

  • C. Estimating the Memory Requirements for an HADB Client

    • C.1 Memory required for connecting to the HADB server

    • C.2 Memory required for communication between an HADB client and the HADB server

• Index

To Page Top