Welcome to Rapid SQL® Version 7.6.4

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

Expanded Unicode/XML Support

SQL Pre-processor

Expanded DBMS support

Oracle Graphical Query Plan support

User Interface improvements

Additional Currency Features

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 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 LUW

Server: 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 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 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


  • 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:
  • 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 7.6.4
    DBA-5338 After upgrade from Rapid 7.5.5 to 7.6.0, user got Unknown Database Error when user clicked on Database icon after connected to a MS SQL Server 2000 datasource regardless default database is Master or not Oracle
    Bugs Fixed in Embarcadero Rapid SQL 7.6.3
    DBA-5379 Query that runs fine in SQL plus and RS740 fails with latest release. Oracle
    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 sales@embarcadero.com, or uk.sales@embarcadero.com 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.