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

  • BIGINT data type A
  • BINARY data type A
  • BIT data type A

C

D

  • Data definition language B.1
  • Data dictionary
  • Data type
    • BIGINT A
    • BINARY A
    • BIT A
    • CHAR A
    • conversion 2.9.4.3
    • DATE A
    • DATETIME A
    • DECIMAL A
    • FLOAT A
    • IMAGE A
    • LONG RAW A
    • MONEY A
    • NCHAR A
    • NUMBER A
    • NUMERIC A
    • NVARCHAR A
    • RAW A
    • REAL A
    • SMALL DATETIME A
    • SMALLINT A
    • SMALL MONEY A
    • TIMESTAMP A
    • TINYINT A
    • VARBINARY 2.11.1, A
    • VARCHAR A
  • DATE data type A
  • DATETIME data type A
  • DECIMAL data type A
  • DELETE statement 3.8.1, B.1.1, B.2.1
  • demonstration build SQL script 3.2
  • Demonstration files 3.2
  • Demonstration tables 3.4
  • Demonstration tables build SQL script 3.4
  • describe cache high water mark
    • definition D.6
  • DROP statement B.1

E

  • Encrypted format login 2.11.1
  • Error messages
    • error tracing D.23
  • Errors
  • Executing Stored Procedures 3.11

F

  • fetch array size, with HS_FDS_FETCH_ROWS D.12
  • FLOAT data type A
  • Functions in SQL 2.3

G

  • Gateway
    • case studies 3
    • data dictionary tables C.1
    • pass-through feature 2.2, 2.10.7
    • supported functions B
    • supported SQL syntax B.1
  • globalization support
    • Heterogeneous Services D.31
  • GRANT statement B.1
  • Group functions B.2.2.4

H

  • Heterogeneous Services
    • defining maximum number of open cursors D.34
    • optimizing data transfer D.35
    • setting global name D.5
    • specifying cache high water mark D.6
    • tuning internal data buffering D.36
    • tuning LONG data transfer D.32
  • Hexadecimal notation 2.9.4.1
  • HS_CALL_NAME initialization parameter D.2
  • HS_DB_NAME initialization parameter D.5
  • HS_DESCRIBE_CACHE_HWM initialization parameter D.6
  • HS_FDS_CONNECT_INFO D.9
  • HS_FDS_FETCH_ROWS parameter D.12
  • HS_FDS_PROC_IS_FUNC initialization parameter D.13
  • HS_FDS_RECOVERY_PWD initialization parameter D.17
  • HS_FDS_RESULTSET_SUPPORT initialization parameter D.18
  • HS_FDS_TRACE_LEVEL initialization parameter D.23
    • enabling agent tracing D.1
  • HS_FDS_TRANSACTION_ISOLATIONparameter D.24
  • HS_FDS_TRANSACTION_LOG initialization parameter D.25
  • HS_IDLE_TIMEOUT initialization parameter D.29
  • HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter D.30
  • HS_LANGUAGE initialization parameter D.31
  • HS_LONG_PIECE_TRANSFER_SIZE initialization parameter D.32
  • HS_NLS_LENGTH_SEMANTICS initialization parameter D.33
  • HS_OPEN_CURSORS initialization parameter D.34
  • HS_RPC_FETCH_REBLOCKING initialization parameter D.35
  • HS_RPC_FETCH_SIZE initialization parameter D.36
  • HS_TIME_ZONE initialization parameter D.37

I

  • IFILE initialization parameter D.39
  • IMAGE data type A
  • Initialization parameter file
    • customizing D
  • INSERT statement 3.8.3, B.1.2, B.2.1
  • isolation level, HS_FDS_TRANSACTION_ISOLATION D.24

K

  • Known restrictions 2.10

L

  • Locking, database 2.9.6
  • LONG RAW data type A

M

  • MONEY data type A

N

  • NCHAR data type A
  • NULL values 2.9.2
  • NUMBER data type A
  • NUMERIC data type A
  • NVARCHAR data type A
  • NVL function 3.6

O

P

  • parameters
    • gateway initialization file
      • HS_FDS_FETCH_ROWS D.12
      • HS_FDS_TRANSACTION_ISOLATION D.24
  • Passing commands to database 2.10.6
  • Pass-Through Feature 3.10
  • Pattern Matching B.2.2.3
  • PL/SQL 2.11.5, 2.11.6

R

  • RAW data type A
  • REAL data type A
  • remote
    • HS_FDS_TRANSACTION_ISOLATION D.24
  • remote functions
    • referenced in SQL statements D.2
  • ROLLBACK
  • ROWID 2.10.8.1, 2.10.8.6

S

  • savepoint support 2.10.3
  • SELECT statement 3.10.2, B.1.3, C.1.2
  • SMALL DATETIME data type A
  • SMALLINT data type A
  • SQL
    • statements, HS_FDS_TRANSACTION_ISOLATION D.24
  • Stored procedures 2.10.5, 2.11.7
    • running in chained mode 2.9.1
  • Stored procedures in SQL Server 2.3
  • String functions B.2.2.5
  • SUM function 3.6

T

  • TIMESTAMP data type A
  • TINYINT data type A
  • transactional capability 2.10.3
  • transactional integrity 2.10.2
  • Transaction modes 2.9.1
  • TRUNCATE statement B.1
  • Two-phase commit 2.10.3

U

V

  • VARBINARY data type 2.11.1, A
  • VARCHAR data type A

W