Oracle Transparent Gateway Sybase Administrator's Guide Release 8.1.6 for Windows NT Part Number A80982-01 |
| Library | Contents

# Index

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

## Symbols

  ||, 1-17

## A

  ALTER statement, A-2
  Arithmetic operators, A-4

## B

  BINARY data type, 5-4
  BIT data type, 5-4

## C

  Case rules, 1-6
  Case studies, 6-1
  CD-ROM drive requirements, 1-3
  Chained mode, 1-5
  CHAR data type, 5-4
  COMMIT
    restrictions, 1-11
  Commit point site, 1-11, 5-8
  Comparison operators, A-4
  CONCAT operator, 1-17
  Configuring
    two-phase commit, 4-8
  Configuring the gateway, 4-2
  CONNECT BY clause, 1-12
  COPY command, 1-13
  Copying data
    COPY command, 5-9
    from Oracle database server to SQL Server, 5-9
    from SQL Server to Oracle database server, 5-10
    INSERT statement, 5-10
  CREATE statement, A-2
  CREATE TABLE command, 5-10
  Creating
    transaction log table, 4-9
  Cursor loops
    restrictions, 1-11

## D

  Data definition language, A-2
  Data dictionary
    views, B-3
  Data type
    BINARY, 5-4
    BIT, 5-4
    CHAR, 5-4
    conversion, 1-8
    DATE, 5-4
    DATETIME, 5-4
    DECIMAL, 5-4
    DOUBLE PRECISION, 5-4
    FLOAT, 5-4
      FLOAT data type, 1-15
    IMAGE, 5-4
    INTEGER, 5-4
    LONG, 5-4
    LONG RAW, 5-4
    MONEY, 5-4
    NCHAR, 5-4
    NUMBER, 5-4
    NUMERIC, 5-4
    NVARCHAR, 5-4
    RAW, 5-4
    REAL, 5-4
    SMALL DATETIME, 5-4
    SMALL MONEY, 5-4
    SMALLINT, 5-4
    TEXT, 5-4
    TINYINT, 5-4
    VARBINARY, 1-15, 5-4
    VARCHAR, 5-4
    VARCHAR2, 5-4
  Database link
    behavior, 4-10
  DATE data type, 5-4
  DATETIME data type, 5-4
  DDL statement, 1-11
  DECIMAL data type, 5-4
  DELETE statement, 6-9, A-2, A-3
  Demo build SQL script, 6-2
  Demonstration files, 6-2
  Demonstration tables, 6-3
  Demonstration tables build SQL script, 6-3
  Disk space requirements, 1-3
  Distributed queries, 5-7
  DOUBLE PRECISION data type, 5-4
  DROP statement, A-2

## E

  Encrypted format login, 1-15
  Error message conventions, 7-6
  Error messages
    error tracing, C-5
    ORA-12203, 7-4
    ORA-12500, 7-5
    Trace output, 7-9
  Errors
    ORA-02070, 1-11

## F

  FLOAT data type, 5-4
  Functions in SQL, 5-6

## G

  Gateway
    case studies, 6-1
    components, 2-3
    data dictionary tables, B-2
    default SID, 4-2
    distributed query, 5-7
    error messages, 7-7
    how it works, 2-5
    installing, 3-1
    pass-through feature, 5-5
    remote data access, 2-7
    supported functions, A-1
    supported SQL syntax, A-2
    system identifier (SID), 4-2
    two-phase commit, 2-8, 4-8, 5-8
  GRANT statement, A-2
  Group functions, A-5

## H

  Hardware requirements, 1-3
  Hexadecimal notation, 1-7
  HS_COMMIT_POINT_STRENGTH setting, 5-8
  HS_FDS_CONNECT_INFO initialization parameter, C-3
  HS_FDS_DEFAULT_OWNER initialization parameter, 4-10, C-4
  HS_FDS_PROC_IS_FUNC initialization parameter, C-4
  HS_FDS_RECOVERY_ACCOUNT initialization parameter, C-4
  HS_FDS_RECOVERY_PWD initialization parameter, C-5
  HS_FDS_TRACE_LEVEL initialization parameter, C-5
  HS_FDS_TRANSACTION_MODEL initialization parameter, C-6
  HS_TRANSACTION_LOG, 4-9
  HS_TRANSACTION_LOG table, 5-8

## I

  IMAGE data type, 5-4
  Informix software requirements, 1-4
  Initialization parameter file
    customizing, 4-2
  initsid.ora file, 4-2
  INSERT statement, 1-13, 6-11, A-2, A-3
  Installing the gateway, 3-1 to 3-7
  INTEGER data type, 5-4

## K

  Known restrictions, 1-9

## L

  listener.ora file, 4-13
    example, 4-4
    location, 4-3
  Locking, database, 1-9
  LONG data type, 5-4
  LONG RAW data type, 5-4

## M

  Memory requirements, 1-3
  MONEY data type, 5-4

## N

  NCHAR data type, 5-4
  Net8
    configuration problems, 7-3
    configuring, 4-3
    requirements, 1-4
  NLS
    about, 1-14
  NULL values, 1-5
  NUMBER data type, 5-4
  NUMERIC data type, 5-4
  NVARCHAR data type, 5-4
  NVL function, 6-7

## O

  Objects, naming rules, 1-6
  Operating system requirements, 1-3
  ORA-02070, 1-11
  ORA-12154, 7-3
  ORA-12203, 7-4
  ORA-12500, 7-5
  Oracle database server
    description, 2-4
    error messages, 7-7
    requirements, 1-3
    SQL construct processing, 5-3

## P

  Passing commands to database, 1-11
  Pass-through feature, 1-11
  PL/SQL, 1-17
  Processor requirements, 1-3
  Product set for Informix gateway, 1-2

## R

  RAW data type, 5-4
  REAL data type, 5-4
  RECOVERY_ACCOUNT
    account username, 4-8
    creating a recovery account, 4-8
  Retrieving data from SQL Server, 5-2
  ROLLBACK
    restrictions, 1-11
  ROWID, 1-12, 1-13

## S

  savepoint support, 1-11
  SELECT statement, 5-2, A-2, B-2
  SID, 4-2
  SMALL DATETIME data type, 5-4
  SMALLINT data type, 5-4
  Software requirements, 1-3
  Specifying an Owner, 4-10
  Stored procedures, 1-17
    running in chained mode, 1-5
  Stored procedures in SQL Server, 5-6
  String functions, A-4
  SUM function, 6-7
  Synonyms, 5-5

## T

  TEXT data type, 5-4
  TINYINT data type, 5-4
  TNS listener
    configuring for gateway, 4-3
    starting, 4-5
  Trace output, 7-9
  Transaction log table
    creating, 4-9
  Transaction modes, 1-5
  transactional capability, 1-11
  transactional integrity, 1-10
  Troubleshooting
    Net8 configuration problems, 7-3
  TRUNCATE statement, A-2
  Two-phase commit, 1-11, 2-8, 5-8
    configuration, 4-8
    transaction log table, 4-9

## U

  UPDATE statement, 1-12, 5-3, 6-10, 6-13, 6-14, A-3
  Updating SQL Server data, 5-3

## V

  VARBINARY data type, 1-15, 5-4
  VARCHAR data type, 5-4
  VARCHAR2 data type, 5-4

## W

  WHERE CURRENT OF clause, 1-12

| Copyright © 2001 Oracle Corporation. All Rights Reserved. |
| Library | Contents