Rapid SQL ReadMe

Welcome to Rapid SQL® XE 2 and Rapid SQL® 8.0.1

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

ReadMe Last Published: Sept. 21, 2011. 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 2/8.0

Unicode Updates

Datasource/Server Updates

Updated support for Oracle features

Updated support for Microsoft SQL Server 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 XE 2/8.0

Unicode Updates

Unicode character-handling has been improved in the ISQL Editor and Data Editor. This includes:

Improved encoding detection and options when saving and opening files
Additional UTF-8, UTF-16, and UTF32 encodings with BOM and endian variations are now available
Handling of surrogate pairs and characters made up of multiple unicode (LTR scripts only) have been brought in line with Windows Vista and Windows 7 support.

Datasource/Server Updates

Updates in the category include:

JDBC Driver Availability - When registering or editing datasources, most third-party JDBC driver options are no longer available. InterBase datasources are the only exception.
Current Session Role Activation - For Oracle and Sybase datasources, you can now activate and deactivate roles for the current login or user within the current session.

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

Rapid SQL now provides support for version 9.7

Updated support for Microsoft SQL Server features

SQL Server currency updates for this release include:

Synonym support lets you create one-part object names used in SQL statements to reference a partially-qualified to fully-qualified, multi-part object names.
Partitioning is now supported for tables and indexes. In support, two new object types are also now available: Partition Schmes and Partition Functions.
Full-text Search object types, Full-text Catalogs and Full-text Indexes, are now available. A set of associated object actions let you rebuild catalogs, merge smaller indexes, enable and disable indexes, and provide native control options for index population.
DBArtisan now provides support for Database Triggers, triggers that fire in response to DDL events. A full set of creation wizards, editors, and object operations are provided.

Updated support for Oracle features

Oracle currency updates for this release include:

The Reorganize operation, applied to a table, can now be executed online. This allows access to table data while the reorganization is in progress.
Oracle's Recycle Bin lets you store dropped objects until they are explicitly purged. The Recycle Bin is now available as a datasource node. Expanding that node displays dropped objects in the Database Explorer. Associated object actions offer purge, recover, and query options. You can enable and disable the Recycle Bin at the datasource level.
For Oracle 11g datasources, the Index Wizard and Index Editor now have Invisible properties. Invisible indexes are not used by the optimizer during queries unless the OPTIMIZER_USE_INVISIBLE_INDEXES parameter is set to TRUE at the session or system level.
Also against Oracle 11g datasources, Rapid SQL now supports virtual columns. When defining a column in the Table Editor, you can use the new Virtual property to define a column as virtual. You then use the Default Value control to enter a column expression that calculates the value of the virtual column.
Temporary tablespaces can now be assigned to temporary tablespace groups (SYS.DBA_TABLESPACE_GROUPS).
A new Change Access Status action lets you toggle a table between READ ONLY and READ WRITE modes.
The Partition tab for a partitioned Oracle index now displays whether Oracle has marked a partition definition as unusable.
The Analyze object action now offers options corresponding to the following DBMS_STATS package procedure calls: DBMS_STATS.GATHER_INDEX_STATS, DBMS_STATS.GATHER_TABLE_STATS, DBMS_STATS.DELETE_INDEX_STATS, DBMS_STATS.DELETE_TABLE_STATS, DBMS_STATS.IMPORT_INDEX_STATS, and DBMS_STATS.IMPORT_TABLE_STATS.

Updated support for Sybase features

Sybase currency updates for this release include:

Two new object actions (Add/Modify Login Trigger and Drop Login Trigger) let you configure login triggers for a login. The name of the configured login trigger is now available in the Login Editor.
The new Hide Text operation provides sp_hidetext call support, letting you hide source text of compiled objects. It can be applied to check constraints, databases, defaults, extended procedures, functions, procedures, rules, tables, triggers, users, and views
User-defined function object support includes a creation wizard, an editor, and basic object operations.
Trigger support now includes views as a parent type. The Trigger Wizard generates INSTEAD OF trigger syntax for these triggers.
A full range of show... Set Option command variations now lets you generate diagnostic output in text format.

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 – Tablespaces
SQL Server – Logins
Sybase – Logins, Groups, User Messages

Release Notes

DBMS SUPPORT

IBM DB2 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 for LUW

Server: IBM DB2 LUW Versions 8.0 - 9.7

Client: IBM DB2 LUW Client for Windows 7.0 or later. When using a v8 client, DBArtisan 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 ASE 12.5 - 15.0.3

Client: Sybase Open Client

DBMS VERSIONS NO LONGER SUPPORTED

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

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.0.1/XE 2
Issue #	Description	DBMS
RAP-4256	Rapid SQL crashes	All
RAP-5000	Indexes are not included in the extract of a system table	All
RAP-5615	[Procedure][Execute] The saved parameters are not loaded correctly	DB2
RAP-5684	[Tools] Unable to get the Database Search function working with DB2	DB2
RAP-4104	Code Collapse not folding code in correct blocks	Oracle
RAP-5654	[Code Complete]Not all columns are prefixed when using an alias and selecting all the columns	Oracle
RAP-5663	[SQL Execution] Running script will cause application to quit	Oracle
RAP-5687	Error when attempting to schedule query from SQL Editor, Etsql.exe Has Encountered a Problem	Oracle
RAP-5059	The Column Names are not displayed in the Result tab of the Query Builder on a Sybase 12.5 datasource	Sybase
RAP-5697	[Tools] Database Searches fail to find the selected text.	Sybase
RAP-5700	[SQL Editor] Column not auto-expanding when multiple special characters are in a varchar	Sybase

Bugs Fixed in Embarcadero Rapid SQL 8.0/XE 2
Issue #	Description	DBMS
RAP-3899	Microsoft Visual C++ Runtime Library: RSQL742.exe - Application Error	All
RAP-4277	Rapid SQL crashes	All
RAP-4491	Randomly crashed	All
RAP-4559	When UAC (User Access Control) on Windows Vista feature is on, programs have to request Administrative Privileges before they can write to certain areas on the hard drive	All
RAP-5075	After uninstall Rapid SQL, un-removed registries prevent new installation from installing on the same machine	All
RAP-5312	After upgrade from Rapid SQL 7.5.5 to 7.6.0, previously opened sql files before exist no longer show up after user re-launches Rapid SQL	All
RAP-5603	[Application] Starting up Rapid SQL File -> Recent projects only lists recent project list.	All
RAP-4650	An unknown folder in C:\Documents and Settings on user's computer	Oracle
RAP-4717	When clicking on the Value field for a datetime parameter (when debugging an Oracle procedure), the implicit value is '30/11/1999' and not the current date as in 742	Oracle
RAP-5216	Primary key script is not shown when creating a table with a script in ISQL	Oracle
RAP-5313	Table names, functions, synonyms and other objects are all displayed as question marks or blank	Oracle

RAP-5360	Query result set returns with 1st 3 of 4 columns blank	Oracle
RAP-5559	Leaves empty lines between logical lines/code blocks. When opens procedure, it has removed the empty lines	Oracle
RAP-5610	When decreasing the width of a number column, Rapid SQL reports that changes have been undone. Thus no changes to apply	Oracle
RAP-5641	[Datasource Explorer] The Materialized Views node is not populated when the Explorer is organized by object owner	Oracle
RAP-5642	[DBMS Object Management] The extract for materialized views containing lob definition is incorrect	Oracle
RAP-5648	SQL Editor] Re-executing dbms_output.put_line query does not bring back results	Oracle
RAP-4340	Project Reverse Engineering Wizard, step 3 of 5 missing FUNCTIONS from database object list	SQL Server
RAP-5037	SQL output from Project Build has NULL characters between every letter	SQL Server
RAP-5467	Extraction of Stored Procedures on particular server gives a blank results	SQL Server
RAP-2496	BUG: Rapid SQL does not display Double Byte Character set correctly	Sybase
RAP-4451	After I open a sql window, I no longer get the Groups, Logins, Users, etc access - is this on purpose?	Sybase
RAP-4738	Rapid SQL crashes during launch time	Sybase
RAP-5047	Windows 2K users can't find keystroke that allows the selected column name to be entered when using auto-col lookup feature	Sybase
RAP-5490	[Edit>Find] - {Ctrl+F} - Slower than previous release when searching result output	Sybase
RAP-5506	[Code Assist] Auto Complete Replaces Text After Insertion Point	Sybase
RAP-5512	[ISQL] [Performance] [Results] Performance issue when performing a SELECT from a table with 30k~ rows	Sybase
RAP-5574	Code Analyst - If I click on Unit Profiled Time I can't uncheck it after	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.