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

B

  • BIGINT data type 1
  • BINARY data type 1
  • BIT data type 1

C

  • Case rules 1
  • Case studies 1
  • Chained mode 1
  • character sets
    • Heterogeneous Services 1
  • CHAR data type 1
  • COMMIT
    • restrictions 1
  • Comparison operators 1
  • CONCAT operator 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
    • BIGINT 1
    • BINARY 1
    • BIT 1
    • CHAR 1
    • conversion 1
    • DATE 1
    • DATETIME 1
    • DECIMAL 1
    • FLOAT 1
    • IMAGE 1
    • LONG RAW 1
    • MONEY 1
    • NCHAR 1
    • NUMBER 1
    • NUMERIC 1
    • NVARCHAR 1
    • RAW 1
    • REAL 1
    • SMALL DATETIME 1
    • SMALLINT 1
    • SMALL MONEY 1
    • TIMESTAMP 1
    • TINYINT 1
    • VARBINARY 1, 2
    • VARCHAR 1
  • DATE data type 1
  • DATETIME data type 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

  • Encrypted format login 1
  • Error messages
    • error tracing 1
  • Errors
    • ORA-02070 1
  • Executing Stored Procedures 1

F

  • fetch array size, with HS_FDS_FETCH_ROWS 1
  • FLOAT data type 1
  • Functions in SQL 1

G

  • Gateway
    • case studies 1
    • data dictionary tables 1
    • pass-through feature 1, 2
    • 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_CALL_NAME initialization parameter 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_PROC_IS_FUNC initialization parameter 1
  • HS_FDS_RECOVERY_PWD initialization parameter 1
  • HS_FDS_RESULTSET_SUPPORT initialization 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
  • IMAGE data type 1
  • Initialization parameter file
    • customizing 1
  • INSERT statement 1, 2, 3
  • isolation level, HS_FDS_TRANSACTION_ISOLATION 1

K

  • Known restrictions 1

L

  • Locking, database 1
  • LONG RAW data type 1

M

  • MONEY data type 1

N

  • NCHAR data type 1
  • NULL values 1
  • NUMBER data type 1
  • NUMERIC data type 1
  • NVARCHAR data type 1
  • 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
  • Pattern Matching 1
  • PL/SQL 1, 2

R

  • RAW data type 1
  • REAL data type 1
  • remote
    • HS_FDS_TRANSACTION_ISOLATION 1
  • remote functions
    • referenced in SQL statements 1
  • ROLLBACK
    • restrictions 1
  • ROWID 1, 2

S

  • savepoint support 1
  • SELECT statement 1, 2, 3
  • SMALL DATETIME data type 1
  • SMALLINT data type 1
  • SQL
    • statements, HS_FDS_TRANSACTION_ISOLATION 1
  • Stored procedures 1, 2
    • running in chained mode 1
  • Stored procedures in SQL Server 1
  • String functions 1
  • SUM function 1

T

  • TIMESTAMP data type 1
  • TINYINT data type 1
  • transactional capability 1
  • transactional integrity 1
  • Transaction modes 1
  • TRUNCATE statement 1
  • Two-phase commit 1

U

  • UPDATE statement 1, 2, 3, 4, 5

V

  • VARBINARY data type 1, 2
  • VARCHAR data type 1

W

  • WHERE CURRENT OF clause 1