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

  • BYTE data type A

C

  • case1.sql 3.3
  • Case rules 2.7.2.3
  • Case studies 3
  • character sets
    • Heterogeneous Services D.7.1
  • CHAR data type A
  • COMMIT
  • Commit point site 2.8.2
  • Comparison operators B.2.2.2
  • CONNECT BY clause 2.8.6.2
  • CREATE statement B.1
  • Cursor loops

D

  • Data definition language B.1
  • Data dictionary
  • Data type
    • BYTE A
    • CHAR A
    • conversion 2.7.3.2
    • DATETIME A
    • DECIMAL A
    • FLOAT A
    • INTEGER A
    • LONG A
    • LONG RAW A
    • MONEY A
    • NCHAR A
    • NVARCHAR A
    • SERIAL A
    • SMALLFLOAT A
    • TEXT A
    • VARCHAR A
    • VARCHAR2 A
  • Date functions B.2.2.6
  • DATETIME data type A
  • DECIMAL data type A
  • DELETE statement 3.9.1, B.1.1, B.2.1
  • Demo 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

  • Encrypted format login 2.9.1
  • Error messages
    • error tracing D.20
  • Errors

F

  • fetch array size, with HS_FDS_FETCH_ROWS D.23
  • 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.7.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_FETCH_ROWS parameter D.23
  • HS_FDS_TRACE_LEVEL initialization parameter D.20
    • enabling agent tracing D.1
  • HS_FDS_TRANSACTION_ISOLATIONparameter D.21
  • HS_FDS_TRANSACTION_LOG initialization parameter D.22
  • HS_IDLE_TIMEOUT initialization parameter D.24
  • HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter D.26
  • HS_LANGUAGE initialization parameter D.7
  • HS_LONG_PIECE_TRANSFER_SIZE initialization parameter D.8
  • HS_NLS_LENGTH_SEMANTICS initialization parameter D.25
  • 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.21

K

  • Known restrictions 2.8

L

  • Locking, database 2.7.5
  • LONG data type A
  • LONG RAW data type A

M

  • MONEY data type A

N

  • NCHAR data type A
  • NVARCHAR data type A

O

P

  • parameters
    • gateway initialization file
      • HS_FDS_FETCH_ROWS D.23
      • HS_FDS_TRANSACTION_ISOLATION D.21
  • Passing commands to database 2.8.4
  • Pass-Through Feature 3.11
  • Pattern matching B.2.2.5
  • PL/SQL 2.9.3, 2.9.4

R

S

T

  • TEXT data type A
  • TO_DATE function B.2.3
  • transactional capability 2.8.2
  • transactional integrity 2.8.1
  • TRUNCATE statement B.1
  • Two-phase commit 2.8.2

U

V

  • VARCHAR2 data type A
  • VARCHAR data type A

W