Index

a_rdb_CNV_BINARYchar()

a_rdb_CNV_charBINARY()

a_rdb_CNV_charDATE()

a_rdb_CNV_charDECIMAL()

a_rdb_CNV_charTIME()

a_rdb_CNV_charTIMESTAMP()

a_rdb_CNV_charVARBINARY()

a_rdb_CNV_DATEchar()

a_rdb_CNV_DECIMALchar()

a_rdb_CNV_TIMEchar()

a_rdb_CNV_TIMESTAMPchar()

a_rdb_CNV_VARBINARYchar()

a_rdb_SQLAllocConnect()

a_rdb_SQLAllocStmt()

a_rdb_SQLBindArrayParams()

a_rdb_SQLBindCols()

a_rdb_SQLBindParams()

a_rdb_SQLCancel()

a_rdb_SQLCloseCursor()

a_rdb_SQLColumnInfo_t structure

a_rdb_SQLConnect()

a_rdb_SQLDataType_t structure

a_rdb_SQLDescribeCols()

a_rdb_SQLDescribeParams()

a_rdb_SQLDisconnect()

a_rdb_SQLEndTran()

a_rdb_SQLExecDirect()

a_rdb_SQLExecute()

a_rdb_SQLFetch()

a_rdb_SQLFreeConnect()

a_rdb_SQLFreeStmt()

a_rdb_SQLInd_t

a_rdb_SQLNameInfo_t structure

a_rdb_SQLNumParams()

a_rdb_SQLNumResultCols()

a_rdb_SQLParameterInfo_t structure

a_rdb_SQLPrepare()

a_rdb_SQLResultInfo_t structure

a_rdb_SQLSetConnectAttr()

abbreviations for products

absolute(int row)

acceptsURL(String url)

access path

• example of

acquiring dynamic parameter information

• a_rdb_SQLDescribeParams()

• example of using CLI function

acquiring number of dynamic parameters

• a_rdb_SQLNumParams()

• example of using CLI function

acronyms

action to take when hash table area has insufficient space

ADB_AUDITREAD

adb_clt_ap_name

• client definition

• system property

• URL for connection

• user property

adb_clt_fetch_size

• client definition

• system property

• URL for connection

• user property

adb_clt_group_name

• client definition

• system property

• URL for connection

• user property

adb_clt_rpc_con_wait_time

• client definition

• system property

• URL for connection

• user property

adb_clt_rpc_sql_wait_time

• client definition

• system property

• URL for connection

• user property

adb_clt_rpc_srv_host

• client definition

• system property

• user property

adb_clt_rpc_srv_port

• client definition

• system property

• user property

adb_clt_sql_order_mode

• client definition

• system property

• URL for connection

• user property

adb_clt_sql_text_out

• client definition

• system property

• URL for connection

• user property

adb_clt_trn_access_mode

• client definition

• system property

• URL for connection

• user property

adb_clt_trn_iso_lv

• client definition

• system property

• URL for connection

• user property

ADB_CSVREAD

adb_dbbuff_wrktbl_clt_blk_num

• client definition

• system property

• URL for connection

• user property

adb_jdbc_cache_info_max

adb_jdbc_exc_trc_out_path

adb_jdbc_info_max

adb_jdbc_trc_out_lv

adb_sql_exe_hashflt_area_size

• client definition

• system property

• URL for connection

• user property

adb_sql_exe_hashgrp_area_size

• client definition

• system property

• URL for connection

• user property

adb_sql_exe_hashtbl_area_size

• client definition

• system property

• URL for connection

• user property

adb_sql_exe_max_rthd_num

• client definition

• system property

• URL for connection

• user property

adb_sql_prep_dec_div_rs_prior

• client definition

• system property

• URL for connection

• user property

adb_sql_prep_delrsvd_use_srvdef

• client definition

• system property

• URL for connection

• user property

ADBCLTDIR (environment variable), [2]

ADBCLTLANG (environment variable), [2]

ADBMSGLOGSIZE (environment variable), [2]

ADBODBAPMODE (environment variable)

ADBODBTRC (environment variable)

ADBODBTRCLV (environment variable)

ADBODBTRCPATH (environment variable)

ADBODBTRCSIZE (environment variable)

ADBSQLNULLCHAR (environment variable)

addBatch

• PreparedStatement interface

• Statement interface

addConnectionEventListener

added scalar function

advancing OS time on client machine

afterLast()

allocating connection handle

• example of using CLI function

allProceduresAreCallable()

allTablesAreSelectable()

antivirus software

• reviewing scope of scans (if JDBC driver is used)

application identifier

application program

• designing

• tuning

archivable multi-chunk table

• considerations when searching

• equivalent exchange of SQL statement

AUTOCOMMIT specification

autoCommitFailureClosesAllResultSets()

automatic commit mode, setting

automatic loading (java.sql.Driver)

B-tree index

• evaluation method using

B-tree index selection rules

B-tree indexes used during execution of SQL statement

batch binding of dynamic parameters

batch transfer

• dynamic parameter values

• retrieval results

batch transfer of dynamic parameter values

batch transfer of retrieval results

batch update functionality, scope of support for

beforeFirst()

BINARY-type data

• converting (CLI function)

• converting to (CLI function)

binding of dynamic parameters

• a_rdb_SQLBindParams()

• example of using CLI function

bookmark functionality

boundary alignment

BUILD COLUMN, [2]

cancel()

changing OS time

changing OS time on client machine

character encoding conversion

• ODBC

character string displaying null value

checking access paths

checking index used for retrieval

class name

• Connection interface

• DatabaseMetaData interface

• Driver interface

• PreparedStatement interface

• ResultSet interface

• ResultSetMetaData interface

• Statement interface

CLASSPATH (environment variable)

clearBatch()

clearParameters()

clearWarnings()

• Connection interface

• ResultSet interface

• Statement interface

CLI function

client definition, creating

client directory, [2]

client directory (Linux)

• structure of (at installation)

• structure of (during operation)

client directory (Windows)

• structure of (at installation)

• structure of (during operation)

client group name

client library

close()

• Connection interface

• PooledConnection interface

• ResultSet interface

• Statement interface

closeOnCompletion()

closing connection

• example of using CLI function

COLUMN

COLUMN STORE

columns of work table

commit()

compiling

concurrent processing type

connect(String url, Properties info)

connection

• closing (a_rdb_SQLDisconnect())

• establishing (a_rdb_SQLConnect())

• establishing (CLI function, example of)

connection attribute, setting

connection handle

• allocating (a_rdb_SQLAllocConnect())

• releasing (a_rdb_SQLFreeConnect())

connection information priorities

Connection interface

connection management

Connection Number

connection pool

ConnectionPoolDataSource interface

conventions

• abbreviations for products

• acronyms

• fonts and symbols

• KB, MB, GB, TB, PB, and EB

• version numbers

conversion of character encoding (JDBC)

CREATE FILTER, [2]

CREATE GLOBAL WORK TABLE

CREATE LOCAL WORK TABLE

createStatement()

createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)

createStatement(int resultSetType, int resultSetConcurrency)

CROSS JOIN

cursor

• closing

• closing (a_rdb_SQLCloseCursor())

• closing (CLI function, example of)

• moving

• opening (a_rdb_SQLExecute())

• opening (CLI function, example of)

• using, to retrieve rows (CLI function, example of)

data description

data source

• acquiring system information for

• connecting to (ODBC)

• disconnecting from (ODBC)

data source information, acquiring

data types

• correspondence between (ODBC)

• mapping

DatabaseMetaData interface

dataDefinitionCausesTransactionCommit()

dataDefinitionIgnoredInTransactions()

DataSource interface

DataSource object

• generating

• registering into JNDI

DATE-type data

• converting (CLI function)

• converting to (CLI function)

DECIMAL-type data

• converting (CLI function)

• converting to (CLI function)

DELEGATION

DELETE STATEMENT

deletesAreDetected(int type)

deleting data sources (ODBC)

DERIVED TABLE

descriptor value, specifying

designing client definition

details view

• information displayed in

DISTINCT

doesMaxRowSizeIncludeBlobs()

downgrading (HADB client)

Driver class, how to register

driver information, acquiring

Driver interface

driver option

• obtaining

• specifying

DriverPropertyInfo field setting

dynamic parameter

• designing application program

• how to use CLI function

EB meaning

environment setup (JDBC driver)

environment variable

• CLASSPATH

• TZ (if JDBC driver is used)

environment variable, specifying

equivalent exchange

• converting to IN conditions

• converting to WHERE clause

• equivalent exchange to derived table for which UNION ALL set operation is specified

• IN predicate

• removing from OR condition

• scalar operation

equivalent exchange (search conditions)

Equivalent exchange for a HAVING clause

equivalent exchange for scalar operations

equivalent exchange of search conditions

equivalent exchange related to IN predicates

equivalent exchange related to OR conditions

• converting to IN conditions

• equivalent exchange to derived table for which UNION ALL set operation is specified

• removing from OR condition

error

• how to evaluate (SQL statement)

• information that is returned in event of (ODBC)

escape clause

escape syntax analysis

evaluation method

• range index

• using B-tree index

evaluation method using range index

event listener, registering

EXCEPT ALL

EXCEPT DISTINCT

exception trace log

execute

• PreparedStatement interface

• Statement interface

executeBatch()

executeLargeBatch()

executeLargeUpdate()

executeLargeUpdate(String sql)

executeQuery

• PreparedStatement interface

• Statement interface

executeUpdate

• PreparedStatement interface

• Statement interface

execution plan (SQL statement)

execution result information, acquiring

execution result, acquiring

FILTER, [2]

findColumn(String columnName)

first()

font conventions

FULL OUTER JOIN

function for centrally managing client definitions (excluded operands)

FUNCTION NAME

GB meaning

generatedKeyAlwaysReturned()

getApName()

getAsciiStream(int columnIndex)

getAsciiStream(String columnName)

getAttributes

getAutoCommit()

getBestRowIdentifier

getBigDecimal(int columnIndex)

getBigDecimal(String columnName)

getBinaryStream(int columnIndex)

getBinaryStream(String columnName)

getBoolean(int columnIndex)

getBoolean(String columnName)

getByte(int columnIndex)

getByte(String columnName)

getBytes(int columnIndex)

getBytes(String columnName)

getCatalog()

getCatalogName(int column)

getCatalogs()

getCatalogSeparator()

getCatalogTerm()

getCharacterStream(int columnIndex)

getCharacterStream(String columnName)

getClientInfoProperties()

getColumnClassName(int column)

getColumnCount()

getColumnDisplaySize(int column)

getColumnLabel(int column)

getColumnName(int column)

getColumnPrivileges

getColumns

getColumnType(int column)

getColumnTypeName(int column)

getConcurrency()

getConnection

• DatabaseMetaData interface

• DataSource interface, [2]

• PooledConnection interface

• Statement interface

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

getCursorName()

getDatabaseMajorVersion()

getDatabaseMinorVersion()

getDatabaseProductName()

getDatabaseProductVersion()

getDate(int columnIndex, Calendar cal)

getDate(int columnIndex)

getDate(String columnName, Calendar cal)

getDate(String columnName)

getDefaultTransactionIsolation()

getDouble(int columnIndex)

getDouble(String columnName)

getDriverMajorVersion()

getDriverMinorVersion()

getDriverName()

getDriverVersion()

getEncodeLang()

getExportedKeys

getExtraNameCharacters()

getFetchDirection()

• ResultSet interface

• Statement interface

getFetchSize()

• ResultSet interface

• Statement interface

getFloat(int columnIndex)

getFloat(String columnName)

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

getFunctions(String catalog, String schemaPattern, String functionNamePattern)

getHADBConnectionID()

getHADBConnectionSerialNum()

getHADBOrderMode()

getHADBSQLHashFltSize()

getHADBSQLHashTblSize()

getHADBSQLMaxRthdNum()

getHADBSQLSerialNum()

• PreparedStatement interface

• Statement interface

getHADBStatementHandle()

• PreparedStatement interface

• Statement interface

getHADBTransactionID()

getHoldability()

• Connection interface

• ResultSet interface

getHostName()

getIdentifierQuoteString()

getImportedKeys

getIndexInfo

getInt(int columnIndex)

getInt(String columnName)

getInterfaceMethodTrace()

getJDBCMajorVersion()

getJDBCMinorVersion()

getLargeMaxRows()

getLargeUpdateCount()

getLoginTimeout()

• ConnectionPoolDataSource interface

• DataSource interface

getLogWriter()

• ConnectionPoolDataSource interface

• DataSource interface

getLong(int columnIndex)

getLong(String columnName)

getMajorVersion()

getMaxBinaryLiteralLength()

getMaxCatalogNameLength()

getMaxCharLiteralLength()

getMaxColumnNameLength()

getMaxColumnsInGroupBy()

getMaxColumnsInIndex()

getMaxColumnsInOrderBy()

getMaxColumnsInSelect()

getMaxColumnsInTable()

getMaxConnections()

getMaxCursorNameLength()

getMaxFieldSize()

getMaxIndexLength()

getMaxLogicalLobSize()

getMaxProcedureNameLength()

getMaxRows()

getMaxRowSize()

getMaxSchemaNameLength()

getMaxStatementLength()

getMaxStatements()

getMaxTableNameLength()

getMaxTablesInSelect()

getMaxUserNameLength()

getMetaData()

• Connection interface

• PreparedStatement interface

• ResultSet interface

getMinorVersion()

getMoreResults()

getNotErrorOccurred()

getNumericFunctions()

getObject(int columnIndex,Class<T> type)

getObject(int columnIndex)

getObject(String columnLabel,Class<T> type)

getObject(String columnName)

getParameterClassName(int param)

getParameterCount()

getParameterMetaData()

getParameterMode(int param)

getParameterType(int param)

getParameterTypeName(int param)

getPassword()

getPooledConnection()

getPooledConnection(String user, String password)

getPort()

getPrecision(int column)

getPrecision(int param)

getPrimaryKeys(String catalog, String schema, String table)

getProcedureColumns

getProcedures

getProcedureTerm()

getPropertyInfo(String url, Properties info)

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

getQueryTimeout()

getResultSet()

getResultSetConcurrency()

getResultSetHoldability()

• DatabaseMetaData interface

• Statement interface

getResultSetType()

getRow()

getRowIdLifetime()

getScale(int column)

getScale(int param)

getSchema()

getSchemaName(int column)

getSchemas()

getSchemas(String catalog, String schemaPattern)

getSchemaTerm()

getSearchStringEscape()

getShort(int columnIndex)

getShort(String columnName)

getSQLKeywords()

getSQLStateType()

getSQLWarningKeep()

getStatement()

getString(int columnIndex)

getString(String columnName)

getStringFunctions()

getSuperTables

getSuperTypes

getSystemFunctions()

getTableName(int column)

getTablePrivileges

getTables

getTableTypes()

getTime(int columnIndex, Calendar cal)

getTime(int columnIndex)

getTime(String columnName, Calendar cal)

getTime(String columnName)

getTimeDateFunctions()

getTimestamp(int columnIndex, Calendar cal)

getTimestamp(int columnIndex)

getTimestamp(String columnName, Calendar cal)

getTimestamp(String columnName)

getTraceNumber()

getTransactionIsolation()

getType()

getTypeInfo()

getTypeMap()

getUDTs

getUpdateCount()

getURL()

getUser()

getUserName()

getVersionColumns

getWarnings()

• Connection interface

• ResultSet interface

• Statement interface

global hash grouping

GLOBAL HASH GROUPING

GLOBAL HASH UNIQUE

global work table

GROUPING

grouping method

• hash grouping

• sort grouping

GROUPING SET, [2]

grouping set information, [2]

HADB client

• downgrading

• estimating memory requirements for

• uninstalling (for Linux)

• version upgrade

HADB client (for Linux)

• installing

HADB client (for Windows)

• installing

• uninstalling

HADB ODBC driver environment setup

HADB ODBC driver trace information

• output information

HADB server

• connecting to (CLI function, example of)

• disconnecting from (CLI function, example of)

• how to connect to (Java)

handling unresponsive application programs

• if JDBC driver is used

handling unresponsiveness

• if JDBC driver is used

• if ODBC driver or CLI functions are used

HASH

hash execution

• method for processing SELECT DISTINCT

• method for processing set operation

• methods for processing subqueries that contain external reference column

• methods for processing subqueries that do not contain external reference column

hash group area size

hash grouping

• global hash grouping

• local hash grouping

hash join

HASH JOIN, [2]

hash retrieval information

hash table

hashing

HAVING

header file

host

• URL for connection

host name, specifying

identification information view

implicit cursor

INDEX

INDEX COLUMN

INDEX NAME

index priority

index scan

INDEX SCAN, [2]

index specification, using

INDEX TYPE

indicator

information displayed for access path (alphabetical order)

INNER JOIN

inner table

INSERT STATEMENT

insertsAreDetected(int type)

installing

• Java Development Kit

• Java Runtime Environment

• JDBC driver

internal derived table, expanding

INTERSECT ALL

INTERSECT DISTINCT

isAfterLast()

isAutoIncrement(int column)

isBeforeFirst()

isCaseSensitive(int column)

isCatalogAtStart()

isClosed()

• Connection interface

• ResultSet interface

• Statement interface

isCloseOnCompletion()

isCurrency(int column)

isDefinitelyWritable(int column)

isFirst()

isLast()

isNullable(int column)

isNullable(int param)

isPoolable()

isReadOnly()

• Connection interface

• DatabaseMetaData interface

isReadOnly(int column)

isSearchable(int column)

isSigned(int column)

isSigned(int param)

isValid(int timeout)

isWrapperFor(Class<?> iface)

isWritable(int column)

java.sql.Driver, automatic loading of

JDBC 1.2 API

JDBC driver

• installing

• replacing with revised version

• uninstalling

• upgrading

JDBC interface method trace

JDBC standards compliance, scope of

jdbc:hadb

jdbcCompliant()

JNDI

JNDI support

join methods

join type

JOIN TYPE

joined column

KB meaning

key

key condition (B-tree index)

key scan

KEY SCAN, [2]

LANG (environment variable)

large update counts

last()

LD_LIBRARY_PATH (environment variable)

LEFT OUTER JOIN

LIMIT

linking

list of error cause codes (return values of CLI functions)

local hash grouping

LOCAL HASH GROUPING

local work table

locatorsUpdateCopy()

log writer, setting

• ConnectionPoolDataSource interface

• DataSource interface

MB meaning

memory requirement, estimating (for HADB Client)

method for processing SELECT DISTINCT

• hash execution

• work table execution

method for processing set operation

• hash execution

• work table execution

methods for searching tables

methodtrace

• URL for connection

• user property

nativeSQL(String sql)

NESTED LOOP JOIN, [2]

nested loops row value execution

nested loops work table execution

nested-loop join

next()

non-retrieval SQL statement

nullPlusNonNullIsNull()

nullsAreSortedAtEnd()

nullsAreSortedAtStart()

nullsAreSortedHigh()

nullsAreSortedLow()

number-of-batch-transmission-rows

ODBC

• troubleshooting

ODBC cursor library

ODBC driver environment setup

ODBC functions, list of

ODBC traces

ORDER

OS time, changing

• notes

othersDeletesAreVisible(int type)

othersInsertsAreVisible(int type)

othersUpdatesAreVisible(int type)

outer table

overflow handling

ownDeletesAreVisible(int type)

ownInsertsAreVisible(int type)

ownUpdatesAreVisible(int type)

package name

• Connection interface

• DatabaseMetaData interface

• Driver interface

• JAR file

• PreparedStatement interface

• ResultSet interface

• ResultSetMetaData interface

• Statement interface

package name of JAR file

ParameterMetaData interface

password

• URL for connection

• user property

PATH (environment variable), [2]

pattern character string, special character that can be specified in

PB meaning

PooledConnection interface

port

• URL for connection

port number, specifying

PreparedStatement interface

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

prepareStatement(String sql, int resultSetType, int resultSetConcurrency)

prepareStatement(String sql)

preprocessing and execution of SQL statements

• a_rdb_SQLExecDirect()

preprocessing of SQL statements

• a_rdb_SQLPrepare()

previous()

priority (connection information)

PROBE COLUMN, [2]

processing subqueries

• that contain external reference column

• that do not contain external reference column

property

• URL for connection

PURGE CHUNK STATEMENT

QUERY

QUERY SCAN

query tree

query tree number

range index condition

• skipping chunks

• skipping segments

range indexes used during execution of SQL statement

range search condition (B-tree index)

read-only mode

read-only transaction

read/write mode

read/write transaction

RECURSIVE

registering registry key

• HADB client

• ODBC

relative(int rows)

releasing connection handle

• example of using CLI function

removeConnectionEventListener

replacing (revised version of HADB client)

replacing HADB client with revised version

replacing JAR file

restoring OS time on client machine

result set extended function, scope of support for

ResultSet interface

ResultSetMetaData interface

retrieval methods

retrieval result

• acquiring

retrieval result column

• acquiring information about (a_rdb_SQLDescribeCols())

• acquiring information about (CLI function, example of)

• associating (a_rdb_SQLBindCols())

• associating (CLI function, example of)

retrieval result columns

• acquiring number of (a_rdb_SQLNumResultCols())

• acquiring number of (CLI function, example of)

retrieval SQL statement

return values (CLI functions)

return values of CLI functions

reviewing scope of scans

• antivirus software (if JDBC driver is used)

RIGHT OUTER JOIN

rollback()

row ID

ROW specification

row value execution

row, fetching (a_rdb_SQLFetch())

RowSets

sample application program

sample1

scalar function

• added

• that can be specified in escape clause

scrollable cursors

scrolling type

search condition

• how to evaluate

SELECT STATEMENT

selection rules for text indexes

SET OPERATION

SET OPERATION TYPE

setApName(String name)

setAsciiStream

setAutoCommit(boolean autoCommit)

setBigDecimal(int parameterIndex, BigDecimal x)

setBinaryStream(int parameterIndex, InputStream x, int length)

setBoolean(int parameterIndex, boolean x)

setByte(int parameterIndex, byte x)

setBytes(int parameterIndex, byte[] x)

setCatalog(String catalog)

setCharacterStream

setCursorName(String name)

setDate(int parameterIndex, Date x, Calendar cal)

setDate(int parameterIndex, Date x)

setDouble(int parameterIndex, double x)

setEncodeLang(String lang)

setEscapeProcessing(boolean enable)

setFetchDirection(int direction)

• ResultSet interface

• Statement interface

setFetchSize(int rows)

• ResultSet interface

• Statement interface

setFloat(int parameterIndex, float x)

setHADBAuditInfo(int pos,String userinfo)

setHADBOrderMode(int mode)

setHADBSQLHashFltSize(int areaSize)

setHADBSQLHashTblSize(int areaSize)

setHADBSQLMaxRthdNum(int rthdNum)

setHoldability(int holdability)

setHostName(String name)

setInt(int parameterIndex, int x)

setInterfaceMethodTrace(boolean flag)

setLargeMaxRows(long max)

setLoginTimeout(int seconds)

• ConnectionPoolDataSource interface

• DataSource interface

setLogWriter (DataSource interface)

setLogWriter(PrintWriter out) (ConnectionPoolDataSource interface)

setLong(int parameterIndex, long x)

setMaxFieldSize(int max)

setMaxRows(int max)

setNotErrorOccurred(boolean mode)

setNull(int parameterIndex,int sqlType)

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

setObject(int parameterIndex, Object x, int targetSqlType)

setObject(int parameterIndex, Object x)

setPassword(String password)

setPort(int port)

setQueryTimeout(int seconds)

setReadOnly(boolean readOnly)

setSchema(String schema)

setShort(int parameterIndex, short x)

setSQLWarningKeep(boolean mode)

setString(int parameterIndex, String x)

setTime(int parameterIndex, Time x, Calendar cal)

setTime(int parameterIndex, Time x)

setTimestamp(int parameterIndex, Timestamp x, Calendar cal)

setTimestamp(int parameterIndex, Timestamp x)

setting system properties

setting up environment (HADB client)

setting up environment for HADB client

setting up environment for JDBC driver

settings for outputting HADB ODBC driver trace information

setTraceNumber(int num)

setTransactionIsolation(int level)

setUser(String user)

size of hash filter area

size of hash table area

SKIP COND

sort grouping

SORT GROUPING

SORTING

special character

SPECIFIC, [2], [3], [4], [5], [6]

SPECIFIC DISABLED, [2]

specifying character encoding

• in Linux

• in Windows

specifying data sources (ODBC)

specifying environment variables

• Linux

• Windows

specifying transaction access mode

• for client definition

• system property

• URL for connection

• user property

specifying URL

specifying user properties

SQL data types, correspondence

SQL exception extension

SQL exception extension function (JDBC 4.0 API)

SQL processing, canceling (CLI function)

SQL request, creating

SQL Serial Number

SQL statement

• adding to batch

• canceling

• executing

• executing (a_rdb_SQLExecute())

• executing (CLI function, example of)

• execution plan

• how to evaluate error

• preprocessing (CLI function, example of)

• preprocessing and executing (CLI function, example of)

• terminating execution of

• that creates work tables, considerations when executing

SQL statement identification information

SQLAllocHandle

SQLBindCol

SQLBindParameter

SQLBrowseConnect, SQLBrowseConnectW

SQLBulkOperations

SQLCancel

SQLCloseCursor

SQLColAttribute, SQLColAttributeW

SQLColumnPrivileges, SQLColumnPrivilegesW

SQLColumns, SQLColumnsW

SQLConnect, SQLConnectW

SQLCopyDesc

SQLDataSources, SQLDataSourcesW

SQLDescribeCol, SQLDescribeColW

SQLDescribeParam

SQLDisconnect

SQLDriverConnect, SQLDriverConnectW

SQLDrivers, SQLDriversW

SQLEndTran

SQLException interface

SQLExecDirect, SQLExecDirectW

SQLExecute

SQLFetch

SQLFetchScroll

SQLForeignKeys, SQLForeignKeysW

SQLFreeHandle

SQLFreeStmt

SQLGetConnectAttr, SQLGetConnectAttrW

SQLGetCursorName, SQLGetCursorNameW

SQLGetData

SQLGetDescField, SQLGetDescFieldW

SQLGetDescRec, SQLGetDescRecW

SQLGetDiagField, SQLGetDiagFieldW

SQLGetDiagRec, SQLGetDiagRecW

SQLGetEnvAttr

SQLGetFunctions

SQLGetInfo, SQLGetInfoW

SQLGetStmtAttr, SQLGetStmtAttrW

SQLGetTypeInfo, SQLGetTypeInfoW

SQLMoreResults

SQLNativeSql, SQLNativeSqlW

SQLNumParams

SQLNumResultCols

SQLParamData

SQLPrepare, SQLPrepareW

SQLPrimaryKeys, SQLPrimaryKeysW

SQLProcedureColumns, SQLProcedureColumnsW

SQLProcedures, SQLProceduresW

SQLPutData

SQLRowCount

SQLSetConnectAttr, SQLSetConnectAttrW

SQLSetCursorName, SQLSetCursorNameW

SQLSetDescField, SQLSetDescFieldW

SQLSetDescRec

SQLSetEnvAttr

SQLSetPos

SQLSetStmtAttr, SQLSetStmtAttrW

SQLSpecialColumns, SQLSpecialColumnsW

SQLStatistics, SQLStatisticsW

SQLTablePrivileges, SQLTablePrivilegesW

SQLTables, SQLTablesW

SQLWarning interface

sqlwarningkeep

• URL for connection

• user property

statement handle

• allocating (a_rdb_SQLAllocStmt())

• allocating (CLI function, example of)

• releasing (a_rdb_SQLFreeStmt())

• releasing (CLI function, example of)

Statement interface

storesLowerCaseIdentifiers()

storesLowerCaseQuotedIdentifiers()

storesMixedCaseIdentifiers()

storesMixedCaseQuotedIdentifiers()

storesUpperCaseIdentifiers()

storesUpperCaseQuotedIdentifiers()

structure

SUBQUERY

SUBQUERY HASH

SUBQUERY LOOP

subquery processing method

• hash execution, [2]

• nested loops row value execution

• nested loops work table execution

• row value execution

• work table execution

• work table row value execution

subquery, how to process

supportsAlterTableWithAddColumn()

supportsAlterTableWithDropColumn()

supportsANSI92EntryLevelSQL()

supportsANSI92FullSQL()

supportsANSI92IntermediateSQL()

supportsBatchUpdates()

supportsCatalogsInDataManipulation()

supportsCatalogsInIndexDefinitions()

supportsCatalogsInPrivilegeDefinitions()

supportsCatalogsInProcedureCalls()

supportsCatalogsInTableDefinitions()

supportsColumnAliasing()

supportsConvert()

supportsConvert(int fromType, int toType)

supportsCoreSQLGrammar()

supportsCorrelatedSubqueries()

supportsDataDefinitionAndDataManipulationTransactions()

supportsDataManipulationTransactionsOnly()

supportsDifferentTableCorrelationNames()

supportsExpressionsInOrderBy()

supportsExtendedSQLGrammar()

supportsFullOuterJoins()

supportsGetGeneratedKeys()

supportsGroupBy()

supportsGroupByBeyondSelect()

supportsGroupByUnrelated()

supportsIntegrityEnhancementFacility()

supportsLikeEscapeClause()

supportsLimitedOuterJoins()

supportsMinimumSQLGrammar()

supportsMixedCaseIdentifiers()

supportsMixedCaseQuotedIdentifiers()

supportsMultipleOpenResults()

supportsMultipleResultSets()

supportsMultipleTransactions()

supportsNamedParameters()

supportsNonNullableColumns()

supportsOpenCursorsAcrossCommit()

supportsOpenCursorsAcrossRollback()

supportsOpenStatementsAcrossCommit()

supportsOpenStatementsAcrossRollback()

supportsOrderByUnrelated()

supportsOuterJoins()

supportsPositionedDelete()

supportsPositionedUpdate()

supportsRefCursors()

supportsResultSetConcurrency(int type, int concurrency)

supportsResultSetHoldability(int holdability)

supportsResultSetType(int type)

supportsSavepoints()

supportsSchemasInDataManipulation()

supportsSchemasInIndexDefinitions()

supportsSchemasInPrivilegeDefinitions()

supportsSchemasInProcedureCalls()

supportsSchemasInTableDefinitions()

supportsSelectForUpdate()

supportsStatementPooling()

supportsStoredFunctionsUsingCallSyntax()

supportsStoredProcedures()

supportsSubqueriesInComparisons()

supportsSubqueriesInExists()

supportsSubqueriesInIns()

supportsSubqueriesInQuantifieds()

supportsTableCorrelationNames()

supportsTransactionIsolationLevel(int level)

supportsTransactions()

supportsUnion()

supportsUnionAll()

surrogate pair

symbol conventions

symbolic literal

system information for data source, acquiring

TABLE FUNCTION DERIVED TABLE

table joining methods

table scan

TABLE SCAN, [2]

TABLE VALUE CONSTRUCTOR SCAN

TB meaning

text indexes used during execution of SQL statement

time change

• machine on which JDBC driver has been installed

• OS on client machine

TIME-type data

• converting (CLI function)

• converting to (CLI function)

timeout

• HADB server connection processing

• HADB server processing request

timeout value, specifying

• DataSource interface, [2]

• Statement interface

TIMESTAMP-type data

• converting (CLI function)

• converting to (CLI function)

trace level

tracenum

• URL for connection

• user property

transaction access mode, specifying

• for CLI functions

• for JDBC driver

• for ODBC driver

transaction control (designing application program)

Transaction ID

transaction, terminating (CLI function)

tree row number

tree view

• information displayed in

troubleshooting (ODBC)

try-with-resources statement

tuning

types of work tables

• global work table

• local work table

TZ (environment variable), [2]

• if JDBC driver is used

UNION ALL

UNION DISTINCT

unsupported interface

• JDBC 1.2 API

• JDBC 2.1 Core API

• JDBC 3.0 API

• JDBC 4.0 API

unwrap(Class<T> iface)

update operation on retrieval using cursor, effect of

update SQL statement

UPDATE STATEMENT

updatesAreDetected(int type)

URL for connection

• encodelang

USE FILTER, [2]

user

• URL for connection

• user property

user property

• encodelang

usesLocalFilePerTable()

usesLocalFiles()

USING CACHE

USING COST

using datetime information of archive range column to narrow search range

value

VARBINARY-type data

• converting (CLI function)

• converting to (CLI function)

Version

version number conventions

version upgrade (HADB client)

wasNull()

WINDOW

work table execution

• method for processing SELECT DISTINCT

• method for processing set operation

• methods for processing subqueries that do not contain external reference column

work table row value execution

WORK TABLE SCAN

work tables created when SQL statements are executed

Wrapper interface

wrapper pattern