DBArtisan ReadMe

Welcome to DBArtisan® XE3.5 and DBArtisan® 9.2

DBArtisan Home | DBArtisan Documentation | Embarcadero Technical Support | www.embarcadero.com

ReadMe Last Published: February 19, 2012. Any updates to these notes will be available at http://docs.embarcadero.com.

Thank you for using Embarcadero DBArtisan, the award winning DBA tool for enterprise-wide database administration. DBArtisan empowers you to manage all of your critical databases running on current versions of Oracle, SQL Server, MySQL, Sybase ASE, and IBM DB2 across the UNIX, Linux, Windows NT and mainframe z/OS operating systems, from a single, consistent, user-friendly interface. Before you use DBArtisan, please read the information below.

What's New in Version 9.2/XE3.5

Updated support for IBM DB2 (LUW and z/OS) features

Updated support for IBM DB2 for Linux, Unix, and Windows features

Updated support for Oracle features

Updated support for Microsoft SQL Server features

Updated support for Sybase IQ features

DBMS Support and Connectivity

Dedicated Support Connectivity Options

Generic JDBC/ODBC Connectivity

DBMS Versions No Longer Supported

Release 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 9.2/XE3.5

Lockdown Mode

Registry location HKLM\Software\Embarcadero\DBArtisan\Admin now has the following entries that let you restrict certain fatures:

RestrictedPlatforms (REG_SZ) - takes a comma-separated list (db2=0,mssqlserver=1, for example) dictating DBMS platform support on the machine. Valid names for the name=value pairs are db2, os390, mssqlserver, mysql, oracle, sybase, mssqlazure, odbc, jdbc, and sybaseiq. Any non-zero value for a name=value pair results in that platform not being available to DBArtisan on that machine.
DisableAutoConnect (REG_DWORD) - When set to any non-zero value, users cannot use the auto-connect feature when registering or logging in to a datasource.
SharedDatasourceCatalogPath (REG_SZ) - Providing a path to the network shared datasource catalog forces DBArtisan to use that datasource catalog storage option. Registry-based and file-based catalog storage will be unavailable on this machine.

Connectivity Updates

Generic JDBC/ODBC Connectivity - DBArtisan now support generic JDBC/ODBC connectivity to non-dedicated DBMS systems or non-database datasources. DBArtisan can connect to a datasource using a customer-provided, third-party JDBC version 3.0 or ODBC version 3.0 driver. Minimal DBArtisan functionality is provided, including a basic Explorer tree and SQL querying.
LDAP Support - When using the Discover Datasources feature or manually registering a datasource, DBArtisan will now search an LDAP server for datasources. The Options Editor now lets you provide details you need to connect to an LDAP Server.
ODBC Connectivity to Sybase IQ Datasources - For connectivity to Sybase IQ datasources, DBArtisan/Rapid SQL now supports the following ODBC drivers:
- SQL Anywhere ODBC drivers for Sybase IQ 12.7
- Sybase IQ 32-bit ODBC drivers
Discover Datasources Detection of Toad datasources - You can now import definitions from the following Quest Software products:
- Toad for MySQL
- Toad for Oracle
- Toad for SQL Server
- Toad for Sybase (ASE and IQ)
The Discover Datasources feature will automatically search registration files for datasource definitions and offer you the option to register any datasources found.
Other Discover Datasource updates - The Discover Datasources dialog now displays Discovery Source (LOCAL ALIAS, NETWORK, LDAP, or TOAD) and Status fields for each discovered datasource.

UI/Explorer Updates

The Datasource Navigator - An alternative to the Datasource Explorer, the Navigator is a single pane window that lets you navigate datasources, drill down to the object level, and initiate actions. It includes a control that gives you greater control over the active datasource, useful when working with the SQL Editor, Query Builder, and other features for which an active or default datasource is relevant.
Column Filtering Using Regular Expressions - When database objects are displayed in the right-hand pane of the Explorer, column filtering now lets you qualify displayed objects using regular expressions.
This feature must be enabled. The Options Editor’s Explorer pane has a Column filters use regular expressions by default control that enables regular expression usage when DBArtisan starts or a new Explorer is manually opened. In addition a REGEX On/REGEX Off button in the status bar lets you toggle the feature on an off for a particular window.
Locked/unlocked User and Login Icons - Depending on the DBMS platform, the icons associated with logins and users differ according to the account’s locked or unlocked state, when viewed in the Explorer.

SQL Editor Updates

Code Snippet Execution - You can now execute an individual statement where statments in a script are terminated with a valid delimiter (; or /). The Execute Statement command is available from the Query menu and as a right-click option.

Bind Variable Parameterization in Prepared Statements (Dynamic SQL) - DBArtisan lets you provide bind variable values when executing scripts containing prepared statements. In scripts, DBArtisan recognizes named or unnamed variables that use the following notation:

DBMS Platform/Driver Type	Notation
Oracle with native driver	:name or :number
Oracle With JDBC driver	?
All other platforms/drivers	?

Support for bind variables is enabled on a editor window-by-editor window basis. Bind variable parameterization is enabled by setting the Prepare Batch Query Option, available on all DBMS platforms. For an enabled SQL Editor window, when using execution options, whenever a statement containing bind variable notation is encountered, a Bind Variables dialog opens. For each bind variable in the current stement, the dialog lets you specify:

A type
An IN, OUT, or INOUT designation for elements such as function or procedure parameters or arguments, variables used in INTO clauses of an INSERT statements and variables used in RETURNING clauses of an Update statements.
A value

You can then execute, skip the statement, or abort execution for the currently running script.

Command Line Startup

This release introduces command line startup of DBArtisan with switches letting you specify a datasource and credentials:

dbart.exe -D datasource -U username -P password

This is primarily aimed at identity management systems working in conjunction with DBArtisan. Such systems can be configured to start DBArtisan and connect to a specific datasource using credentials that are invisible to the user. Other applications that hide credentials, force connection to a specific datasource, or otherwise automate startup of DBArtisan can make use of this feature.

Updated support for IBM DB2 (LUW and z/OS) features

Temporal Tables - The Tables Wizard now has a Temporal Properties panel. It lets you include attributes that indicate when data in a row is current and when transactions affected the data. Tables can be designated as system-period or application-period tables. In addition, the Columns panel now includes settings that let you properly specify row-begin, row-end, and transaction start ID columns. In addition, the Primary Key Wizard and Unique Key Wizard have been updated to facilitate temporal tables. A new Time period policy property lets you create a constraint on a business-time table that can enforce uniqueness of the data for any point in business time.

Updated support for IBM DB2 for Linux, Unix, and Windows features

Command Line Processor Export Support - Against 9.7 datasources, an Export utility is now available. It lets you export data to one of several external file formats. The CLP Export Wizard lets you select an output file format (IXF, DEL, or WSF), specify a set of modifiers relevant to each format, provide LOB and XML handling details, and select a SELECT/XQUERY, default traversal, or user-specified traversal export. The Wizard generates two db2.exe calls: one to connect to the database and one to issue the export directive.
Lowering the High Water Mark in Tablespaces - The Lower High Water Mark object action lets you reduce the size of existing containers.
Moving Table Data Online - A new Move Table object action lets you build and submit a SYSPROC.ADMIN_MOVE_TABLE call, letting you move data in an active table into a new, identically-named table, leaving the data online and available for use.
Storage Path and Container-based Tablespace Actions - Two new tablespace actions are now available. Rebalance lets you create containers on recently added storage paths and drop containers from storage paths that are in DROP PENDING state. Drop Automatic Storage Paths removes one or more storage paths with an optional REBALANCE operation.
Index Compression - The Index Wizard and Index Editor now include a Compress property. This controls whether a COMPRESS YES clause is added to the generated CREATE/ALTER INDEX statement, enabling index compression.

Updated support for Oracle features

Data Pump Import/Export - You can now make calls to the expdp.exe and impdp.exe utilities from DBArtisan. Wizards available from the Utilities menu let you specify a full set of parameters. In addition, you can execute the utilities from the wizard or using a command line call specifying an automatically-generated parameters file.
Compound Trigger Support - The Oracle Trigger Wizard’s Trigger Timing property now offers a COMPOUND option, letting you create compound triggers. As an aid, when you select this option, the Action tab is automatically populated with a compound trigger block template. The CREATE OR REPLACE TRIGGER... DDL generated for the trigger built using these options includes the compound trigger-specific FOR clause.
Enable/Disable Trigger Support - A new Change Status object action lets you enable or disable one or more triggers.

Updated support for Microsoft SQL Server features

User and Login Permissions Updates - When creating and editing users, you now have access to permission-related functionality introduced since Microsoft SQL Server 2000. In addition, the SQL Server Logins Editor, has been updated to let you assign object and system permissions to a login.

Updated support for Sybase IQ features

Schema Extraction/Migration - The Schema Extraction and Schema Migration Wizards are now available against Sybase IQ datasources.
Tools Menu Command Availability - The Script Execution Facility, File Execution Facility, Database Search, Visual Diff..., and Import Data commands are now available for the Sybase IQ platform.
Remote Server Object Types - Remote Server objects are now available under the Security node for Sybase IQ datasources. As with other Sybase IQ object types, Drop and Extract object actions are available.
DDL Extract Options - You now have more control over Extract operations. The Options Editor now includes a DDL Extract > Sybase IQ panel. As for other platforms, this panel lets you specify the object types to include DROP statements for and the default dependent object types for each object type included in extract operations
Server Node Properties - The Datasource Explorer now offers Server and Configuration nodes for the Sybase IQ DBMS platform. Its Version and Configuration subnodes provide access to server, database, and connection properties as well as configuration/initialization parameters.
Events And Unique Keys Object Types - The Datasource Explorer now offers Sybase IQ Events and Unique Keys object types. A basic set of Drop, Extract, and Migrate actions are supported against unique keys. Those actions, as well as an Object Properties action, are supported against events.

DBMS SUPPORT AND CONNECTIVITY OPTIONS

DEDICATED SUPPORT CONNECTIVITY OPTIONS

DBArtisan provides dedicated connectivity to a specific version range of IBM DB2 for Linux, Unix, and Windows, IBM DB2 for z/OS, Microsoft SQL Server, MySQL, Oracle, and Sybase databases. The following connectivity options are provided:

Native Embarcadero drivers - DBArtisan is packaged with a set of native drivers, each requiring a DBMS-specific client to be installed.
JDBC drivers - DBArtisan 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 DBArtisan, are installed with DBArtisan.

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 that must be installed if using native Embarcadero clients, and the third-party, Type 4 JDBC drivers packaged with DBArtisan.

DBMS Platform Supported Versions Client Required for use with native Embarcadero drivers Packaged JDBC Driver

IBM DB2 for z/OS v8 and v9 DB2 UDB Client for Windows 8.0 or later IBM Data Server Driver for JDBC

IBM DB2 for LUW Versions 9.0 - 9.7 IBM DB2 LUW Client for Windows 8.0 or later IBM Data Server Driver for JDBC

Microsoft SQL Server 2005 (All editions including 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64)
2008
2012
Microsoft SQL Server Client Library jTDS Type 4 JDBC Driver for Microsoft SQL Server
Microsoft SQL Server JDBC Driver

MySQL 4.x MySQL Connector/ODBC Driver 5.2.x Driver - MySQL Connector/ODBC driver 3.51.x Driver MySQL Connector/J JDBC Driver

Oracle Oracle 9i, 10g, and 11g Oracle SQL*Net Client Oracle JDBC Thin Driver

Sybase ASE Sybase System 12.5 - Sybase 15.5 Sybase Open Client jTDS Type 4 JDBC Driver for Microsoft SQL Server
Sybase jConnect JDBC Driver

Sybase IQ 12.7 - 15.4 SQL Anywhere ODBC drivers for Sybase IQ 12.7
Sybase IQ 32-bit ODBC drivers
Sybase jConnect JDBC Driver for Sybase IQ

DBMS Platform	Supported Versions	Client Required for use with native Embarcadero drivers	Packaged JDBC Driver
IBM DB2 for z/OS	v8 and v9	DB2 UDB Client for Windows 8.0 or later	IBM Data Server Driver for JDBC
IBM DB2 for LUW	Versions 9.0 - 9.7	IBM DB2 LUW Client for Windows 8.0 or later	IBM Data Server Driver for JDBC
Microsoft SQL Server	2005 (All editions including 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64) 2008 2012	Microsoft SQL Server Client Library	jTDS Type 4 JDBC Driver for Microsoft SQL Server Microsoft SQL Server JDBC Driver
MySQL	4.x	MySQL Connector/ODBC Driver 5.2.x Driver - MySQL Connector/ODBC driver 3.51.x Driver	MySQL Connector/J JDBC Driver
Oracle	Oracle 9i, 10g, and 11g	*Oracle SQLNet Client**	Oracle JDBC Thin Driver
Sybase ASE	Sybase System 12.5 - Sybase 15.5	Sybase Open Client	jTDS Type 4 JDBC Driver for Microsoft SQL Server Sybase jConnect JDBC Driver
Sybase IQ	12.7 - 15.4	SQL Anywhere ODBC drivers for Sybase IQ 12.7 Sybase IQ 32-bit ODBC drivers	Sybase jConnect JDBC Driver for Sybase IQ

GENERIC JDBC/ODBC CONNECTIVITY

Generic JDBC/ODBC connectivity to non-dedicated DBMS systems or non-database datasources is also provided. DBArtisan can connect to a datasource using a customer-provided, third-party JDBC version 3.0 or ODBC version 3.0 driver. Minimal DBArtisan functionality is provided, including a basic Explorer tree and SQL querying.

DBMS VERSIONS NO LONGER SUPPORTED

As of this release, DBArtisan is no longer tested against Microsoft SQL Server 2000 or IBM DB2 for Linux, Unix, and Windows 8.x.

Release Notes

KNOWN ISSUES

The current version of DBArtisan does not support the MySQL ODBC client that shipped with previous versions of DBArtisan. If DBArtisan crashes after connecting to a MySQL data source:

Close DBArtisan.
Uninstall the older MySQL ODBC client.
Restart DBArtisan 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, DBartisan 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 DBArtisan, will result in procedures A2 and A3 being invalidated.

In some situations the Database Monitor may prompt to connect to an already connected datasource if auto-connect is not enabled for that datasource

DBArtisan installs the incorrect stored procedures for Capacity Analyst for a Sybase 15 database. Please refer to this Knowledge Base article: www.embarcadero.com/jive/entry.jspa?externalID=1030&caID=2

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.

The SQL Server Agent failing problem is caused by the lack of permission to enumerate the status of the server service. To determine the status of the server, the user must have permission to check the status of the server service. If the user running DBArtisan at the client machine is a not a local user who can be authenticated at the server machine, the Server Agent jobs will fail.
Workaround:
a. If the user that runs DBArtisan is not a domain user, create the same user with the same password on the server.
b. If the user is a domain user, make sure the user can login to the server.

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

The BCP (bulk copy) data movement option is disabled for cross-platform migration. In addition, to use the BCP in a Sybase-to-Sybase migration, the user must be logged in as System Administrator *or* the "select into/bulkcopy/pllsort" database option must be true on the target catalog. If this option is "false" on the target catalog, BCP will not appear as a data movement option for non-system users.

Schema migration jobs created in earlier versions of DBArtisan that were saved with a .migrate file extension must be re-created in DBArtisan 8.1 or later. Only migration jobs with a .sav extension can be reused.

DBArtisan 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 DBArtisan 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 DBArtisan 9.2/XE3.5
Issue #	Description	DBMS
DBA-2210	The 'OK' button is not getting click after changing the Batch Delimiter in the Query Options window.	All
DBA-7796	DBA810 3097 does not load global tnsnames.ora file located on remote file server	All
DBA-7899	DB811 3125 BUG: Unable to send email notification for a scheduled job in DBartisan if your email client is Outlook 2003.	All
DBA-8049	DB812 3216 BUG The script execution facility output will no longer sort by column header listing	All
DBA-14632	When using Excel 2K to open Excel files created via DB852 the save as feature (in Excel 2K) tries to save the file as a web page. This used to work in DB813	All
DBA-24779	Copy/paste from DBArtisan Log into PFE changes the text format	All
DBA-25096	[SQL EDITOR]Virtual resources are used up when editting a stored procedure	All
DBA-27328	[Application] Saving results set in Excel format when opened in Excel says is in a different format than specified by the file extension.	All
DBA-28239	[ETSQLX] Null values are incorrectly replaced with value 0(zero) for numeric columns when having a job with .xls extension	All
DBA-28286	Change name of table in extract preview dialog.	All
DBA-28734	Use TEMP variable for temporary files	All
DBA-10054	DB2 saves date-timestamps with milliseconds but DBArtisan generates insert statements that ignore the milliseconds	DB2
DBA-11227	Provide an option to change the CURRENT_PATH value for DB2 datasources	DB2
DBA-18981	DB2 UDB DDL Extraction issue with space formatting for a VIEW object	DB2
DBA-20845	[Tables][Edit Data] Inappropriate time is displayed for a TIME data type column on DB2 LUW / OS390 datasource	DB2
DBA-21558	Table Editor: tablespace tab appends the name of the tablespace versus refreshing when you select from the table dropdown to change the table.	DB2
DBA-21626	Getting "SQL2218N One or more parameters specified for the REORG utility is incompatible" when reorganize an index	DB2
DBA-23614	[Connectivity] Unknown database error	DB2
DBA-25745	[SQL Editor][Results] Inconsistent query return results 10-15 second delay at times	DB2
DBA-27840	[Database Objects] Partitioned indexes the indexes are not listed on the indexes tab	DB2
DBA-27917	[DB2][ISQL]Fail to create trigger	DB2
DBA-27922	Extract of DB2 table results in no definition being returned	DB2
DBA-28003	TS : The Select statement generated in the Paste SQL window for a stored procedure does not include the parameters	DB2
DBA-777	DT 37794 - DB811 BUG When doing a schema migration, when migrating triggers, it takes a long time and eventually pops up a java.lang.StackOverflowError	Oracle
DBA-15465	DBArtisan hangs when click on "Object Permissions" tab	Oracle
DBA-22918	[Object Extract][Object DDL View]Slow performance Opening table DDL View and performing extract	Oracle
DBA-23250	[Extract] Extract for Tablespace could not be generated, no datafile information message appears	Oracle
DBA-24512	[Tools] Error when running ETSQLX.exe utility	Oracle
DBA-24784	[SQL Editor][Query Plan] When executed SQL statements contain an error, Query Plan fails to appear and no error is reported	Oracle
DBA-27169	[DBMS Search] Failed to find string in database search	Oracle
DBA-27234	[Instance][ASM][Disk Group]Error opening ASM Disk group ETSQLException: ORA-01468: a predicate may reference only one outer-joined table	Oracle
DBA-27342	TS [Utilities] Error 'IMP-00000: Import terminated unsuccessfully' returned during Database Import execution	Oracle
DBA-27635	[Tablespace] Order by size results don't line up correctly for very large objects	Oracle
DBA-27652	[DB Monitor]Kill Session command in DB Monitor is incorrect for Oracle RAC clustered database	Oracle
DBA-27765	[SQL Execution] Running statements using dbms_output has extraneous characters being displayed.	Oracle
DBA-27880	TS : The Analyze table option does not refresh the table information	Oracle
DBA-28098	[Connectivity]LDAP datasources fail to connect due to error, Alias could not be resolved	Oracle
DBA-28675	TS : Cannot send e-mail notification using Graphical Output in Script Execution Facility	Oracle
DBA-22224	SQL Server to SQL Server table migration fails when the table already exists on the target database.	SQL Server
DBA-24396	[DBMS Object Management] Errors when adding or modifying a SQL Agent job step containing quotes.	SQL Server
DBA-25182	[Utilities] Using wizard to restore a database produces a blank script	SQL Server
DBA-27231	TS: [TRIGGER] The GUI shows that the Trigger Alter works on the second attempt	SQL Server
DBA-27601	[Schema Extraction]The extraction of Logins containing more than one user fails to create the permissions under the correct User	SQL Server
DBA-27614	[Application] When running a detailed report on a table and the field includes a datatype of nvarchar the size of the datatype doubles	SQL Server
DBA-27691	[SQL Execution] EXECUTION ERROR: Incorrect syntax near the keyword 'TRIGGER' and Incorrect syntax near 'ENABLE'	SQL Server
DBA-27881	[Connectivity]Unable to connect to datasource when "Use Network Library Configuration" is enabled	SQL Server
DBA-27882	[Schema Extraction] Viewing and extracting function does not work	SQL Server
DBA-27895	[DBMS Object Management] Error when adding column to table and selecting data type. -- ConnectionDef is required	SQL Server
DBA-28893	TS : Blocking Locks are not populated on MS SQl servers	SQL Server
DBA-29020	[Data Unload] use BCP Utitlity”option does not work	SQL Server
DBA-10290	Not able to change default database or Full Name for user SA under Sybase	Sybase ASE
DBA-10593	SQL Query results with pre-formatting written into the query do not save properly in MS Excel 2000 format	Sybase ASE
DBA-16758	SQL Extract' no longer extracts primary key constraint for views in Sybase	Sybase ASE
DBA-21714	SQL Assist does not handle datepart (calweekofyear...)	Sybase ASE
DBA-22256	An unexpected token "@dboID" was found. Expected DOUBLE_QUOTED_LITERAL	Sybase ASE
DBA-23611	[Database Monitor] The load/refresh on Blocking Locks throws an error after changing the server	Sybase ASE
DBA-24214	[SQL Editor] Application crashes while editing in ISQL window.	Sybase ASE
DBA-25496	[Data Unload Load] Support to run the Sybase BCP utility with Kerberos authentication	Sybase ASE
DBA-26231	[Indexes/UK/PK] Statistics data are not displayed	Sybase ASE
DBA-26551	TS: Unable to deploy Performance Analyst procedures to database when datasource has a different name.	Sybase ASE
DBA-26800	Comments from a procedure are being removed	Sybase ASE
DBA-27518	[DB Monitor] On Sybase 15.7 instance, the 'kill' option is greyed out when SQL Toggle is enabled	Sybase ASE
DBA-27532	[DBMS Object Management] SQL generated when adding space to a database is not in the correct order.	Sybase ASE
DBA-27710	[SQL Editor] Opening Lob data results fails to show complete data	Sybase ASE
DBA-27912	[Sybase]An incorrect default binding is added to a column having a default value from the 'backup' table generated by extended alter	Sybase ASE
DBA-27945	Extract of Sybase Database user does not include sp_addlogin statement.	Sybase ASE
DBA-28110	[SQL Editor] Paste SQL Statement feature is pasting duplicate parameters[SQL Editor] Paste SQL Statement feature is pasting duplicate parameters	Sybase ASE
DBA-28144	[Connection] Error on connection with Sybase jConnect Driver JZ0LA: Failed to instantiate Cipher object. Transformation RSA/NONE/OAEPWithSHA1AndMGF1Padding is not implemented by any of the loaded JCE providers.	Sybase ASE
DBA28411	Results from complex queries are not exported to Excel	Sybase ASE
DBA-28421	Drop of Sybase Device doesn't include "If Exists..." statement.	Sybase ASE
DBA-28699	TS: Extract SQL is not generating the correct DDL for FK	Sybase ASE
DBA-28854	[Role][Extract] Incorrect "use " statement is added to the Extract script when having a default database set different than master - Sybase	Sybase ASE
DBA-28959	Kerberos Principle server should be empty. Do not pre-populate for Sybase connection.	Sybase ASE
DBA-28848	[Sybase IQ] Include storage option is incorrectly applied when performing an ad-hoc migration to Sybase ASE	Sybase IQ

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 DBArtisan 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.