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 in XLA, 2.6.3
acknowledging XLA updates
ackUpdates method, 3.3.1.3.1
at transaction boundaries, 2.6.2
without transaction boundaries, 2.6.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.4.1.4
input parameters, 2.4.1.1
length of bound value, setting (batch), 3.1.5.5.5
length of bound value, setting (non-batch), 3.1.5.3.22
null value, setting (batch), 3.1.5.5.6
null value, setting (non-batch), 3.1.5.3.23
output and input/output parameters, 2.4.1.3
registering parameters, 2.4.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.21
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
compiling
applications, 1.2
applications on Linux/UNIX, 1.2.1
applications on Windows, 1.2.2
Connect method
description, 3.1.3.3.2
example, 2.2
XLA, 3.3.1.3.2
connection
autocommit, 3.1.3.3.10
confirm connection, 3.1.3.3.7
Connect method example, 2.2
connect (XLA), 3.3.1.3.2
connecting, 3.1.3.3.2
connecting and disconnecting, 2.3.2
connection class definition, 2.2
connection pools, 3.1.4
context value, 3.1.3.3.6
Disconnect method example, 2.2
disconnect (XLA), 3.3.1.3.4
disconnecting, 3.1.3.3.3
managing connections, 2.3
methods, 2.3.3
ODBC connection handle, 3.1.3.3.5
TTConnection class, 3.1.3
validity check, 3.1.2.4.1
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

D

data source names (DSNs), 2.3.1
deferred prepare, client/server, 3.1.5.3.17
del method (delete table handler from XLA table list), 3.3.4.3.2
deleteBookmarkAndDisconnect method, 3.3.1.3.3
demos--see sample applications
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
driver manager
restrictions, 1.2.3
Drop method (drop prepared statement), 3.1.5.3.2
DSNs (data source names), 2.3.1
duplicate parameter binding, 2.4.1.4
DuplicateBindMode general connection attribute, 2.4.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
Windows, 1.1.2
error reporting
throw error (not typical), 3.1.2.4.3
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
typical, 3.1.2.4.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

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.4.1.1
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 Linux/UNIX, 1.2.1
on Windows, 1.2.2
references to related information, 1.2
Linux
compiling and linking applications, 1.2.1
environment variables
Linux/UNIX, 1.1.1
LOBs
TimesTen support, 2.4.4
XLA support, 2.6
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.5

M

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
operator (as used in error reporting), 3.1.2.4.2
OUT and IN OUT parameters
getting output values, 3.1.5.3.13
registering, 2.4.1.2
output and input/output parameters
binding, 2.4.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
sample applications, 1.3
XLA sample, 2.6

R

REF CURSORs
getParam method for REF CURSORs, 3.1.5.3.13
using, 2.4.2
registerParam method, 2.4.1.2, 3.1.5.3.19
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.20
print value of a column of current row, 3.1.5.3.18
Rollback method, 3.1.3.3.8
rowids, ROWID type, 2.4.3

S

sample applications
overview, 1.3
XLA, 2.6
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.20
setParam method (bind parameter, non-batch), 3.1.5.3.21
setParamLength method
batch operations, 3.1.5.5.5
non-batch operations, 3.1.5.3.22
setParamNull method
batch operations, 3.1.5.5.6
non-batch operations, 3.1.5.3.23
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.24
setQueryTimeout method, 3.1.5.3.25
setTuple method (XLA row viewer), 3.3.2.3.8
size of batch, 3.1.5.5.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
timeouts and thresholds, 2.4.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
system catalog--see catalog

T

table class, catalog, 3.2.2
threshold, SQL statements, 2.4.5
throwError method, 3.1.2.4.3
timeout, SQL statements, 2.4.5
transaction
acknowledge XLA updates at transaction boundaries, 2.6.2
acknowledge XLA updates without transaction boundaries, 2.6.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.6
rolling back, 3.1.3.3.8
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
TTError class, 3.1.2.2.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
compiling and linking applications, 1.2.1
environment variables, 1.1.1
updatedCol method (XLA row viewer), 3.3.2.3.9

W

Windows
compiling and linking applications, 1.2.2
environment variables, 1.1.2

X

XLA
access control, 2.6.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.6
classes to use XLA, 3.3
column class, 3.3.6
connect, 3.3.1.3.2
connection, create, 3.3.1
delete bookmark, 3.3.1.3.3
disconnect, 3.3.1.3.4
fetch records, 3.3.1.3.5
LOB support, 2.6
row viewer class, 3.3.2
sample applications, 2.6
table class, 3.3.5
table handler class, 3.3.3
table list class, 3.3.4
updates, acknowledging at transaction boundaries, 2.6.2
updates, acknowledging without transaction boundaries, 2.6.1