Index

A B C D E F G H I L M N O P Q R S T U W X

A

access control

connections, 2.4.3

CREATE SESSION privilege to connect, 2.4.3.2

in XLA, 2.7.3

TimesTen features, 2.3

acknowledging XLA updates

ackUpdates method, 3.3.1.3.1

at transaction boundaries, 2.7.2

without transaction boundaries, 2.7.1

ackUpdates method (XLA), 3.3.1.3.1

add method (add table handler to XLA table list), 3.3.4.3.1

AddConnectionToPool method, 3.1.4.3.1

AIX, linking considerations, 1.2.1

autocommit, 3.1.3.3.10

B

batch operations

bind parameter, 3.1.5.5.2

execute, 3.1.5.5.3

prepare, 3.1.5.5.4

size of batch, 3.1.5.5.1

TTCmd methods, 3.1.5.5

batchSize method, 3.1.5.5.1

bind variable--see binding parameters

binding parameters

duplicate parameters in SQL, 2.5.1.4

input parameters, 2.5.1.1

length of bound value, setting (batch), 3.1.5.5.5

length of bound value, setting (non-batch), 3.1.5.3.23

null value, setting (batch), 3.1.5.5.6

null value, setting (non-batch), 3.1.5.3.24

output and input/output parameters, 2.5.1.3

registering parameters, 2.5.1.2

registerParam method, 3.1.5.3.19

set parameter value (batch), 3.1.5.5.2

set parameter value (non-batch), 3.1.5.3.22

BindParameter method (bind parameter, batch), 3.1.5.5.2

bookmark

acquire location, 3.3.1.3.6

delete, 3.3.1.3.3

return to location, 3.3.1.3.7

C

catalog

catalog class (metadata information, tables), 3.2.1

column class (metadata information, column), 3.2.3

fetch catalog data, 3.2.1.2.1

index class (metadata information, index), 3.2.4

special column class (metadata information, special column), 3.2.5

system catalog classes, 3.2

table class (metadata information, single table), 3.2.2

client/server, deferred prepare, 3.1.5.3.17

Close method (close result set), 3.1.5.3.1

column class, catalog, 3.2.3

column, number of columns, return, 3.2.2.2.3

columnPrec method (XLA row viewer), 3.3.2.3.1

columnScale method (XLA row viewer), 3.3.2.3.2

Commit method, 3.1.3.3.1

compiler macros

64-bit TimesTen, 1.1.3.4

C++ streams, 1.1.3.2

gcc, 1.1.3.5

throw C++ exceptions, 1.1.3.1

TT_64BIT, 1.1.3.4

TTC_USE_STRINGSTREAM, 1.1.3.2.1

TTDEBUG, 1.1.3.3

TTEXCEPT, 1.1.3.1

USE_OLD_CPP_STREAMS, 1.1.3.2.3

compiling

applications, 1.2

applications on UNIX, 1.2.1

applications on Windows, 1.2.2

TTClasses on UNIX, 1.1.1.2

TTClasses on Windows, 1.1.2.2

UNIX compilation options for TTClasses, 1.1.1.3

Windows compilation options for TTClasses, 1.1.2.3

Connect method

description, 3.1.3.3.2

example, 2.2

XLA, 3.3.1.3.2

connection

access control, 2.4.3

autocommit, 3.1.3.3.10

confirm connection, 3.1.3.3.7

connect (XLA), 3.3.1.3.2

Connect method example, 2.2

connecting, 3.1.3.3.2

connecting and disconnecting, 2.4.2

connection class definition, 2.2

connection pools, 3.1.4

context value, 3.1.3.3.6

CREATE SESSION privilege, 2.4.3.2

disconnect (XLA), 3.3.1.3.4

Disconnect method example, 2.2

disconnecting, 3.1.3.3.3

managing connections, 2.4

ODBC connection handle, 3.1.3.3.5

privilege for XLA connections, 2.4.3.3

TTConnection class, 3.1.3

validity check, 3.1.2.4.1

XLA, privilege for connections, 2.4.3.3

connection pool

adding connection to pool, 3.1.4.3.1

connecting all connections in pool, 3.1.4.3.2

disconnecting all connections in pool, 3.1.4.3.3

getting a connection from pool, 3.1.4.3.5

returning a connection to pool, 3.1.4.3.4

status information, 3.1.4.3.6

TTConnectionPool class, 3.1.4

CREATE SESSION privilege, 2.4.3.2

D

data source names (DSNs), 2.4.1

debugging

debug libraries, shared and static (UNIX), 1.1.1.3

generating information, 1.1.3.3

shared debug library (UNIX), 1.1.1.3

static debug library (UNIX), 1.1.1.3

deferred prepare, client/server, 3.1.5.3.17

del method (delete table handler from XLA table list), 3.3.4.3.2

delete TTClasses libraries and object files

UNIX, 1.1.1.3

Windows, 1.1.2.3

deleteBookmarkAndDisconnect method, 3.3.1.3.3

demos for TTClasses, 1.3

disableLogging method, 3.1.1.3.1

DisableTracking method (XLA table handler), 3.3.3.4.1

Disconnect method

description, 3.1.3.3.3

XLA, 3.3.1.3.4

DisconnectAll method, 3.1.4.3.3

DO_NOT_THROW flag (TTStatus), suppress exceptions, 3.1.2.1

driver manager

restrictions, 1.2.3

shared optimized library for driver manager (Windows), 1.1.2.3

Drop method (drop prepared statement), 3.1.5.3.2

DSNs (data source names), 2.4.1

duplicate parameter binding, 2.5.1.4

DuplicateBindMode general connection attribute, 2.5.1.4

DurableCommit method, 3.1.3.3.4

E

EnableTracking method (XLA table handler), 3.3.3.4.2

environment handle, ODBC, 3.1.1.3.4

environment variables

UNIX, 1.1.1.1

Windows, 1.1.2.1

error reporting

print error to stream, 3.1.2.4.2

suppress exceptions, DO_NOT_THROW flag, 3.1.2.1

try/catch with TTStatus, 3.1.2.1

TTError class, 3.1.2.2.1

TTStatus class, 3.1.2

TTWarning class, 3.1.2.2.2

Execute method (execute statement), 3.1.5.3.3

ExecuteBatch method, 3.1.5.5.3

ExecuteImmediate method (instead of Prepare and Execute), 3.1.5.3.4

F

fetch result set row, 3.1.5.3.5

fetchCatalogData method, 3.2.1.2.1

FetchNext method (fetch result set row), 3.1.5.3.5

fetchUpdatesWait method (XLA), 3.3.1.3.5

freeConnection method, 3.1.4.3.4

G

gcc, using to compile TTClasses, 1.1.3.5

generateSQL method (XLA table handler), 3.3.3.4.3

Get method (column value, XLA row viewer), 3.3.2.3.3

getBookmarkIndex method (XLA), 3.3.1.3.6

getCollation method (index), 3.2.4.2.1

getColName method (XLA column), 3.3.6.3.1

getColNumber method (XLA table), 3.3.5.3.1

getColumn method

catalog, column, 3.2.2.2.1

description, 3.1.5.3.6

metadata, XLA row viewer, 3.3.2.3.4

getColumnLength method, 3.1.5.3.7

getColumnName method

catalog, column, 3.2.3.2.1

description, 3.1.5.4.1

index, 3.2.4.2.2

getColumnName method (special column), 3.2.5.3.1

getColumnNullability method, 3.1.5.4.2

getColumnNullable method, 3.1.5.3.8

getColumnPrecision method, 3.1.5.4.3

getColumnScale method, 3.1.5.4.4

getColumnType method, 3.1.5.4.5

getDataType method

column, 3.2.3.2.2

special column, 3.2.5.3.2

getHdbc method, 3.1.3.3.5

getIndex method, 3.2.2.2.2

getIndexName method, 3.2.4.2.3

getIndexOwner method, 3.2.4.2.4

getLength method

column, 3.2.3.2.3

special column, 3.2.5.3.3

getMaxRows method, 3.1.5.3.10

getNCols method (number of columns, XLA table), 3.3.5.3.2

getNColumns method, 3.1.5.4.6

getNextColumn method, 3.1.5.3.11

getNextColumnNullable method, 3.1.5.3.12

getNParameters method, 3.1.5.4.7

getNullable method (column), 3.2.3.2.4

getNumColumns method

index, 3.2.4.2.5

table, 3.2.2.2.3

getNumIndexes method, 3.2.2.2.4

getNumSpecialColumns method, 3.2.2.2.5

getNumSysTables method, 3.2.1.2.2

getNumTables method, 3.2.1.2.3

getNumUserTables method, 3.2.1.2.4

getOwnerName method (XLA table), 3.3.5.3.3

getParam method, 3.1.5.3.13

getParamNullability method, 3.1.5.4.8

getParamPrecision method, 3.1.5.4.9

getParamScale method, 3.1.5.4.10

getParamType method, 3.1.5.4.11

getPrecision method

column, 3.2.3.2.5

special column, 3.2.5.3.4

XLA column, 3.3.6.3.2

getQueryThreshold method, 3.1.5.3.14

getRadix method, column, 3.2.3.2.6

getRowCount method, 3.1.5.3.15

getScale method

column, 3.2.3.2.7

special column, 3.2.5.3.5

XLA column, 3.3.6.3.3

getSize method (XLA column), 3.3.6.3.4

getSpecialColumn method, 3.2.2.2.6

getStats method, 3.1.4.3.6

getSysColNum method (XLA column), 3.3.6.3.5

getTable method, 3.2.1.2.5

getTableIndex method, 3.2.1.2.6

getTableName method

catalog, table, 3.2.2.2.7

index, 3.2.4.2.6

XLA table, 3.3.5.3.4

getTableOwner method, 3.2.2.2.8

getTableType method, 3.2.2.2.9

GetTTContext method, 3.1.3.3.6

getType method

index, 3.2.4.2.7

XLA column, 3.3.6.3.6

getTypeName method

column, 3.2.3.2.8

special column, 3.2.5.3.6

getUserColNum method (XLA column), 3.3.6.3.7

getUserTable method, 3.2.1.2.7

H

HandleChange method

XLA table handler, 3.3.3.4.4

XLA table list, 3.3.4.3.3

HandleDelete method (XLA table handler), 3.3.3.4.5

HandleInsert method (XLA table handler), 3.3.3.4.6

HandleUpdate method (XLA table handler), 3.3.3.4.7

HDBC (connection) handle, ODBC, 3.1.3.3.5

HENV (environment) handle, ODBC, 3.1.1.3.4

HSTMT (statement) handle, ODBC, 3.1.5, 3.1.5.3.9

I

index class, catalog, 3.2.4

index, number of indexes, return, 3.2.2.2.4

input parameters, 2.5.1.1

I/O streams, C++ flag settings, 1.1.3.2

isBeingExecuted method, 3.1.5.4.12

isColumnNull method, 3.1.5.3.16

isColumnTTTimestamp method (XLA row viewer), 3.3.2.3.5

isConnected method, 3.1.3.3.7

isConnectionInvalid method, 3.1.2.4.1

isNull method (column, XLA row viewer), 3.3.2.3.6

isNullable method (XLA column), 3.3.6.3.8

isolation level

Read Committed, 3.1.3.3.11

Serializable, 3.1.3.3.12

isPKColumn method (primary key, XLA column), 3.3.6.3.9

isSystemTable method, 3.2.2.2.10

isTTTimestamp method (XLA column), 3.3.6.3.10

isUnique method (index), 3.2.4.2.8

isUpdated method (XLA column), 3.3.6.3.11

isUserTable method, 3.2.2.2.11

L

linking applications

AIX considerations, 1.2.1

on UNIX, 1.2.1

on Windows, 1.2.2

references to related information, 1.2

Solaris considerations, 1.2.1

LOBs

TimesTen support, 2.5.4

XLA support, 2.7

lock timeout interval, 3.1.3.3.13

logging

disable, 3.1.1.3.1

levels, 3.1.1.3.2

logging information, where to send, 3.1.1.3.3

TTGlobal class, 3.1.1

using, 2.6

M

macros--see compiler macros

make

clean, delete TTClasses libraries and object files (UNIX), 1.1.1.3

clean, delete TTClasses libraries and object files (Windows), 1.1.2.3

debug libraries (UNIX), 1.1.1.3

optimized libraries (UNIX), 1.1.1.3

optimized libraries, direct and client/server (Windows), 1.1.2.3

optimized library, client/server (Windows), 1.1.2.3

shared debug library (UNIX), 1.1.1.3

shared optimized library (UNIX), 1.1.1.3

shared optimized library for driver manager (Windows), 1.1.2.3

static debug library (UNIX), 1.1.1.3

static optimized library (UNIX), 1.1.1.3

metadata

column, 3.2.3

index, 3.2.4

number of system tables, 3.2.1.2.2

number of tables, 3.2.1.2.3

number of user tables, 3.2.1.2.4

special column, 3.2.5

table, single, 3.2.2

tables, 3.2.1

multithreaded applications, 3.1.4

N

name of table, return, 3.2.2.2.7

numUpdatedCols method (XLA row viewer), 3.3.2.3.7

O

ODBC

HDBC (connection) handle, 3.1.3.3.5

HENV (environment) handle, 3.1.1.3.4

HSTMT (statement) handle, 3.1.5, 3.1.5.3.9

optimized library

client/server (Windows), 1.1.2.3

direct and client/server (Windows), 1.1.2.3

for driver manager (Windows), 1.1.2.3

shared (UNIX), 1.1.1.3

shared and static (UNIX), 1.1.1.3

static (UNIX), 1.1.1.3

ostream method, 3.1.2.4.2

OUT and IN OUT parameters

getting output values, 3.1.5.3.13

registering, 2.5.1.2

output and input/output parameters

binding, 2.5.1.3

owner of table, return, 3.2.2.2.8

P

parameter binding--see binding parameters

prefetch, 3.1.3.3.15

Prepare method (prepare statement), 3.1.5.3.17

PrepareBatch method, 3.1.5.5.4

printColumn method, 3.1.5.3.18

Q

query--see result set

Quick Start demos for TTClasses, 1.3

R

REF CURSORs

getParam method for REF CURSORs, 3.1.5.3.13

using, 2.5.2

registerParam method, 2.5.1.2, 3.1.5.3.19

RePrepare method (after invalidation), 3.1.5.3.20

result set

close, 3.1.5.3.1

fetch a column of current row, 3.1.5.3.6

fetch next column of current row, 3.1.5.3.11

fetch row, 3.1.5.3.5

maximum rows, 3.1.5.3.21

print value of a column of current row, 3.1.5.3.18

Rollback method, 3.1.3.3.8

rowids, ROWID type, 2.5.3

S

SetAutoCommitOff method, 3.1.3.3.9

SetAutoCommitOn method, 3.1.3.3.10

setBookmarkIndex method (XLA), 3.3.1.3.7

SetIsoReadCommitted method, 3.1.3.3.11

SetIsoSerializable method, 3.1.3.3.12

SetLockWait method, 3.1.3.3.13

setLogLevel method, 3.1.1.3.2

setLogStream method, 3.1.1.3.3

setMaxRows method, 3.1.5.3.21

setParam method (bind parameter, non-batch), 3.1.5.3.22

setParamLength method

batch operations, 3.1.5.5.5

non-batch operations, 3.1.5.3.23

setParamNull method

batch operations, 3.1.5.5.6

non-batch operations, 3.1.5.3.24

SetPrefetchCloseOff method, 3.1.3.3.14

SetPrefetchCloseOn method, 3.1.3.3.15

SetPrefetchCount method, 3.1.3.3.16

setQueryThreshold method, 3.1.5.3.25

setQueryTimeout method, 3.1.5.3.26

setTuple method (XLA row viewer), 3.3.2.3.8

shared debug library (UNIX), 1.1.1.3

shared optimized library (UNIX), 1.1.1.3

size of batch, 3.1.5.5.1

Solaris, linking considerations, 1.2.1

special column class, catalog, 3.2.5

SQL statements

drop, 3.1.5.3.2

execute, 3.1.5.3.3

execute immediate (instead of prepare and execute), 3.1.5.3.4

execution, confirm, 3.1.5.4.12

number of rows affected, 3.1.5.3.15

prepare, 3.1.5.3.17

reprepare (after invalidation), 3.1.5.3.20

timeouts and thresholds, 2.5.5

TTCmd class, 3.1.5

sqlhenv method, 3.1.1.3.4

statement handle, ODBC, 3.1.5, 3.1.5.3.9

statements--see SQL statements

static debug library (UNIX), 1.1.1.3

static optimized library (UNIX), 1.1.1.3

streams, C++ flag settings, 1.1.3.2

system catalog--see catalog

T

table class, catalog, 3.2.2

threshold, SQL statements, 2.5.5

throwError method, 3.1.2.4.3

timeout, SQL statements, 2.5.5

transaction

acknowledge XLA updates at transaction boundaries, 2.7.2

acknowledge XLA updates without transaction boundaries, 2.7.1

autocommit, 3.1.3.3.10

committing, 3.1.3.3.1

durable commit, 3.1.3.3.4

isolation level, Read Commited, 3.1.3.3.11

isolation level, Serializable, 3.1.3.3.12

log API, overview, 2.7

rolling back, 3.1.3.3.8

TT_64BIT compiler macro, 1.1.3.4

TTC_USE_STRINGSTREAM compiler macro, 1.1.3.2.1

TTCatalog class (metadata information, tables), 3.2.1

TTCatalogColumn class

metadata information, column, 3.2.3

return a TTCatalogColumn object, 3.2.2.2.1

TTCatalogIndex class

metadata information, index, 3.2.4

return a TTCatalogIndex object, 3.2.2.2.2

TTCatalogSpecialColumn class

metadata information, special column, 3.2.5

return a TTCatalogSpecialColumn object, 3.2.2.2.6

TTCatalogTable class

metadata information, single table, 3.2.2

return a TTCatalogTable object, 3.2.1.2.5

TTCmd class (SQL statement)

batch operations, 3.1.5.5

general use, 3.1.5.3

introduction and overview, 3.1.5

non-batch operations, 3.1.5.3

object properties, obtaining, 3.1.5.4

overview, using, 2.2

TTConnection class

description, 3.1.3

overview, using, 2.2

TTConnectionPool class

description, 3.1.4

overview, using, 2.2

TTDEBUG compiler macro, 1.1.3.3

TTError class, 3.1.2.2.1

TTEXCEPT compiler macro, 1.1.3.1

TTGlobal class (logging), 3.1.1

TTStatus class (error reporting), 3.1.2

TTWarning class, 3.1.2.2.2

TTXlaColumn class, 3.3.6

TTXlaPersistConnection class, 3.3.1

TTXlaRowViewer class, 3.3.2

TTXlaTable class, 3.3.5

TTXlaTableHandler class, 3.3.3

TTXlaTableList class, 3.3.4

U

UNIX

compilation options for TTClasses, 1.1.1.3

compiling and linking applications, 1.2.1

compiling TTClasses, 1.1.1.2

environment variables, 1.1.1.1

installing TTClasses library, 1.1.1.4

updatedCol method (XLA row viewer), 3.3.2.3.9

USE_OLD_CPP_STREAMS compiler macro, 1.1.3.2.3

W

Windows

compilation options for TTClasses, 1.1.2.3

compiling and linking applications, 1.2.2

compiling TTClasses, 1.1.2.2

environment variables, 1.1.2.1

X

XLA

access control, 2.7.3

ackUpdates method, acknowledge updates, 3.3.1.3.1

bookmark location, acquire, 3.3.1.3.6

bookmark location, return, 3.3.1.3.7

classes, 2.7

classes to use XLA, 3.3

column class, 3.3.6

connect, 3.3.1.3.2

connection, create, 3.3.1

connections, privilege, 2.4.3.3

delete bookmark, 3.3.1.3.3

disconnect, 3.3.1.3.4

fetch records, 3.3.1.3.5

LOB support, 2.7

privilege for connections, 2.4.3.3

row viewer class, 3.3.2

table class, 3.3.5

table handler class, 3.3.3

table list class, 3.3.4

updates, acknowledging at transaction boundaries, 2.7.2

updates, acknowledging without transaction boundaries, 2.7.1