Welcome to Rapid SQL® XE 2 and Rapid SQL® 8.0.2

Rapid SQL Home | Rapid SQL Documentation | Embarcadero Technical Support | www.embarcadero.com

ReadMe Last Published: Dec. 14, 2011. Any updates to these notes will be available at http://docs.embarcadero.com.


Thank you for using Embarcadero Rapid SQL, the integrated development environment for IBM DB2 UDB for Open Systems, IBM DB2 UDB for OS/390 and z/OS, Microsoft SQL Server, MySQL, Oracle, and Sybase Adaptive Server database systems. Rapid SQL is your fast path to higher productivity whether you're programming in SQL, PL/SQL, Transact-SQL, HTML or Java. Before you use Rapid SQL, please read the information below.


What's New in Version XE 2/8.0

Unicode Updates

Datasource/Server Updates

Updated support for Oracle features

Updated support for Microsoft SQL Server features

Updated support for Sybase features

User interface improvements

Release Notes

DBMS Support

DBMS Versions No Longer Supported

Important Advisory Notes

Known Issues

Bug Fixes

Additional Resources

Licensing Your Embarcadero Product

Embarcadero Technologies Product Support

Embarcadero Technologies Technical Support

Embarcadero Technologies on the Web

What's New in Version XE 2/8.0

Unicode Updates

Unicode character-handling has been improved in the ISQL Editor and Data Editor. This includes:

Datasource/Server Updates

Updates in the category include:

Updated support for IBM DB2 for Linux, Unix, and Windows features

Updated support for Microsoft SQL Server features

SQL Server currency updates for this release include:

Updated support for Oracle features

Oracle currency updates for this release include:

Updated support for Sybase features

Sybase currency updates for this release include:

User interface improvements

This release continues the reworking of object editors and wizards. Aimed at improving workflow and the user interface experience, the new editors and wizards are being reworked for consistency. The following object editors/wizards were upgraded for this release:

Release Notes

DBMS SUPPORT

IBM DB2 for z/OS

Server: IBM DB2 UDB for z/OS v8 and v9

Client: When going through a DB2 Connect gateway, DB2 UDB Client for Windows 6.0 or later. When going directly to the mainframe from the client, DB2 Connect Personal Edition v6 or higher on the client machine.

IBM DB2 for LUW

Server: IBM DB2 LUW Versions 8.0 - 9.7

Client: IBM DB2 LUW Client for Windows 7.0 or later. When using a v8 client, DBArtisan only supports connecting to a v8 Database on Windows, Linux and Unix.

InterBase/Firebird

Server: InterBase 2007 and InterBase 2009, Firebird 2.0

Client: DataDirect ODBC driver for InterBase and the InterBase Client

Microsoft SQL Server

Server: Microsoft SQL Server 2000, 2005, (All editions including 2000 SDE and 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64) and 2008.

Client: Microsoft SQL Server Client Library

MySQL

Server: 4.x

Client: MySQL ODBC driver 3.5.1 - 4.x.

Oracle

Server: Oracle 8i, 9i, 10g, and 11g.

Client: Oracle SQL*Net Client

Sybase ASE

Server: Sybase ASE 12.5 - 15.0.3

Client: Sybase Open Client

DBMS VERSIONS NO LONGER SUPPORTED

All DBMS versions supported in the previous release are supported for this release.

IMPORTANT ADVISORY NOTES

KNOWN ISSUES


  • The current version of Rapid SQL does not support the MySQL ODBC client that shipped with previous versions of Rapid SQL. If Rapid SQL crashes after connecting to a MySQL data source:
    1. Close Rapid SQL.
    2. Uninstall the older MySQL ODBC client.
    3. Restart Rapid SQL and try connecting to a MySQL datasource. You are prompted to install the MySQL client drivers.
    4. Follow the installation instructions to install the new driver.
  • Note that when debugging a procedure against an Oracle data source, Rapid SQL performs a compilation before debugging. During a compilation, Oracle invalidates referencing objects. For example, if procedures A2 and A3 both reference procedure A1, debugging procedure A1 in Rapid SQL, will result in procedures A2 and A3 being invalidated.
  • For servers running on Sybase version 12.5.3a, the CREATE ENCRYPTION KEY and DECRYPT permissions do not display properly--they'll be shown as null. See Sybase's document CR392544 ("sp_helpprotect does not show privileges related to encryption keys."). This has been fixed in ASE version 12.5.3a/ESD#1 (now available as a download) and ASE version 12.5.4.
  • When you are using the Debugger:
  • Rapid SQL is currently unable to create table names, column names, and check constraint names longer than 18 characters on an OS390 mainframe database.
  • On SQL Server 2005, the Browser component is disabled by default. With this service disabled, in Rapid SQL you cannot reference SQL Server instances by name, only by port number. If you want the ability to reference SQL Server instances by name, you must enable this service on the server.
  • BUG FIXES

    Bugs Fixed in DBArtisan 8.0.2/XE 2

    No customer-reported bugs were fixed for this release.
    Bugs Fixed in Embarcadero Rapid SQL 8.0.1/XE 2
    Issue # Description DBMS
    RAP-4256 Rapid SQL crashes All
    RAP-5000 Indexes are not included in the extract of a system table All
    RAP-5615 [Procedure][Execute] The saved parameters are not loaded correctly DB2
    RAP-5684 [Tools] Unable to get the Database Search function working with DB2 DB2
    RAP-4104 Code Collapse not folding code in correct blocks Oracle
    RAP-5654 [Code Complete]Not all columns are prefixed when using an alias and selecting all the columns Oracle
    RAP-5663 [SQL Execution] Running script will cause application to quit Oracle
    RAP-5687 Error when attempting to schedule query from SQL Editor, Etsql.exe Has Encountered a Problem Oracle
    RAP-5059 The Column Names are not displayed in the Result tab of the Query Builder on a Sybase 12.5 datasource Sybase
    RAP-5697 [Tools] Database Searches fail to find the selected text. Sybase
    RAP-5700 [SQL Editor] Column not auto-expanding when multiple special characters are in a varchar Sybase
    Bugs Fixed in Embarcadero Rapid SQL 8.0/XE 2
    Issue # Description DBMS
    RAP-3899 Microsoft Visual C++ Runtime Library: RSQL742.exe - Application Error All
    RAP-4277 Rapid SQL crashes All
    RAP-4491 Randomly crashed All
    RAP-4559 When UAC (User Access Control) on Windows Vista feature is on, programs have to request Administrative Privileges before they can write to certain areas on the hard drive All
    RAP-5075 After uninstall Rapid SQL, un-removed registries prevent new installation from installing on the same machine All
    RAP-5312 After upgrade from Rapid SQL 7.5.5 to 7.6.0, previously opened sql files before exist no longer show up after user re-launches Rapid SQL All
    RAP-5603 [Application] Starting up Rapid SQL File -> Recent projects only lists recent project list. All
    RAP-4650 An unknown folder in C:\Documents and Settings on user's computer Oracle
    RAP-4717 When clicking on the Value field for a datetime parameter (when debugging an Oracle procedure), the implicit value is '30/11/1999' and not the current date as in 742 Oracle
    RAP-5216 Primary key script is not shown when creating a table with a script in ISQL Oracle
    RAP-5313 Table names, functions, synonyms and other objects are all displayed as question marks or blank Oracle
    RAP-5360 Query result set returns with 1st 3 of 4 columns blank Oracle
    RAP-5559 Leaves empty lines between logical lines/code blocks. When opens procedure, it has removed the empty lines Oracle
    RAP-5610 When decreasing the width of a number column, Rapid SQL reports that changes have been undone. Thus no changes to apply Oracle
    RAP-5641 [Datasource Explorer] The Materialized Views node is not populated when the Explorer is organized by object owner Oracle
    RAP-5642 [DBMS Object Management] The extract for materialized views containing lob definition is incorrect Oracle
    RAP-5648 SQL Editor] Re-executing dbms_output.put_line query does not bring back results Oracle
    RAP-4340 Project Reverse Engineering Wizard, step 3 of 5 missing FUNCTIONS from database object list SQL Server
    RAP-5037 SQL output from Project Build has NULL characters between every letter SQL Server
    RAP-5467 Extraction of Stored Procedures on particular server gives a blank results SQL Server
    RAP-2496 BUG: Rapid SQL does not display Double Byte Character set correctly Sybase
    RAP-4451 After I open a sql window, I no longer get the Groups, Logins, Users, etc access - is this on purpose? Sybase
    RAP-4738 Rapid SQL crashes during launch time Sybase
    RAP-5047 Windows 2K users can't find keystroke that allows the selected column name to be entered when using auto-col lookup feature Sybase
    RAP-5490 [Edit>Find] - {Ctrl+F} - Slower than previous release when searching result output Sybase
    RAP-5506 [Code Assist] Auto Complete Replaces Text After Insertion Point Sybase
    RAP-5512 [ISQL] [Performance] [Results] Performance issue when performing a SELECT from a table with 30k~ rows Sybase
    RAP-5574 Code Analyst - If I click on Unit Profiled Time I can't uncheck it after Sybase

    Additional Resources

    Licensing Your Embarcadero Technologies Product

    All Embarcadero Technologies products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. For information on licensing your product, refer to the Rapid SQL Installation Guide. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] for sales in the EMEA region.

    Embarcadero Technologies Product Support

    The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, discussion forums, and the Embarcadero Knowledge Base. Visit www.embarcadero.com/support, or click any of the links below, to find:

    Embarcadero Technologies Technical Support

    If you have a valid maintenance contract with Embarcadero Technologies, the Embarcadero Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).

    We encourage you to open technical support cases via the Technical Support request form. For additional information about Embarcadero Technologies Technical Support, visit the Support section of our Web site.

    Embarcadero Technologies on the Web

    To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at www.embarcadero.com.