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 1
  • Arithmetic operators 1

B

  • BYTE data type 1

C

  • case1.sql 1
  • 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
  • CREATE statement 1
  • Cursor loops
    • restrictions 1

D

  • Data definition language 1
  • Data dictionary
    • views 1
  • Data type
    • BYTE 1
    • CHAR 1
    • conversion 1
    • DATETIME 1
    • DECIMAL 1
    • FLOAT 1
    • INTEGER 1
    • LONG 1
    • LONG RAW 1
    • MONEY 1
    • NCHAR 1
    • NVARCHAR 1
    • SERIAL 1
    • SMALLFLOAT 1
    • TEXT 1
    • VARCHAR 1
    • VARCHAR2 1
  • Date functions 1
  • DATETIME data type 1
  • DECIMAL data type 1
  • DELETE statement 1, 2, 3
    • restrictions on use 1
  • Demo 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

  • Encrypted format login 1
  • 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_FETCH_ROWS parameter 1
  • HS_FDS_TRACE_LEVEL initialization parameter 1
    • enabling agent tracing 1
  • HS_FDS_TRANSACTION_ISOLATIONparameter 1
  • HS_FDS_TRANSACTION_LOG initialization parameter 1
  • HS_IDLE_TIMEOUT initialization parameter 1
  • HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter 1
  • HS_LANGUAGE initialization parameter 1
  • HS_LONG_PIECE_TRANSFER_SIZE initialization parameter 1
  • HS_NLS_LENGTH_SEMANTICS initialization parameter 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
    • restrictions on use 1, 2
  • INTEGER data type 1
  • isolation level, HS_FDS_TRANSACTION_ISOLATION 1

K

  • Known restrictions 1

L

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

M

  • MONEY data type 1

N

  • NCHAR data type 1
  • NVARCHAR data type 1

O

  • Objects
    • valid characters 1
  • Objects, naming rules 1
  • ORA-02070 1
  • Oracle functions
    • TO_DATE 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
  • Pattern matching 1
  • PL/SQL 1, 2

R

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

S

  • savepoint support 1
  • SELECT statement 1, 2, 3
    • use of NULL keyword 1
  • SERIAL data type 1
  • Set operations 1
  • SMALLFLOAT data type 1, 2
  • SQL
    • statements, HS_FDS_TRANSACTION_ISOLATION 1
  • Stored procedures 1
  • String functions 1
  • SUM function 1

T

  • TEXT data type 1
  • TO_DATE function 1
  • transactional capability 1
  • transactional integrity 1
  • TRUNCATE statement 1
  • Two-phase commit 1

U

  • UPDATE statement 1, 2, 3, 4
    • restrictions on use 1

V

  • VARCHAR2 data type 1
  • VARCHAR data type 1

W

  • WHERE CURRENT OF clause 1