Released: Mar 28, 2014

Updates in this release

Updates in XE5

• 64-bit Installation - Rapid SQL now runs as a native 64-bit application. Separate installers let you choose between 32 and 64-bit applications.
• Windows 8 Support - Rapid SQL is now fully supported on the Windows 8 operating system.
• Teradata - Rapid SQL provides support for Teradata versions 13.10, 14, and 14.10.
• SQL Editor - Execution against Teradata sources is available along with related, common SQL Editor tools such as Query Options, Paste SQL Syntax and Paste SQL Statement.
• DBMS Support - As of this release, Rapid SQL provides full support for IBM DB2 LUW version 10,  IBM DB2 z/OS version 10, Oracle 12c and Sybase ASE 15.7.
• SQL Server Updates - Rapid SQL now supports the sequence object type, introduced with SQL Server version 12. A creation wizard, editor and a basic set of object actions are provided.
• DB2 LUW Updates - The Update Statistics object action has been updated to use the ADMIN_CMD system procedure. This eliminates the constraint of having target datasources registered by alias and using the native client. Update Statistics can now be used against all datasources, regardless of how they were registered.
• Sybase ASE Updates - Against version 15.7 datasources, the Login Wizard/Editor now generates DDL that uses CREATE/ALTER LOGIN syntax. New properties let you work with SUID, LOGIN PROFILE, and EXEMPT INACTIVE LOCK parameters.
• Oracle Updates - If the Oracle SQL*Net Client is not installed, Rapid SQL will attempt to connect to an Oracle datasource using the Oracle Database Instant Client.
• Query Builder - As of this release, when you add the same table to the diagram pane multiple times, a new alias is automatically assigned to each instance. Adding a table multiple times can be useful when selecting additional data from the table, based on different join criteria.