Welcome to Rapid SQL® XE and Rapid SQL® 7.7.2

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

ReadMe Last Published: October 25, 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 Version 7.7/XE

Offline License Borrowing

Performance Improvements

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 Version 7.7.1/XE

Offline License Borrowing

Rapid SQL now allows you to consume a license in offline mode. When you explicitly check out a license (Help > Checkout License) for offline use, you can use Rapid SQL without a connection to your License Center for a specified duration. This lets you work while travelling or commuting, work away from your primary work area, or use Rapid SQL when a network connection is unavailable or not required. You can also check a borrowed license back in (Help > Checkin License) before the duration expires.

Performance Improvements

In response to customer feedback, performance improvements have been made in the areas of connection pooling and ISQL editor functionality. This work includes the following user interface changes:

  • Editor options (File > Options > ISQL > Editor) now offer cut-and-paste options for line ending conversions. If end-of-line characters are replaced with platform-specific equivalents (Windows - CR LF, UNIX - LF, Macintosh - CR) for environments that require platform-specific end-of-line characters, unnecessary characters and incorrect display are avoided, but cut-and-paste operations take more time to complete. If end-of-line characters are not replaced, cut-and-paste operations take less time to complete.
  • Configuration of the Syntax Checking, Semantic Validation, and Code Complete features (File > Options > ISQL > Code Assist) has been simplified.
  • What's New in Rapid SQL XE 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

    NOTE: Since Rapid SQL is a 32-bit application that runs emulated on 64-bit versions of Windows, only 32-bit versions of the DBMS client software are supported.

    IBM DB2 UDB 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 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


  • For Oracle 10g systems, the Oracle client software must be installed within the the C:\Program Files (x86) directory to properly provide connectivity and required functionality to Rapid SQL.
  • 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 and Rapid SQL 7.7.2
    Issue # Description DBMS
    RAP-5539 Resurrect option to save current view and open files when RapidSQL closes in order to bring them back when it re-opens All
    RAP-5645 [SQL Editor] Application crashes when backing up over blank spaces All
    RAP-5632 [SQL Editor] Time datatype displays as midnight DB2
    RAP-5652 SQL Editor] Error 'An unexpected token "**" was found following ""' when running query DB2 z/OS
    Bugs Fixed in Embarcadero Rapid SQL XE and Rapid SQL 7.7.1
    Issue # Description DBMS
    RAP-4992 SQL Files aren't automatically reloading when launching Rapid SQL All
    RAP-5545 [SQL Editor]CTRL + T fails to cycle back to Query tab after cycling through Result tabs All
    RAP-5587 [Application] Files previously used do not appear in recent file list. All
    RAP-5595 [Workspaces] Changing between workspaces should keep focus on last editor accessed in each workspace All
    RAP-5601 [Project] File > Close project closes the most right tab, instead of closing the actual project tab All
    RAP-4921 Compile error message when a Stored Procedure is used to call another stored procedure DB2
    RAP-5565 Crash after connecting to Interbase and opening a New ISQL Window InterBase
    RAP-5546 [Generate Anonymous Block] function does nothing when using this on a Procedures associated with a Package Oracle
    RAP-5558 Connection is locked in an ISQL session Oracle
    RAP-5564 Compiling a procedure or package, when using the compile action dialog, returns an error of ORA-24344: success with compilation error Oracle
    RAP-5576 Scripts with goto section for creating stored procedures cannot be run SQL Server
    RAP-5611 [SQL Editor] Application crashes when clicking on period button SQL Server
    RAP-5613 [Explorer][Views] Wrong maximum length of varchar/nvarchar columns SQL Server
    RAP-4585 With text in the Editor, traversal between full screen mode and normal causes editor icon corruption Sybase
    RAP-5460 Users with a Sybase 15 client, who implement password encryption, can't connect to the Sybase 15 datasource without error: "Adaptive Server requires encryption of the login password...". Sybase
    RAP-5560 [SQL Editor] The SQL Editor parser for the statements with special characters like # do not handle tabs correctly Sybase
    RAP-5571 [Connectivity] When automatically connecting to Sybase datasources after Rapid SQL restarts, a "Cannot load Open Client" error pops up Sybase
    RAP-5573 [Data Source Explorer] Object browser shows the list of objects from the previously viewed database Sybase
    RAP-5579 [Code Assist] - When using auto completion, RSQL7.7 crashes Sybase
    RAP-5609 Random crashes on Rapid Sql Sybase
    Bugs Fixed in Embarcadero Rapid SQL XE 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.