Rapid SQL ReadMe

Welcome to Rapid SQL® XE3.5 and Rapid SQL® 8.2

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

ReadMe Last Published: February 15, 2013. 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 XE3.5/8.2

Lockdown Mode

UI/Explorer/Browser Updates

Connectivity Updates

SQL Editor Updates

Command Line Startup

Updated support for IBM DB2 (LUW and z/OS) features

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

Updated support for Oracle features

Updated support for Microsoft SQL Server features

Updated support for Sybase IQ features

DBMS Support and Connectivity

Dedicated Support

Generic JDBC/ODBC Connectivity

DBMS Versions No Longer Supported

Release 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 XE3.5/8.2

Lockdown Mode

Registry location HKLM\Software\Embarcadero\Rapid SQL\Admin now has the following entries that let you restrict certain fatures:

RestrictedPlatforms (REG_SZ) - takes a comma-separated list (db2=0,mssqlserver=1, for example) dictating DBMS platform support on the machine. Valid names for the name=value pairs are db2, os390, interbase, mssqlserver, mysql, oracle, sybase, mssqlazure, odbc, jdbc, and sybaseiq. Any non-zero value for a name=value pair results in that platform not being available to Rapid SQL on that machine.
DisableAutoConnect (REG_DWORD) - When set to any non-zero value, users cannot use the auto-connect feature when registering or logging in to a datasource.
SharedDatasourceCatalogPath (REG_SZ) - Providing a path to the network shared datasource catalog forces Rapid SQL to use that datasource catalog storage option. Registry-based and file-based catalog storage will be unavailable on this machine.

UI/Explorer/Browser Updates

Active/Selected Datasource Control - This release introduces greater control over how the active or selected datasource can be changed. A new Link button above the Explorer pane lets you enable and disable linking of the Explorer tree with the Select Datasource (Select Datasource/Database) dropdown.
When linking is active, methods of changing the active/selected datasource are identical to those of previous release. You can explicitly change the active datasource by selecting a datasource from the Select Datasource dropdown. The active datasource changes automatically as datasource-associated windows such as object editors become active in the Workspace or as you select nodes in the Explorer. As a side effect, the associated datasource node in the Explorer tree is selected.
When linking is inactive, you can only explicitly change the active datasource when an SQL Editor window is open. The active datasource still changes atomatically as datasource-associated windows such as object editors become active in the Workspace. And when linking is inactive, the change in the selected datasource has no effect on the selected node in the Explorer tree.
Column Filtering Using Regular Expressions - When using the Browser function, column filtering now lets you qualify displayed objects using regular expressions.
This feature must be enabled. The Options Editor’s Explorer pane has a Column filters use regular expressions by default control that enables regular expression usage when Rapid SQL starts or a new Browser is manually opened. In addition a REGEX On/REGEX Off button in the status bar lets you toggle the feature on an off for a particular window.
Locked/unlocked User and Login Icons - Depending on the DBMS platform, the icons associated with logins and users differ according to the account’s locked or unlocked state, when viewed in the Explorer.

Connectivity Updates

LDAP Support - When using the Discover Datasources feature or manually registering a datasource, Rapid SQL will now search an LDAP server for datasources. The Options Editor now lets you provide details you need to connect to an LDAP Server.
ODBC Connectivity to Sybase IQ Datasources - For connectivity to Sybase IQ datasources, DBArtisan/Rapid SQL now supports the following ODBC drivers:
- SQL Anywhere ODBC drivers for Sybase IQ 12.7
- Sybase IQ 32-bit ODBC drivers
Discover Datasources Detection of Toad datasources - You can now import definitions from the following Quest Software products:
- Toad for MySQL
- Toad for Oracle
- Toad for SQL Server
- Toad for Sybase (ASE and IQ)
The Discover Datasources feature will automatically search registration files for datasource definitions and offer you the option to register any datasources found.
Other Discover Datasource updates - The Discover Datasources dialog now displays Discovery Source (LOCAL ALIAS, NETWORK, LDAP, or TOAD) and Status fields for each discovered datasource.

SQL Editor Updates

Code Snippet Execution - You can now execute an individual statement where statments in a script are terminated with a valid delimiter (; or /). The Execute Statement command is available from the Query menu and as a right-click option.

Bind Variable Parameterization in Prepared Statements (Dynamic SQL) - Rapid SQL lets you provide bind variable values when executing scripts containing prepared statements. In scripts, Rapid SQL recognizes named or unnamed variables that use the following notation:

DBMS Platform/Driver Type	Notation
Oracle with native driver	:name or :number
Oracle With JDBC driver	?
All other platforms/drivers	?

Support for bind variables is enabled on a editor window-by-editor window basis. Bind variable parameterization is enabled by setting the Prepare Batch Query Option, available on all DBMS platforms. For an enabled SQL Editor window, when using execution options, whenever a statement containing bind variable notation is encountered, a Bind Variables dialog opens. For each bind variable in the current stement, the dialog lets you specify:

A type
An IN, OUT, or INOUT designation for elements such as function or procedure parameters or arguments, variables used in INTO clauses of an INSERT statements and variables used in RETURNING clauses of an Update statements.
A value

You can then execute, skip the statement, or abort execution for the currently running script.

Command Line Startup

This release introduces command line startup of Rapid SQL with switches letting you specify a datasource and credentials:

rsql.exe -D datasource -U username -P password

This is primarily aimed at identity management systems working in conjunction with Rapid SQL. Such systems can be configured to start Rapid SQL and connect to a specific datasource using credentials that are invisible to the user. Other applications that hide credentials, force connection to a specific datasource, or otherwise automate startup of Rapid SQL can make use of this feature.

Updated support for IBM DB2 (LUW and z/OS) features

Temporal Tables - The Tables Wizard now has a Temporal Properties panel. It lets you include attributes that indicate when data in a row is current and when transactions affected the data. Tables can be designated as system-period or application-period tables. In addition, the Columns panel now includes settings that let you properly specify row-begin, row-end, and transaction start ID columns. In addition, the Primary Key Wizard and Unique Key Wizard have been updated to facilitate temporal tables. A new Time period policy property lets you create a constraint on a business-time table that can enforce uniqueness of the data for any point in business time.

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

Lowering the High Water Mark in Tablespaces - The Lower High Water Mark object operation lets you reduce the size of existing containers.
Moving Table Data Online - A new Move Table object action lets you build and submit a SYSPROC.ADMIN_MOVE_TABLE call, letting you move data in an active table into a new, identically-named table, leaving the data online and available for use.
Storage Path and Container-based Tablespace Actions - Two new tablespace actions are now available. Rebalance lets you create containers on recently added storage paths and drop containers from storage paths that are in DROP PENDING state. Drop Automatic Storage Paths removes one or more storage paths with an optional REBALANCE operation.
Index Compression - The Index Wizard and Index Editor now include a Compress property. This controls whether a COMPRESS YES clause is added to the generated CREATE/ALTER INDEX statement, enabling index compression.

Updated support for Oracle features

Compound Trigger Support - The Oracle Trigger Wizard’s Trigger Timing property now offers a COMPOUND option, letting you create compound triggers. As an aid, when you select this option, the Action tab is automatically populated with a compound trigger block template. The CREATE OR REPLACE TRIGGER... DDL generated for the trigger built using these options includes the compound trigger-specific FOR clause.
Enable/Disable Trigger Support - A new Change Status object action lets you enable or disable one or more triggers.

Updated support for Microsoft SQL Server features

User and Login Permissions Updates - When creating and editing users, you now have access to permission-related functionality introduced since Microsoft SQL Server 2000. In addition, the SQL Server Logins Editor, has been updated to let you assign object and system permissions to a login.

Updated support for Sybase IQ features

Tools Menu Command Availability - The Script Execution Facility, File Execution Facility, Database Search, Visual Diff..., and Import Data commands are now available for the Sybase IQ platform.
DDL Extract Options - You now have more control over Extract operations. The Options Editor now includes a DDL Extract > Sybase IQ panel. As for other platforms, this panel lets you specify the object types to include DROP statements for and the default dependent object types for each object type included in extract operations
Events And Unique Keys Object Types - The Datasource Explorer now offers Sybase IQ Events and Unique Keys object types. A basic set of Drop, and Extract actions are supported against unique keys. Those actions, as well as an Object Properties action, are supported against events.

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 9.0 - 9.7 IBM DB2 LUW Client for Windows 8.0 or later IBM Data Server Driver for JDBC

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

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

MySQL 4.x MySQL Connector/ODBC Driver 5.2.x Driver - MySQL Connector/ODBC driver 3.51.x Driver 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 SQL Anywhere ODBC drivers for Sybase IQ 12.7
Sybase IQ 32-bit ODBC drivers
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 9.0 - 9.7	IBM DB2 LUW Client for Windows 8.0 or later	IBM Data Server Driver for JDBC
InterBase	InterBase 2007 InterBase 2009	InterBase ODBC Driver or DataDirect ODBC driver for InterBase and the InterBase Client	Interbase JDBC Driver
Microsoft SQL Server	2005 (All editions including 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64) 2008 2012	Microsoft SQL Server Client Library	jTDS Type 4 JDBC Driver for Microsoft SQL Server Microsoft SQL Server JDBC Driver
MySQL	4.x	MySQL Connector/ODBC Driver 5.2.x Driver - MySQL Connector/ODBC driver 3.51.x Driver	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	SQL Anywhere ODBC drivers for Sybase IQ 12.7 Sybase IQ 32-bit ODBC drivers	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 Microsoft SQL Server 2000 or IBM DB2 for Linux, Unix, and Windows 8.x.

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.2/XE3.5
Issue #	Description	DBMS
RAP-2833	RS740 3214 : Application prints 3 copies page layout is set on Landscape	All
RAP-3572	Rapid SQL randomly crashes after connecting to a datasource.	All
RAP-4231	Error: failed to load Embarcadero Component:	All
RAP-4242	Accessing object Descriptor via CTRL + D causes error: Failed to obtain an Browser Window object.	All
RAP-4542	Crashing when customer changes datasources	All
RAP-4703	Closing the program even if not connected to any Datasource will keep a RSQL.exe process in the task manager	All
RAP-4931	Going to Format - Properties isn't launching the display settings	All
RAP-4932	Right clicking on a column header deselects anything that you currently have selected in a results set	All
RAP-5198	Rapid SQL should not use MS Outlook to send notification email after user sets up SMTP in File > Options > SMTP Mail	All
RAP-5491	Server Busy Window seen regularly when using MSTFS (Microsoft Team Foundation Server)	All
RAP-5640	[Results] The save as Excel file type creates a html file with xls extension	All
RAP-5721	TS [Project]:Drop Statements are missing for reversed-engineering Procedures	All
RAP-5746	Error when executing scheduled task, Log4j:WARN No appenders could be found for logger Please initialize the log4j system properly	All
RAP-5760	Rename function does not work	All
RAP-5768	[SQL Editor] Issues with Commenting lines and blocks of lines	All
RAP-5772	[Script Execution Facility] System message indicating execution was completed is no longer displaying	All
RAP-5774	[Script Execution Facility] Output files are larger than before and is not exportable to MS Access	All
RAP-5282	Rapid SQL gives no result when user copies and pastes queries in ISQL window and execute the code in DB2	DB/2
RAP-5717	[SQL Editor] Syntax highlighting / coloring disappear in SQL script window when connecting to a datasource via ODBC	ODBC
RAP-4343	go to "Generate" -> "Statements" ->"Insert" no attributes	Oracle
RAP-4395	Native types aren't available in the Create Table wizard during column specification	Oracle
RAP-5308	When running a query plan on a SQL, it doesn't display the table name like it used to in Rapid SQL 7.5.5.	Oracle
RAP-5749	[SQL Execution] Error "Program encountered unexpected token '"COR"' when running the explain plan	Oracle
RAP-5753	[Connectivity] unable to use "Use TNS Alias option" as it generates an error.	Oracle
RAP-5754	[Application] Process does not terminate and unable to restart a new session until process is killed.	Oracle
RAP-5773	Slow performance when opening a new ISQL	Oracle
RAP-5786	[Datasource Explorer] object count for packages is displayed as 24000	Oracle
RAP-2851	RS740 3214: Can't create Identity column with bigint datatype in SQL Server	SQL Server
RAP-5350	Execution of Stored Procedure with data type NVARCHAR shows NULL in results for that data type column	SQL Server
RAP-3478	When exiting the application, receive error: "The instruction at "0xb6d63e3e" referenced memory at "0xb6d63e3e". The memory could not be "read".	Sybase ASE
RAP-3753	Frequent crashes occur after extracting a proc or table as well as when doing a copy and paste	Sybase ASE
RAP-3890	"Failed to create a connection. Url or driver class may be incorrect Invalid pointer." when using Embarcadero Sybase JDBC driver	Sybase ASE
RAP-4435	When closes Rapid SQL, user gets error: run-time error in Visual C++ R6025 pure virtual function call	Sybase ASE
RAP-4450	Getting reference memory location error after running a select query	Sybase ASE
RAP-4741	Copying certain data values from a query results screen causes extra data to be selected	Sybase ASE

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.