Rapid SQL ReadMe Welcome to Rapid SQL® XE 3 and Rapid SQL® 8.1.1 ReadMe Last Published: June 18, 2012. Any updates to these notes will be available at. 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 3/8.1 DBMS Support and Connectivity Release Notes Additional Resources What's New in Version XE 3/8.1 Sybase IQ Support This release introduces support for Sybasse IQ, Sybase's column-oriented DBMS. This release will offer the following:. The ability to register and connect to Sybase IQ datasources.
Explorer visibility of the following elements: DBSpaces, Domains, Foreign Keys, Functions, Groups, Indexes, Join Indexes, Primary Keys, Procedures, System Indexes, System Tables, System Triggers, Tables, Triggers, Users, and Views. SQL Editor support Connectivity Updates In previous releases, Rapid SQL connectivity was primarily restricted to native Embarcadero drivers. These proprietary drivers, packaged with Rapid SQL, work in conjunction with a supported set of third-party clients that must be installed. While this remains the default, the Datasource Registration wizard now features a new Connect Using JDBC control that lets you specify a more direct connection that does not require a native client.
Jan 31, 2018 - Download InterBase. InterBase SQL Server — is a databases management system originally developed by Borland Company. On the InterBase XE7 64 Server Manager, start the InterBase server if it is not running. InterBase Client XE7 Update 5. Ensure the InterBase XE7 Update 5 is installed on a. And specify the 'Backup' Filename including the full path (e. Installation, Registration, and Licensing Information for Embarcadero InterBase XE.
With the exception of Interbase/Firebird datasources, one or more Type 4 JDBC drivers for each supported platform are now packaged with Rapid SQL. In addition, a new Generic JDBC DBMS platform selection lets you select and configure a non-packaged, custom JDBC driver of your choice. Rapid SQL queries the selected driver to determine the properties, options, or parameters that the JDBC driver accepts. The Datasource Registration Wizard’s new Custom JDBC Properties panel lets you provide these name/value pairs.
DBMS Version Updates Rapid SQL now provides support for Sybase ASE version 15.5. All current Rapid SQL functionality is now available on this platform version. SQL Editor Updates This release includes the following updates to the SQL Editor. Hyperlink object actions - Hyperlinks let you invoke common or object type-specific object actions against tables, views, functions, procedures, packages, and package bodies referenced in a script. A configurable keystroke combination (default, CTRL+Right-click) opens an object action menu.
Datasource index configuration - the object index used to implement Code Assist features can now be configured. You can control the object types included in the index, the maximum size of the index, and the maximum number of results returned by queries to the index. Updated support for Microsoft SQL Server features Currency updates for this release include:. Enhanced Public Key Encryption Support - Certificate, Asymmetric Key, and Symmetric Key database objects are now offerred.
Dedicated wizards and editors let you create and edit the new objects types. In addition, associated object actions let you add or change a certificate's private key and back up a certificate to file. Updated support for Sybase features Currency updates for this release include:. Proxy Tables - New properties let you specify FOR PROXYUPDATE and DEFAULTLOCATION= parameters when creating a database.
A new Resynchronize action, available against databases defined with the For Proxy Update property selected, forces the resynchronization of proxy tables within the proxy database. Archive databases - A new ARCHIVE Type option and a new Scratch Database property let you generate CREATE ARCHIVE DATABASE DDL and specify a WITH SCRATCHDATABASE value.
Relaxed Durability Databases - A new Durability property of the Database Wizard/Editor lets you control persistence of commited transactions. Selecting one of the FULL, NO RECOVERY, or ATSHUTDOWN options includes a DURABILITY= option in the DDL generated to create or alter the database. In-memory Databases - A new property on the Database Wizard lets you create in-memory databases against a device initialized (DISK INITI) using the inmemory parameter. 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 – Job Queues. Sybase – Segments 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. Sptempdb 'bind', 'lg', ', 'DB', '.
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.