1. Index

Index

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

A

  • ALTER statement B.1
  • Arithmetic operators B.2.2.1

B

  • BINARY data type A
  • BIT data type A

C

  • Case rules 2.8.3.2
  • Case studies 3
  • Chained mode 2.8.1
  • character sets
    • Heterogeneous Services D.32.1
  • CHAR data type A
  • COMMIT
  • Commit point site 2.9.2
  • Comparison operators B.2.2.2
  • CONCAT operator 2.10.4
  • CONNECT BY clause 2.9.7.2
  • COPY command 2.9.8
  • CREATE statement B.1
  • Cursor loops

D

  • Data definition language B.1
  • Data dictionary
  • Data type
    • BINARY A
    • BIT A
    • CHAR A
    • conversion 2.8.4.2
    • DATE A
    • DATETIME A
    • DECIMAL A
    • FLOAT A
    • IMAGE A
    • INTEGER A
    • LONG A
    • MONEY A
    • NUMERIC A
    • RAW A
    • REAL A
    • SMALL DATETIME A
    • SMALLINT A
    • SMALL MONEY A
    • TEXT A
    • TINYINT A
    • VARBINARY 2.10.1, A
    • VARCHAR A
    • VARCHAR2 A
  • DATE data type A
  • DATETIME data type A
  • DDL statement 2.9.5
  • DECIMAL data type A
  • DELETE statement 3.8.1, B.1.1, B.2.1
  • demonstration build SQL script 3.2
  • Demonstration files 3.2
  • Demonstration tables 3.4
  • Demonstration tables build SQL script 3.4
  • describe cache high water mark
    • definition D.6
  • DROP statement B.1

E

  • Encrypted format login 2.10.1
  • Error messages
    • error tracing D.24
  • Errors
  • Executing Stored Procedures 3.11

F

  • fetch array size, with HS_FDS_FETCH_ROWS D.12
  • FLOAT data type A
  • Functions in SQL 2.3

G

  • Gateway
    • case studies 3
    • data dictionary tables C
    • pass-through feature 2.2
    • supported functions B
    • supported SQL syntax B.1
  • globalization support
    • Heterogeneous Services D.32
  • GRANT statement B.1
  • Group functions B.2.2.3

H

  • Heterogeneous Services
    • defining maximum number of open cursors D.35
    • optimizing data transfer D.36
    • setting global name D.5
    • specifying cache high water mark D.6
    • tuning internal data buffering D.37
    • tuning LONG data transfer D.33
  • Hexadecimal notation 2.8.4.1
  • HS_CALL_NAME initialization parameter D.2
  • HS_DB_NAME initialization parameter D.5
  • HS_DESCRIBE_CACHE_HWM initialization parameter D.6
  • HS_FDS_CONNECT_INFO D.9
  • HS_FDS_FETCH_ROWS parameter D.12
  • HS_FDS_PROC_IS_FUNC initialization parameter D.13
  • HS_FDS_RECOVERY_PWD initialization parameter D.18
  • HS_FDS_RESULTSET_SUPPORT initialization parameter D.19
  • HS_FDS_TRACE_LEVEL initialization parameter D.24
    • enabling agent tracing D.1
  • HS_FDS_TRANSACTION_ISOLATIONparameter D.25
  • HS_FDS_TRANSACTION_LOG initialization parameter D.26
  • HS_IDLE_TIMEOUT initialization parameter D.30
  • HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter D.31
  • HS_LANGUAGE initialization parameter D.32
  • HS_LONG_PIECE_TRANSFER_SIZE initialization parameter D.33
  • HS_NLS_LENGTH_SEMANTICS initialization parameter D.34
  • HS_OPEN_CURSORS initialization parameter D.35
  • HS_RPC_FETCH_REBLOCKING initialization parameter D.36
  • HS_RPC_FETCH_SIZE initialization parameter D.37
  • HS_TIME_ZONE initialization parameter D.38

I

  • IFILE initialization parameter D.40
  • IMAGE data type A
  • Initialization parameter file
    • customizing D
  • INSERT statement 2.9.7.4, 3.8.3, B.1.2, B.2.1
  • INTEGER data type A
  • isolation level, HS_FDS_TRANSACTION_ISOLATION D.25

K

  • Known restrictions 2.9

L

  • Locking, database 2.8.6
  • LONG data type A

M

  • MONEY data type A

N

  • NULL values 2.8.2
  • NUMERIC data type A

O

P

  • parameters
    • gateway initialization file
      • HS_FDS_FETCH_ROWS D.12
      • HS_FDS_TRANSACTION_ISOLATION D.25
  • Passing commands to database 2.9.5
  • Pass-through feature 2.9.5
  • Pass-Through Feature 3.10
  • PL/SQL 2.10.5, 2.10.6

R

  • RAW data type A
  • REAL data type A
  • remote
    • HS_FDS_TRANSACTION_ISOLATION D.25
  • remote functions
    • referenced in SQL statements D.2
  • ROLLBACK
  • ROWID 2.9.7.1, 2.9.7.3

S

  • savepoint support 2.9.2
  • SELECT statement 3.10.2, B.1.3, C.2
  • SMALL DATETIME data type A
  • SMALLINT data type A
  • SQL
    • statements, HS_FDS_TRANSACTION_ISOLATION D.25
  • Stored procedures 2.9.4, 2.10.7
    • running in chained mode 2.8.1
  • Stored procedures in SQL Server 2.3
  • String functions B.2.2.4
  • SUM function 3.6

T

  • TEXT data type A
  • TINYINT data type A
  • transactional capability 2.9.2
  • transactional integrity 2.9.1
  • Transaction modes 2.8.1
  • TRUNCATE statement B.1
  • Two-phase commit 2.9.2

U

V

  • VARBINARY data type 2.10.1, A
  • VARCHAR2 data type A
  • VARCHAR data type A

W