Rapid SQL ReadMe

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:

Connectivity/Datasource support - InterBase connectivity has been incorporated into the standard Rapid SQL datasource scheme. This release lets you register datasources, edit datasource details, and offers other common datasource management features.
Object management - Editors/Wizards are available for a full set of object types and a preliminary set of object actions are available.
SQL editor support - includes execution options, syntax checking, and Code Assist features

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:

A short name label included in the Datasource toolbar combo/dropdown when a categorized datasource is selected
Color-coded tabs on windows associated with actions against a categorized datasource, editor or ISQL windows for example
Color-coding of the status bar at the bottom of the Rapid SQL window

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

Windows Registry datasource catalog - The datasource catalog is stored and managed locally, in the Windows registry.
File based datasource catalog - The datasource catalog is stored locally and is file-based.

For installations using the Windows Registry or File based method, the user can add and delete datasources and edit the registration details of existing resources. Any changes are retained across startups of Rapid SQL. As well, each of these methods is compatible with other Embarcadero products using that method, allowing Rapid SQL users to share the datasource catalog with other products using the same method.
Network shared datasource catalog - The datasource catalog is file-based, and obtained from a user-specified location such as a network share. Changes such as new datasources, deleted datasources or edited datasource registrations are lost as soon as this user shuts down Rapid SQL. This method allows centralized maintenance of the Datasource Catalog and sharing of a single catalog among multiple users across a network.

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:

On-the-fly syntax-checking locates and diagnoses syntax errors as you type
Semantic validation eliminates typographical errors and helps avoid outdated references in specified object names
Code Complete analyzes statements as you type and offers intelligent suggestions with regard to object names
Code Templates, configured using the Code Workbench, let you add customizable blocks of code to a script with a couple of keystrokes

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:

Encoding scheme options of ASCII, UNICODE, or NONE for character or graphic string parameters in procedures and functions
Object ownership transfer for object owners and users with SECADM authority
Inherit isolation level with or without lock request options on Structured Type methods

Updated support for IBM DB2 for z/OS features

This release features the following feature upgrades or improvements:

Extended Truncate table support
Table cloning actions
Updated calculation and display of catalog table statistics
Long object names
Column size and default value modification with simple ALTER TABLE statements
Compressed indexes, index key randomization, and expression-based indexes
Universal tablespaces

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:

Microsoft SQL Server – Roles, User Messages
DB2 for Linux, Unix, and Windows – Structured Types

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:

The DataDirect ODBC driver for InterBase and the InterBase Client are installed
The interbase.msg file exists in the InterBase client's directory
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:

Close Rapid SQL.
Uninstall the older MySQL ODBC client.
Restart Rapid SQL and try connecting to a MySQL datasource. You are prompted to install the MySQL client drivers.
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:

The Debugger windows (Variables, Watch, CallStack, Dependency) cannot be undocked. This behavior is deliberate and is true only for the Debugger windows. The Output window can be undocked.
When running Windows XP SP2, SQL Server 2000 SP4 is required on both the client and the server.
When running the Debugger on SQL Server 2005 CLIENTS:

Verify that the file ssdebugps.dll is registered on the client machine. This file is REQUIRED for debugging and Microsoft only installs it on the server machine and not as a part of a client-only install.
Follow the instructions under the "Configure DCOM on the computer that is running Visual Studio. NET" heading from Microsoft to reconfigure the DCOM settings on your client machine: http://support.microsoft.com/default.aspx?kbid=833977.
On the Default Properties tab of the My Computer dialog box, make sure the Default Authentication Level is set to None and that the Default Impersonation Level is set to Impersonate.

When using the Embarcadero Sybase debugger against a Sybase database with multiple temporary databases (supported in Sybase ASE 12.5.0.3 and above), either the user or the debugger application must be bound to a specific temporary database.

To bind the Embarcadero Sybase Debugger:
sp_tempdb "bind" , "ap", "Sybase Debugger", "DB", "<tempdb name>"
To bind the user:
sp_tempdb "bind", "lg", "<login id>", "DB", "<tempdb name>"

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.