Rapid SQL ReadMe

Welcome to Rapid SQL® XE 3 and Rapid SQL® 8.1

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

ReadMe Last Published: March 30, 2012. 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 3/8.1

Updated support for Microsoft SQL Server features

Updated support for Sybase features

User interface improvements

DBMS Support and Connectivity

Dedicated Support

Generic JDBC/ODBC Connectivity

DBMS Versions No Longer Supported

Release Notes

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 3/8.1

Sybase IQ Support

This release introduces support for Sybasse IQ, Sybase's column-oriented DBMS. This release will offer the following:

The ability to register and connect to Sybase IQ datasources
Explorer visibility of the following elements: DBSpaces, Domains, Foreign Keys, Functions, Groups, Indexes, Join Indexes, Primary Keys, Procedures, System Indexes, System Tables, System Triggers, Tables, Triggers, Users, and Views.
SQL Editor support

Connectivity Updates

In previous releases, Rapid SQL connectivity was primarily restricted to native Embarcadero drivers. These proprietary drivers, packaged with Rapid SQL, work in conjunction with a supported set of third-party clients that must be installed. While this remains the default, the Datasource Registration wizard now features a new Connect Using JDBC control that lets you specify a more direct connection that does not require a native client.

With the exception of Interbase/Firebird datasources, one or more Type 4 JDBC drivers for each supported platform are now packaged with Rapid SQL. In addition, a new Generic JDBC DBMS platform selection lets you select and configure a non-packaged, custom JDBC driver of your choice.

Rapid SQL queries the selected driver to determine the properties, options, or parameters that the JDBC driver accepts. The Datasource Registration Wizard’s new Custom JDBC Properties panel lets you provide these name/value pairs.

DBMS Version Updates

Rapid SQL now provides support for Sybase ASE version 15.5. All current Rapid SQL functionality is now available on this platform version.

SQL Editor Updates

This release includes the following updates to the SQL Editor

Hyperlink object actions - Hyperlinks let you invoke common or object type-specific object actions against tables, views, functions, procedures, packages, and package bodies referenced in a script. A configurable keystroke combination (default, CTRL+Right-click) opens an object action menu.
Datasource index configuration - the object index used to implement Code Assist features can now be configured. You can control the object types included in the index, the maximum size of the index, and the maximum number of results returned by queries to the index.

Updated support for Microsoft SQL Server features

Currency updates for this release include:

Enhanced Public Key Encryption Support - Certificate, Asymmetric Key, and Symmetric Key database objects are now offerred. Dedicated wizards and editors let you create and edit the new objects types. In addition, associated object actions let you add or change a certificate's private key and back up a certificate to file.

Updated support for Sybase features

Currency updates for this release include:

Proxy Tables - New properties let you specify FOR PROXY_UPDATE and DEFAULT_LOCATION= parameters when creating a database. A new Resynchronize action, available against databases defined with the For Proxy Update property selected, forces the resynchronization of proxy tables within the proxy database.
Archive databases - A new ARCHIVE Type option and a new Scratch Database property let you generate CREATE ARCHIVE DATABASE DDL and specify a WITH SCRATCH_DATABASE value.
Relaxed Durability Databases - A new Durability property of the Database Wizard/Editor lets you control persistence of commited transactions. Selecting one of the FULL, NO RECOVERY, or AT_SHUTDOWN options includes a DURABILITY= option in the DDL generated to create or alter the database.
In-memory Databases - A new property on the Database Wizard lets you create in-memory databases against a device initialized (DISK INITI) using the inmemory parameter.

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:

Oracle – Job Queues
Sybase – Segments

DBMS SUPPORT AND CONNECTIVITY OPTIONS

DEDICATED SUPPORT CONNECTIVITY OPTIONS

Rapid SQL provides dedicated connectivity to a specific version range of IBM DB2 for Linux, Unix, and Windows, IBM DB2 for z/OS, InterBase/Firebird, Microsoft SQL Server, MySQL, Oracle, and Sybase databases. The following connectivity options are provided:

Native Embarcadero drivers - For use with IBM DB2, SQL Server, MySQL, Oracle, and Sybase ASE datasources, Rapid SQL is packaged with a set of native drivers, each requiring a DBMS-specific client to be installed.
InterBase/Firebird - InterBase requires both client and driver software to be installed. Firebird requires driver software.
JDBC drivers - For all supported DBMS platforms, Rapid SQL can connect to a datasource more directly using one of the packaged, third-party JDBC drivers. No additional connectivity components need to be installed. One or more third-party drvers, tested against Rapid SQL, are installed with Rapid SQL.

The following table provides a summary of resources/requirements for connectivity to dedicated DBMS platforms. For each platform, it lists supported versions, the client software, driver, or client/driver combination that must be installed if using native Embarcadero clients, and the third-party, Type 4 JDBC drivers packaged with Rapid SQL.

DBMS Platform Supported Versions Client (or driver/client combination) Required for use with Native Embarcadero Drivers Packaged JDBC Driver

Firebird Firebird 2.0 Firebird ODBC Driver Jaybird JDBC Driver

IBM DB2 for z/OS v8 and v9 DB2 UDB Client for Windows 8.0 or later IBM Data Server Driver for JDBC

IBM DB2 for LUW Versions 8.0 - 9.7 IBM DB2 LUW Client for Windows 8.0 or later IBM Data Server Driver for JDBC

InterBase InterBase 2007
InterBase 2009
DataDirect ODBC driver for InterBase and the InterBase Client Interbase JDBC Driver

Microsoft SQL Server 2000
2005 (All editions including 2000 SDE and 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64)
2008
Microsoft SQL Server Client Library jTDS Type 4 JDBC Driver for Microsoft SQL Server
Microsoft SQL Server JDBC Driver

MySQL 4.x MySQL ODBC driver 3.5.1 - MySQL ODBC driver 4.x. MySQL Connector/J JDBC Driver

Oracle Oracle 9i, 10g, and 11g Oracle SQL*Net Client Oracle JDBC Thin Driver

Sybase ASE Sybase System 12.5 - Sybase 15.5 Sybase Open Client jTDS Type 4 JDBC Driver for Microsoft SQL Server
Sybase jConnect JDBC Driver

Sybase IQ 12.7 - 15.4 Sybase jConnect JDBC Driver for Sybase IQ

DBMS Platform	Supported Versions	Client (or driver/client combination) Required for use with Native Embarcadero Drivers	Packaged JDBC Driver
Firebird	Firebird 2.0	Firebird ODBC Driver	Jaybird JDBC Driver
IBM DB2 for z/OS	v8 and v9	DB2 UDB Client for Windows 8.0 or later	IBM Data Server Driver for JDBC
IBM DB2 for LUW	Versions 8.0 - 9.7	IBM DB2 LUW Client for Windows 8.0 or later	IBM Data Server Driver for JDBC
InterBase	InterBase 2007 InterBase 2009	DataDirect ODBC driver for InterBase and the InterBase Client	Interbase JDBC Driver
Microsoft SQL Server	2000 2005 (All editions including 2000 SDE and 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64) 2008	Microsoft SQL Server Client Library	jTDS Type 4 JDBC Driver for Microsoft SQL Server Microsoft SQL Server JDBC Driver
MySQL	4.x	MySQL ODBC driver 3.5.1 - MySQL ODBC driver 4.x.	MySQL Connector/J JDBC Driver
Oracle	Oracle 9i, 10g, and 11g	*Oracle SQLNet Client**	Oracle JDBC Thin Driver
Sybase ASE	Sybase System 12.5 - Sybase 15.5	Sybase Open Client	jTDS Type 4 JDBC Driver for Microsoft SQL Server Sybase jConnect JDBC Driver
Sybase IQ	12.7 - 15.4		Sybase jConnect JDBC Driver for Sybase IQ

GENERIC JDBC/ODBC CONNECTIVITY

Generic JDBC/ODBC connectivity to non-dedicated DBMS systems or non-database datasources is also provided. Rapid SQL can connect to a datasource using a customer-provided, third-party JDBC version 3.0 or ODBC version 3.0 driver. Minimal Rapid SQL functionality is provided, including a basic Explorer tree and SQL querying.

DBMS VERSIONS NO LONGER SUPPORTED

As of this release, Rapid SQL is no longer tested against Oracle 8i.

Release Notes

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 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 8.1/XE3
Issue #	Description	DBMS
RAP-2953	Cut and paste sql code with collapsible feature doesn't work probably	All
RAP-4243	: Parameter Input Grid passes wrong number	All
RAP-4248	Error in options tab	All
RAP-4546	If a query contains no resutls the column headers do not resize to the width of the header names.	All
RAP-4668	Rapid SQL crashes when trying to launch the product	All
RAP-4989	During installation, pop window only asks if user needs to keep settings from older version instead of the most current version available on the machine	All
RAP-5701	Undo Comment Out feature always removes 3 characters "-- " even if query does not have a space after "--"	All
RAP-5706	TS: [Describe] The Describe icon is disabled in the Main toolbar while an ISQL window is opened	All
RAP-5720	[DBMS Actions] No datasources available for Database search Wizard	All
RAP-5725	TS :[SQL Editor] When trying to go to Next Bookmark (F2) in a ISQL file, the cursor goes to a row or two below	All
RAP-4129	Close menu item, under context menu over Schema Tab restuls is disabled	DB/2
RAP-5703	[Explorer]DB2 ODBC connections fail to expand table listing in explorer, error appears "DB2ODBC -- [IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=HYC00(HYC00,-99999)"	DB/2
RAP-5536	Queries are taking long time to execute comparing to other versions	ODBC
RAP-4300	Crashes when running SQL in the ISQL window	Oracle
RAP-4411	RS 7.5 Beta 3: Automatic resizing of result columns	Oracle
RAP-4548	Closing result windows is significantly slower in 7.5 than it was in 7.4.1.	Oracle
RAP-5307	Rapid SQL gives error :OciTypeBinder - Cannot convert type to Stream when execute query contains xmlelement	Oracle
RAP-5502	[Slow Performance]Rapid SQL takes more than 8 hours to bring up one million records, but the first 2,000 records shows up quickly	Oracle
RAP-5602	[SQL Editor] An unexpected token "FLD_ACCVER" was found. Expected SINGLE_QUOTED_LITERAL	Oracle
RAP-5705	[Application] Exception unknown software exception upon launching application	Oracle
RAP-5710	TS : [Edit Data] The Save As file does not appear when trying to save to Excel file	Oracle
RAP-4485	Can't register MS SQL Server using ODBC without MS SQL support	SQL Server
RAP-3105	After closing Rapid SQL, gets a Microsoft Visual C++ Runtime Library: RSQL740.exe- Application Error	Sybase
RAP-4463	Database Search will not return results if the servers are using SSL	Sybase
RAP-5309	RS760 3370 crashes periodically (every few days) when trying to use auto-col lookup (at the point where the user types the period).	Sybase
RAP-5449	RapidSQL generates "the memory could not be read" error when a given scenario is executed by customer	Sybase
RAP-5619	[Data Source Explorer] Unable to keep focus on current tab when disconnecting a datasource.	Sybase
RAP-5638	[Tools] Excel sheet does not show all results when script is run with scheduler.	Sybase
RAP-5675	[Debuggers] Application hangs when running stored procedure with debugger on	Sybase
RAP-5685	[Application] Stored procedure results take longer to display	Sybase
RAP-5711	TS : Set Quoted Identifier is turned ON even though it is OFF when extracting a View with a trigger	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.