1. Index

Index

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

A

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

B

  • BYTE data type A
  • BYTEINT data type A

C

  • Case rules 2.8.2.2
  • Case studies 3
  • character sets
    • Heterogeneous Services D.7.1
  • CHAR data type A
  • COMMIT
  • Commit point site 2.9.2
  • Comparison operators B.2.2.2
  • CONNECT BY clause 2.9.6.2
  • COPY command 2.9.7
  • CREATE statement B.1
  • Cursor loops

D

  • Data definition language B.1
  • Data dictionary
  • Data type
    • BYTE A
    • BYTEINT A
    • CHAR A
    • conversion 2.8.3.2
    • DATE A
    • DECIMAL A
    • FLOAT A
    • INTEGER A
    • LONG A
    • LONG VARCHAR A
    • RAW A
    • SMALLINT A
    • TIME A
    • TIMESTAMP A
    • VARBYTE A
    • VARCHAR A
    • VARCHAR2 A
  • DATE data type A
  • DDL statement 2.9.4
  • DECIMAL data type A
  • DELETE statement 3.9.1, B.1.1, B.2.1
  • demonstration build SQL script 3.3
  • Demonstration files 3.3
  • Demonstration tables 3.5
  • Demonstration tables build SQL script 3.5
  • describe cache high water mark
    • definition D.6
  • DROP statement B.1

E

  • Error messages
    • error tracing D.23
  • Errors

F

  • fetch array size, with HS_FDS_FETCH_ROWS D.25
  • FLOAT data type A

G

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

H

  • Heterogeneous Services
    • defining maximum number of open cursors D.9
    • optimizing data transfer D.10
    • setting global name D.5
    • specifying cache high water mark D.6
    • tuning internal data buffering D.11
    • tuning LONG data transfer D.8
  • Hexadecimal notation 2.8.3.1
  • HS_DB_NAME initialization parameter D.5
  • HS_DESCRIBE_CACHE_HWM initialization parameter D.6
  • HS_FDS_CONNECT_INFO D.17
  • HS_FDS_DEFAULT_OWNER initialization parameter D.18
  • HS_FDS_FETCH_ROWS parameter D.25
  • HS_FDS_PROC_IS_FUNC initialization parameter D.20
  • HS_FDS_TRACE_LEVEL initialization parameter D.23
    • enabling agent tracing D.1
  • HS_FDS_TRANSACTION_ISOLATIONparameter D.19
  • HS_FDS_TRANSACTION_LOG initialization parameter D.24
  • HS_IDLE_TIMEOUT D.26
  • HS_KEEP_REMOTE_COLUMN_SIZE D.28
  • HS_LANGUAGE initialization parameter D.7
  • HS_LONG_PIECE_TRANSFER_SIZE initialization parameter D.8
  • HS_NLS_LENGTH_SEMANTICS D.27
  • HS_OPEN_CURSORS initialization parameter D.9
  • HS_RPC_FETCH_REBLOCKING initialization parameter D.10
  • HS_RPC_FETCH_SIZE initialization parameter D.11
  • HS_TIME_ZONE initialization parameter D.12

I

  • IFILE initialization parameter D.14
  • Initialization parameter file
    • customizing D
  • INSERT statement 3.9.3, B.1.2, B.2.1
  • INTEGER data type A
  • isolation level, HS_FDS_TRANSACTION_ISOLATION D.19

K

  • Known restrictions 2.9

L

  • Locking, database 2.8.5
  • LONG data type A
  • LONG VARCHAR data type A

N

  • NVL function 3.7

O

P

  • parameters
    • gateway initialization file
      • HS_FDS_FETCH_ROWS D.25
      • HS_FDS_TRANSACTION_ISOLATION D.19
  • Passing commands to database 2.9.4
  • Pass-Through Feature 3.11
  • PL/SQL 2.10.2, 2.10.3

R

  • RAW data type A
  • remote
    • DRDA database, HS_FDS_TRANSACTION_ISOLATION D.19
  • ROLLBACK
  • ROWID 2.9.6.1, 2.9.6.3

S

  • savepoint support 2.9.2
  • SELECT statement 3.11.2, B.1.3, C.2
  • SMALLINT data type A
  • SQL
    • statements, HS_FDS_TRANSACTION_ISOLATION D.19
  • String functions B.2.2.4
  • SUM function 3.7

T

  • TIME data type A
  • TIMESTAMP data type A
  • transactional capability 2.9.2
  • transactional integrity 2.9.1
  • TRUNCATE statement B.1
  • Two-phase commit 2.9.2

U

V

  • VARBYTE data type A
  • VARCHAR2 data type A
  • VARCHAR data type A

W