CONTENTS

  Title Page

  Copyright Page

  Send Us Your Comments

  Preface

  1      Fixed Problems
    1.1 SQL Messages Exactly 1024 Bytes Long
    1.2 Columns of Type BIGINT

  2      Known Problems, Solutions, and Restrictions
    2.1 Changes to Documentation
      2.1.1      Installation Instructions
    2.2 Using the Gateway for SYBASE with Older Versions of SQL
    2.3 New or Changed Features
      2.3.1      Support for UPDATE STATISTICS Clause
    2.4 Data Definition Language Data Type Considerations
      2.4.1      Support for SYBASE Decimal/Numeric Data Type
    2.5 Known Problems and Restrictions
      2.5.1      Use of LIKE, STARTING WITH, and CONTAINING Operators
        2.5.1.1      Use of the CONTAINING Operator
        2.5.1.2      The SYBASE SQL Server and Case Sensitivity
      2.5.2      Unexpected Results with CHAR Data Type Columns
      2.5.3      Database Key Restrictions
        2.5.3.1      Data Type Restrictions with Dbkeys
        2.5.3.2      System 10 Data Type Restrictions with Dbkeys
        2.5.3.3      Using Dbkeys as Input Parameters
      2.5.4      Searched UPDATE and DELETE Statements and Dbkey Modes
      2.5.5      Platform Specific Restrictions When Retrieving Data of the REAL Data Type
      2.5.6      VARCHAR Input Parameters Used as Input Argument
      2.5.7      ORDER BY Clause May Cause Results Not to Be Ordered as Expected
      2.5.8      Out of Range Error Loses Sign in Message
      2.5.9      Assignments to Date Columns
      2.5.10     UCX for TCP/IP Connection Between SYBASE Client and Server
      2.5.11     SYBASE Automatically Rolls Back Some Transactions on Error Conditions
      2.5.12     Miscellaneous SYBASE Problems
        2.5.12.1     SYBASE Master Log Full
        2.5.12.2     Inserting Data Values
      2.5.13     Use of LIKE . . . IGNORE CASE
      2.5.14     Use of SET QUERY LIMIT CPU option
      2.5.15     Case-Sensitivity Problems Using DEC Data Distributor (DDD) V6.0
      2.5.16     No Segmented String Support