Welcome to Rapid SQL® XE Pro and Rapid SQL® 7.7

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

ReadMe Last Published: April 28, 2010. 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 Rapid SQL XE Pro and Rapid SQL 7.7

InterBase support

Datasource management

Unicode

ISQL editor updates

Updated support for Microsoft SQL Server features

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

Updated support for IBM DB2 for z/OS features

Updated support for Oracle 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 Rapid SQL XE Pro and Rapid SQL 7.7

InterBase support

This release introduces support for InterBase® SMP, an Embarcadero offering. InterBase is a high-performance, full-featured database offering in a resilient, lightweight, low-cost package. Preliminary support includes:

Datasource management

This release introduces a number of techniques for filtering the Datasource Explorer view. On-the-fly filtering lets you filter tree nodes as you work. Object filters, defined and enabled at either the DBMS or datasource level, let you filter display by object name/schema. Node filtering lets you hide or display object types by DBMS platform.

Also new to this release is the means to visually distinguish between datasources used for different purposes in your organization. You can assign a category, such as development or production, when creating or editing a datasource. When you assign a category to a datasource, the Datasource Explorer icons for the datasource show a distinctive color-coded category indicator. You can use the Options editor to customize your categorization scheme to include:

Rapid SQL now lets you select one of three methods of datasource catalog storage:

The Datasource panel of the Options editor lets you choose a storage method and specify the network location of a Network shared Datasource catalog definition file. In addition, the Import/Export functionality available from the Manage Datasources facility has been enhanced specifically to account for the new storage methods.

Unicode support

Rapid SQL now includes Unicode support throughout the application, allowing you to work with data in different languages and display the text correctly on screen.

ISQL editor updates

The ISQL Editor has been enhanced with a set of automated validation and code assistance features:

In addition, specified query options that customize the execution environment can now be saved and subsequently loaded. The frequency with which the options are sent to the server has been optimized.

Updated support for Microsoft SQL Server features

Index support in Rapid SQL has been upgraded to account for newer Microsoft SQL Server index functionality. You can now rebuild, reorganize, and disable indexes, primary keys, and unique keys. When creating, dropping or rebuilding indexes, primary keys, or unique keys, online options are available with these operations. This release also offers sparse columns, MAXDOP support, and page and row locking.

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

This Rapid SQL release supports the following recent upgrades to IBM DB2 for Linux, Unix, and Windows functionality:

Updated support for IBM DB2 for z/OS features

This release features the following feature upgrades or improvements:

Updated support for Oracle features

When creating or modifying tablespace datafiles, you can now set the availability of the datafile to either ONLINE or OFFLINE.

Updated support for Sybase features

A Server shutdown Wait Time option lets you enable a grace period, an upper limit on how long to wait for normal operations to complete before forcing a shutdown.

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 UDB for OS/390 (z/OS)

Server: IBM DB2 UDB for OS/390 and z/OS v7, 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 UDB for LUW

Server: IBM DB2 LUW Versions 8.x and 9.x

Client: IBM DB2 LUW Client for Windows 7.0 or later. When using a v8 client, Rapid SQL 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 System 12.5, Sybase 15.x

Client: Sybase Open Client

DBMS VERSIONS NO LONGER SUPPORTED

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

IMPORTANT ADVISORY NOTES

When working against versions prior to the Interbase 2009 Update 3 release, Rapid SQL may crash due to Interbase client/Data Direct ODBC Driver problems accessing the interbase.msg file. If you experience this type of crash, ensure that:

  1. The DataDirect ODBC driver for InterBase and the InterBase Client are installed
  2. The interbase.msg file exists in the InterBase client's directory
  3. You have the correct path in registry. [HKEY_LOCAL_MACHINE\SOFTWARE\Borland\InterBase\Servers] has a RootDirectory key that should point to the InterBase installation directory, e.g. "RootDirectory"="D:\\CodeGear InterBase"

KNOWN ISSUES


  • The Explorer's Columns node does not populate for ODBC data sources.
  • 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 Embarcadero Rapid SQL XE Pro and Rapid SQL 7.7
    Issue # Description DBMS
    RAP-4583 Installation space issue during changing Drive from C to D All
    RAP-5212 Rapid crashes when you choose Basic Macro Editor from the Tools menu All
    RAP-5377 SQL scripts open while exiting application are not automatically re-opened upon application launch. The File>Options>Explorer>'Retain View Setting on Close' no longer works correctly. All
    RAP-5396 Application no longer opening up previously opened SQL file on restart All
    RAP-5438 After user modify the script, "Save All" button doesn't save script when user click on it at the result window All
    RAP-5522 An empty file.log is created when you right click on a .sql file and choose to open it with Rapid SQL or DBArtisan All
    RAP-5070 After upgrade from RS741 to RS755, DB2 table extract shows correct indexes when extracted under the table owner but incorrect when extracted under the owner who created the table index. DB2
    RAP-3878 Rapid SQL is not correctly parsing the SQL statements upon alteration of DB2 z/OS Stored Procedures in compat mode DB2 z/OS
    RAP-4584 An error occurred when connecting with JDBC MySQL
    RAP-3384 An error message is displayed on trying to generate the Package script from Generate >Package context menu option on an Oracle 9i and 10g datasource Oracle
    RAP-4314 Rapid SQL doesn't return the correct number of rows with specific query Oracle
    RAP-4476 Row count is off by one in the query window Oracle
    RAP-5278 Rapid SQL doesn't show index names in Query Plan Oracle
    RAP-5292 In debugger, if debug stored procedure A, which calls stored procedure B, all users stored procedures go invalid. Oracle
    RAP-5379 Query that runs fine in SQL plus and RS740 fails with latest release. Oracle
    RAP-5400 After comment "--" , more than one line font become green Oracle
    RAP-5338 After upgrade from Rapid 7.5.5 to 7.6.0, user got Unknown Database Error when user clicked on Database icon after connecting to a MS SQL Server 2000 datasource regardless of whether the default database is Master or not SQL Server
    RAP-5468 In the explorer under columns node, the size for the nvarchar datatypes is doubled SQL Server
    RAP-5472 Replace window can't be accessed in the Create Trigger wizard on the MSSQL servers SQL Server
    RAP-5131 Extract includes Revoke statements for objects that have permissions granted Sybase
    RAP-5436 Auto Lookup is case - sensitive on a non case-sensitive Sybase server Sybase
    RAP-5448 Row numbers should not be included when copy result set to Excel Sybase
    RAP-5492 Extracting DDL for multiple tables inappropriately goups the table definitions preceding the index definitions. The index definition should follow it's respective table's definition. 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.