Rapid SQL Home | Rapid SQL Documentation | Embarcadero Technical Support | www.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 7.6
Oracle Graphical Query Plan support
Release Notes
DBMS Versions No Longer Supported
Additional Resources
Licensing Your Embarcadero Product
Embarcadero Technologies Product Support
Embarcadero Technologies Technical Support
Embarcadero Technologies on the Web
What's New in Version 7.6
Expanded Unicode/XML Support
Support for XML has been expanded for release 7.6. XML parameters can now be passed to stored procedures and DBMS-specific upgrades include:
Similarly, support for Unicode has been expanded for release 7.6. Previously only supported in the Text editor, now the Results grid and Data editor support Unicode characters. Datatypes that can be displayed or entered differ according to the DBMS platform.
Expanded DBMS support
Rapid SQL now provides support for Microsoft SQL Server 2008 and Sybase 15.0.2. This Rapid SQL release also introduces support for Sybase Cluster Edition.
Oracle Graphical Query Plan support
Graphical Query Plan support, previously provided for other DBMS is now available for Oracle. With the ISQL editor in Show Plan, executing a script now displays a graphical representation of the query plan for the script. You can drill down to view details on individual steps, toggle between graphical and tree-based views, and make use of a number of viewing options.
User Interface improvements
For 7.6, Embarcadero continues to revamp the Object Editors and Wizards. The look and feel is geared to improving consistency, presentation, and expanded feature support. The 7.6 release also offers greater control over toolbar display and a revamped Options editor that speeds up navigation.
Additional Currency Features
As with other releases of Rapid SQL, Embarcadero has responded to customer requests for additional or improved feature support. General improvements include Vista support upgrades and virtualized Text editor content. DBMS-specific upgrades include the following:
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 LUWServer: 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.
Microsoft SQL ServerServer: 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
MySQLServer: 4.x
Client: MySQL ODBC driver 3.5.1 - 4.x.
OracleServer: Oracle 8i, 9i, 10g, and 11g.
Client: Oracle SQL*Net Client
Sybase ASEServer: 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 version 7.6.
IMPORTANT ADVISORY NOTES
There are no important advisory notes for this release.
KNOWN ISSUES
BUG FIXES
| Bugs Fixed in Embarcadero Rapid SQL 7.6.2 | ||
|---|---|---|
| DBA-15495 | 'Resize rows' in results grid for a row with lots of data doesn't have any effect on the row | ALL |
| RAP-5295 | Associates files are opening automatically when application starts or open one sql file on Vista Enterprise | ALL |
| RAP-5304 | User needs to run Rapid SQL 7.6.0 and DBArtisan 8.6.1 at the same time on one machine | ALL |
| DBA-17789 | When doing a right click ->extract the constraints are in the wrong order | DB2 |
| DBA-16182 | The DDL for dropping a Unique Key from outside the editor is incomplete on OS390 datasources. | DB2 z/OS |
| RAP-5063 | Rapid SQL gives no result when user run any query in Vista | DB2 z/OS |
| DBA-16910 | "populateCollectionAtributes() failed to populate for object type Table" error when opening the editor of a table or its dependencies editor | Oracle |
| RAP-5007 | Application adding extra two lines of code after a package - SQL log shows ORA-00942: table or view does not exist | Oracle |
| RAP-5293 | RS760 3370: Error during object population. Type=View on Oracle when trying to display views | Oracle |
| RAP-5301 | After upgrade from Rapid SQL 7.5.5 to 7.6.0, user get error:Unable to execute procedure. ORA-00942 table or view does not exist when execute an Oracle stored procedure | Oracle |
| RAP-5363 | Select star from expands the query against oracle. | Oracle |
| RAP-5083 | Error during object population. Type = table error after upgrading to RS755 and trying to view code for any SQL 2K table. | SQL Server |
| RAP-5211 | Script generated in Rapid SQL did not put in a command to turn off quoted identifiers. The same script generated in DBArtisan is correct. | SQL Server |
| RAP-5245 | VIEW_EXTRACT: Long View DDL not extract fully and is truncated. | SQL Server |
| DBA-15311 | An error appears when I try to drop a User Message on a Sybase datasource | Sybase |
| DBA-16520 | "The object dependencies are not fully loaded" error when extracting tables on Sybase 12.5.4 | Sybase |
| DBA-17239 | Errors appear when extracting objects using Schema extraction on Sybase | Sybase |
| DBA-17249 | Error during object population type = table appears when extracting tables linked by Logical Foreign keys on Sybase | Sybase |
| RAP-5066 | Drop statements are being generated at the top of an SQL file when performing an extract | Sybase |
| Bugs Fixed in Embarcadero Rapid SQL 7.6.1 | ||
|---|---|---|
| RAP-4921 | Compile error message when a Stored Procedure is used to call another stored procedure | DB2 |
| RAP-4993 | In Query Builder, adding a field after delete a Join causes "Debug Error!" and Rapid SQL crashes | DB2 z/OS |
| RAP-5056 | Role tab when open User doesn't show roles assigned to the user. Error message PopulateCollectionAttributes() failed to populate object type ROLE | Oracle |
| RAP-5078 | After user set the option Organize by Object Owner for the Explorer, it takes a long time to long into a datasource( sometimes over one minute), but Organize by Object Type is fine | Oracle |
| RAP-5101 | Rapid SQL assumes no old password verification is needed when user changes password | Oracle |
| RAP-5103 | Not be able to change password for new user created using Create Like consistently | Oracle |
| RAP-5209 | Rapid SQL hanging when the Explorer viewing option is set to Organize by Owner | Oracle |
| RAP-5247 | When browsing roles, an user that inherits a DBA privilege through a role is warned that he needs DBA privileges | Oracle |
| RAP-5265 | When trying to debug a procedure that has null as the default value and choosing default in the parameter selection section, you get an error stating that the procedure is expecting a parameter | SQL Server |
| RAP-1696 | Sybase Debugger: be able to see the data in a temp table that a stored procedure called | Sybase |
| RAP-5086 | Can't open a view with a NULL value for the column name. The view was created in a Rapid SQL SQL session on Sybase 12.5 | Sybase |
| RAP-5114 | Trigger status is always shown enabled in Status window | Sybase |
| Bugs Fixed in Embarcadero Rapid SQL 7.6 | ||
|---|---|---|
| RAP-3966 | [7.4.2#3275] - SQL_EDITOR: Entering single or double quote in Dutch language = repeat character | All |
| RAP-4577 | When defining keystrokes and setting the Accelerator for "Default", the new key is accepted but pressing it does nothing | All |
| RAP-4606 | RapidSQL crashes when executing the command to extract the code. | All |
| RAP-4620 | 7.5.0#3363 - Error when attempting to view table SQL that contains unichar/univarchar columns. | All |
| RAP-4660 | Receive runtime error when closing results windows of queries while running a query | All |
| RAP-4795 | Support for Unicode characters to be displayed | All |
| RAP-4837 | Saving results in .txt format results in double quotas around dates. | All |
| RAP-4875 | Installing Rapid SQL onto a machine with Office 2007 generates a 2878 error on some systems | All |
| RAP-4921 | Compile error message when a Stored Procedure is used to call another stored procedure | All |
| RAP-5081 | Clicking on "replace all" in the "Find and replace box" causes the application start to blink and crash | All |
| RAP-5220 | Autocommit option cannot be changed in the same ISQL session for Oracle and DB2 | All |
| RAP-4828 | Reordering columns feature not working properly | DB2 |
| RAP-4857 | After upgrading from RS734 to RS752 creating a new DB2 function doesn't contain the Begin Atomic or End statements | DB2 |
| RAP-4860 | Extraction changes the dashes in the code to question marks | DB2 |
| RAP-4920 | Error during object population type=procedure when open a procedure on a 64bits machine | DB2 |
| RAP-5186 | Double quotas generated on DB2 and Zos platforms in the Query Builder Editor's script file. | DB2 |
| RAP-4598 | DB2 queries with "--:" comments fail with error message | DB2 Z/OS |
| RAP-5062 | Unable to open saved parameter file. Error "Unknown error while reading parameter file" occurs | DB2 Z/OS |
| RAP-2707 | When a table with XMLtype column is queried, result does not show XML | Oracle |
| RAP-3496 | When exploring an Oracle database, it does not show a package in red if it has an error until you explorer through the package to the error | Oracle |
| RAP-3977 | The syntax checker does not recognise pls_integer | Oracle |
| RAP-4525 | RSQL 750#3358: When trying to view 'Type Specification' for a type, an error message 'Error during object population. Type = TYPE' appears for Oracle 9i/10g | Oracle |
| RAP-4594 | [7.5.0#3363] - C++ Crash | Oracle |
| RAP-4641 | Rapid SQL crashes when trying to use code analyst | Oracle |
| RAP-4832 | Insert command and import from data file generates "out of memory error" | Oracle |
| RAP-4995 | Search for a table which should be in multiple package bodies. The search found nothing | Oracle |
| RAP-5039 | Debugger opens an empty ISQL window when user go to Packeage > Procedure > right click to debug in explore window | Oracle |
| RAP-5061 | After opening a package and clicking on Body tab, no any content shows up | Oracle |
| RAP-5065 | Not be able to see Package Bodies listed, when DBA view is selected | Oracle |
| RAP-5079 | Customer suggests parameters are out of order and not named when generating an anonymous block for a funcion within a package | Oracle |
| RAP-5185 | Application crashes when trying to view Space tab in the Tablespace editor on Oracle servers | Oracle |
| RAP-5206 | Crash occurs when creating a Partition with partition type "HASH" on an Index / Primary Key / Unique Key on Oracle. | Oracle |
| RAP-2793 | RS74 3214 BUG: Unable to clear the Command History in an ISQL window | SQL Server |
| RAP-4227 | Roles code window error- "Error during object population. Type = ROLE" | SQL Server |
| RAP-4530 | Uncheck Expand Tab option causes Column Auto Lookup not function properly | SQL Server |
| RAP-4618 | After searching for database, not all results returned, such as comments | SQL Server |
| RAP-4723 | [7.5.1] - Database Search - Failed to find string *= | SQL Server |
| RAP-4998 | Altering SQL Svr 2K table with constraints fails after upgrading to RS754 | SQL Server |
| RAP-5006 | Database search does not work after upgrade from RS741 to RS754 | SQL Server |
| RAP-5044 | After upgrading from RS754 to RS755 - Database Search error when searching Store Procedures - No SQL parameter found for that translator property. Cannot filter on that attribute. | SQL Server |
| RAP-5201 | Application crashes when debugging some encrypted procedures on SQL Server 2000 | SQL Server |
| RAP-4459 | Cannot sort a result set if the datatype of the column is text in Sybase datasource | Sybase |
| RAP-4610 | [7.5.0#3363] - Customer is not able to view the data of univarchar columns in queries | Sybase |
| RAP-4800 | When you click on the Code to generate create index statement, it is missing | Sybase |
| RAP-4801 | Old errors are not being removed from the errors window | Sybase |
| RAP-4987 | "Error during object population. Type = (object) " when open a table, stored procedure or trigger in Sybase if not log in as "sa" | Sybase |
| RAP-5022 | When extract DDL for View in Database Search result, no DROP before create view statement, even though include DROP is checked in Options | Sybase |
| RAP-5005 | Not all constraints are showing up in table extract | Sybase |
| RAP-5064 | Sybase stored procedure extraction pulls out incorrect DDL and the HTML report of the procedure has incorrect DDL also | Sybase |
| RAP-5165 | Rapid crashes when deleting a column in the results view | 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.