Index

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

A

  • ALTER statement 1
  • Arithmetic operators 1

B

  • BYTE data type 1
  • BYTEINT data type 1

C

  • Case rules 1
  • Case studies 1
  • character sets
    • Heterogeneous Services 1
  • CHAR data type 1
  • COMMIT
    • restrictions 1
  • Commit point site 1
  • Comparison operators 1
  • CONNECT BY clause 1
  • COPY command 1
  • CREATE statement 1
  • Cursor loops
    • restrictions 1

D

  • Data definition language 1
  • Data dictionary
    • views 1
  • Data type
    • BYTE 1
    • BYTEINT 1
    • CHAR 1
    • conversion 1
    • DATE 1
    • DECIMAL 1
    • FLOAT 1
    • INTEGER 1
    • LONG 1
    • LONG VARCHAR 1
    • RAW 1
    • SMALLINT 1
    • TIME 1
    • TIMESTAMP 1
    • VARBYTE 1
    • VARCHAR 1
    • VARCHAR2 1
  • DATE data type 1
  • DDL statement 1
  • DECIMAL data type 1
  • DELETE statement 1 , 2 , 3
  • demonstration build SQL script 1
  • Demonstration files 1
  • Demonstration tables 1
  • Demonstration tables build SQL script 1
  • describe cache high water mark
    • definition 1
  • DROP statement 1

E

  • Error messages
    • error tracing 1
  • Errors
    • ORA-02070 1

F

  • fetch array size, with HS_FDS_FETCH_ROWS 1
  • FLOAT data type 1

G

  • Gateway
    • case studies 1
    • pass-through feature 1
    • supported functions 1
    • supported SQL syntax 1
  • globalization support
    • Heterogeneous Services 1
  • GRANT statement 1
  • Group functions 1

H

  • Heterogeneous Services
    • defining maximum number of open cursors 1
    • optimizing data transfer 1
    • setting global name 1
    • specifying cache high water mark 1
    • tuning internal data buffering 1
    • tuning LONG data transfer 1
  • Hexadecimal notation 1
  • HS_DB_NAME initialization parameter 1
  • HS_DESCRIBE_CACHE_HWM initialization parameter 1
  • HS_FDS_CONNECT_INFO 1
  • HS_FDS_DEFAULT_OWNER initialization parameter 1
  • HS_FDS_FETCH_ROWS parameter 1
  • HS_FDS_PROC_IS_FUNC initialization parameter 1
  • HS_FDS_TRACE_LEVEL initialization parameter
    • enabling agent tracing 1
  • HS_FDS_TRANSACTION_ISOLATIONparameter 1
  • HS_FDS_TRANSACTION_LOG initialization parameter 1
  • HS_IDLE_TIMEOUT 1
  • HS_KEEP_REMOTE_COLUMN_SIZE 1
  • HS_LANGUAGE initialization parameter 1
  • HS_LONG_PIECE_TRANSFER_SIZE initialization parameter 1
  • HS_NLS_LENGTH_SEMANTICS 1
  • HS_OPEN_CURSORS initialization parameter 1
  • HS_RPC_FETCH_REBLOCKING initialization parameter 1
  • HS_RPC_FETCH_SIZE initialization parameter 1
  • HS_TIME_ZONE initialization parameter 1

I

  • IFILE initialization parameter 1
  • Initialization parameter file
    • customizing 1
  • INSERT statement 1 , 2 , 3
  • INTEGER data type 1
  • isolation level, HS_FDS_TRANSACTION_ISOLATION 1

K

  • Known restrictions 1

L

  • Locking, database 1
  • LONG data type 1
  • LONG VARCHAR data type 1

N

  • NVL function 1

O

  • Objects, naming rules 1
  • ORA-02070 1

P

  • parameters
    • gateway initialization file
      • HS_FDS_FETCH_ROWS 1
      • HS_FDS_TRANSACTION_ISOLATION 1
  • Passing commands to database 1
  • Pass-Through Feature 1
  • PL/SQL 1 , 2

R

  • RAW data type 1
  • remote
    • DRDA database, HS_FDS_TRANSACTION_ISOLATION 1
  • ROLLBACK
    • restrictions 1
  • ROWID 1 , 2

S

  • savepoint support 1
  • SELECT statement 1 , 2 , 3
  • SMALLINT data type 1
  • SQL
    • statements, HS_FDS_TRANSACTION_ISOLATION 1
  • String functions 1
  • SUM function 1

T

  • TIME data type 1
  • TIMESTAMP data type 1
  • transactional capability 1
  • transactional integrity 1
  • TRUNCATE statement 1
  • Two-phase commit 1

U

  • UPDATE statement 1 , 2 , 3

V

  • VARBYTE data type 1
  • VARCHAR2 data type 1
  • VARCHAR data type 1

W

  • WHERE CURRENT OF clause 1