Welcome to Rapid SQL® XE 2 and Rapid SQL® 8.0
Rapid SQL Home | Rapid SQL Documentation | Embarcadero Technical Support | www.embarcadero.com
ReadMe Last Published: May 26, 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:
- 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 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/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.