Toad® for Sybase Beta

Version: 2.0

Release Notes

March 20, 2013


Welcome to Toad for Sybase

New in this Release

Resolved Issues and Enhancements

Known Issues

Third Party Known Issues

System Requirements

Global Operations

Getting Started

For More Information


Welcome to Toad for Sybase

With Toad, developers and database administrators can use a familiar, proven tool to manage databases. Toad empowers developers and administrators, of varying skill levels, to rapidly create and execute queries, automate database object management and develop SQL more efficiently.

New in Previous Release

Updates to Toad for Sybase 1.4

Resource Limits

Resource limits allow a system administrator to set parameters to prevent queries and transactions from individual logins or applications from monopolizing server resources. Toad now has the ability to create, alter and drop these resource limits.

Job Scheduler

Job Scheduler gives you the ability to define and schedule database administration and maintenance tasks. You can create and schedule jobs and then share both jobs and schedules. Job Scheduler allows scheduled jobs to run with interaction from the database administrator. Toad now provides editors for creating, altering and dropping these jobs.

Database Device Allocation

Enhanced graphical view of device allocations.

System Filter Object

Apply system object filter for IQ and SQL Anywhere.

Updated performance monitor for Sybase IQ

The performance monitor has been updated to allow for more statistical information.

Schema Compare and Sync across Sybase platforms

There have been various enhancements to Schema Compare and Sync to improve functionality. You can now perform Schema Compare and Sync between Sybase ASE, IQ and SQL Anywhere.

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release.

Feature Resolved Issue Defect ID
Debugger Multiple editors no longer display when you debug a stored procedure. ST104813
Object Details Dependency information now displays when you click on a rule. ST96372
You no longer receive an error when you send a create table script to the editor. ST97255
Object Editor Database objects sort alphabetically by default in Sybase ASE. ST101402
AliasEditForm now displays all available logins in Sybase ASE. ST101404
You no longer receive an error message when you perform the Alter Table function in ASE 12.5. ST104414
Object Explorer Identifier names that are generated outside of the data dictionary no longer contain square brackets. ST96342
Script Generation You can now generate the sp_unbindefault and sp_unbindrule when dropping defaults and rules. ST93041
User Interface The name of the a rule's owner has been added to the sp_bind command. The setuser command displays if the table owner is not the same as the current user ST96367
You can now bind a cache to a specific table (sp_bindcache). ST96369
You can now execute reorg rebuild from the table or index context menu in the object explorer. ST96371  

Resolved Issues and Enhancements in 1.3

Feature Resolved Issue Defect ID
Connection Manager Toad no longer locks up or affects memory when connections timeout or go to sleep. ST102243
Object Editor (DOE) You no longer receive error messages when you login using Sybase 12.5.0 ST103249
The Object Editor now generates an insert statement (Generate SQL | To Editor | Insert) without throwing a System.FormatException for date-based defaults. ST103252
Query Builder A .tsm file now opens correctly when you connect to a database. ST103079

Resolved Issues and Enhancements in 1.2

Feature Resolved Issue Defect ID
Code Completion The Editor can now identify a "Rules" object. ST93552
Connection Manager Fixed issue with having multiple ASE servers on the same machine. ST98322
Export Wizard You can now export a table to SQL Script and Create As New Table. ST91689
ER Diagrammer There is a new Sybase option to enable you to create ER diagram links from an alternate source. ST81162
Object Details (DOV) Use the new RHS tab to display cache bindings. ST95211
Additional attributes of databases, such as status, size, timestamp creation, now display. ST95218
Object Editor (DOE) The Server Options dialog no longer has a category drop-down list. All options display and can be easily filtered when you search for a specific option. ST93582
You can now add roles to logins. ST95212
Object Explorer A column heading displays when you sort a list of indexes in Sybase ASE. ST93289
Size is now one of the table list attributes. ST95219
A new feature is the ability to update statistics. ST95220
System databases now display in a separate folder. ST95223
Sybase Anywhere and Sybase IQ now have grant privilege for "Edit permission." ST92736
Creation dates now display for all objects in the object palette. ST95209
Easily create and view aliases from Object Explorer ST95206
Functionality for Indexes in Sybase IQ has been improved with an intuitive interface to create a text index and search an index. ST95903
Schema Compare & Sync Fixed an issue with running Schema Compare & Sync on two tables. ST95600
There have been various bug fixes and enhancements to Schema Compare & Sync to improve functionality. ST99118
Sybase IQ You can now use Data Compare in Sybase IQ. ST95904
Stored procedures can now be debugged in the new stored procedure debugger for IQ and SA. Right-click a stored procedure from the Object Explorer and select Debug to access this feature. ST98075
Script Generation Individual foreign key scripting is not supported. The foreign key portion of table scripts is achieved through the use of the ALTER TABLE syntax. ST95213
For object creation, such as procedures and views, a new "Print Statements" option has been added. ST95222
"Create Like Login" functionality is improved and now includes roles and users. ST95205
The following tabs have been added to display segment mapping: Script, Devices, Tables and Indexes. ST95216
Fixed issue with having an arithmetic error when looking at the database script tab for databases with multiple large devices. ST96108
When generating the script for a table, there is a new option that allows you to generate create default and sp_bindefault statements instead of always generating them inline. ST94165
Procedure execution mode has been added to procedure script. ST95203
Script Tab You can now reserve options in the Script tab. ST95203
Script generation now includes grant information. ST95204
Session Browser Session Browser and Performance Monitor are now available in Sybase IQ. ST98074
SQL Editor You can now send multiple scripts to a single editor. ST93288
User Interface There is now a graphical display of device allocation. ST96366

Resolved Issues and Enhancements in 1.1.1

Feature Resolved Issue Defect ID
Import Wizard An exception no longer occurs when a user without select privilege imports data into a table. ST92984
Project Manager An error message no longer displays when you drag and drop from the Project Manager to the editor. ST93199
Object Palette Table information now displays for a table with both a default value and encryption key. ST93196
Create Function The database context of the editor now changes if the database is changed. ST93206
Data Grid You can now edit data in a table using a Sybase IQ connection. ST93193
Object Explorer The create like dialog now checks for single quotes, double quotes and brackets and replaces them with single quotes. ST93340
Parameter names no longer change when evaluating a SQL statement in Sybase SQL Anywhere. ST93584
Rules now display in all listing types. ST93549
You no longer receive an error message create a foreign key in the Foreign Keys tab. ST95730
Schema compare Schema Compare no longer shows an exception when the maximum number of connections has been reached. ST93478
Sybase IQ Create Like now produces the correct SQL. ST93440
Database Object Editor When a column is renamed in the alter table dialog, SQL is generated to rename the column instead of dropping and re-adding it. ST93619
Database Object Viewer An error no longer appears when you view users/groups in the Permissions tab. ST93817
User Interface New | Create Foreign Key now works correctly. ST94232
Script Generation The syntax for checking if an index exists has been corrected. ST95207
General Updated functionality. ST95200
Updated functionality. ST95199

Resolved Issues and Enhancements in 1.1

Feature Resolved Issue Defect ID
Options Toad for Sybase now supports the use of the Merant ODBC driver syntax to connect to Sybase. ST91665
Object Editor An exception no longer occurs when you view the device edit form after changing the name of the master device. ST90387
Connection Manager You can now connect normally to Sybase IQ when the database name is numeric. ST90491
Object Details All columns now display when you view details for lists. You no longer need select Refresh Item. ST92079
Explain Plan Fixed issue of receiving an error when you click the Explain Plan icon multiple times in the Editor toolbar. ST92481
SQL Editor Fixed issue with Formatter not formatting a long query. ST81532
Fixed issue with the DROP not indenting when you apply Formatter. ST84776
Fixed issue with getting an error in Editor when editing SQL. ST89577

Known Issues

Feature Known Issue Defect ID
Query Builder

In Sybase IQ and Sybase SQL Anywhere, queries with a varchar datatype that contain single quotation marks do not function correctly when generating the explain plan.


Replace single quotation marks with double single quotation marks when generating the explain plan.

Note: This fix only affects the explain plan code for IQ and SQL Anywhere.

Debugger An ASE exception occurs when stepping into or over a function during procedure debugging. ST94273

Third Party Known Issues

The following is a list of third party issues known to exist at the time of this release.

Feature Known Issue Defect ID

If you are running Windows XP with Service Pack 2 in strong security mode, Windows blocks you from opening zip files sent by Automation if they were created using the Windows Compression wizard. This is a security feature in Windows.


  1. Save the zip file to your computer.
  2. Right-click the saved zip file and select Properties.
  3. Select the Unblock checkbox.
Excel If an Excel file is open in Toad, you cannot open the same file in a separate Excel instance. To review this and other limitations when using Excel in the Web Browser, see "Considerations When Using the WebBrowser Control" at: ST42486
Export Wizard/ One Click Export

To export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from one of the following locations:

2003 PIAs:

2007 PIAs:

ADO.Net Driver Debugger does not allow you to step into or out of procedures. N/A

System Requirements

Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:

Client Requirements


1 GHz minimum


512 MB of RAM minimum, 1 GB recommended

Note: The memory required may vary based on the following:

  • Applications that are running on your system when using Toad
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

53 MB to run Toad

Operating System

Windows Server 2003

Windows Server 2008 (32-bit or 64-bit)

Windows Server 2008 R2 (64-bit)

Windows XP Professional (32-bit or 64-bit)

Windows Vista (32-bit or 64-bit)

Windows 7 (32-bit or 64-bit)

.NET Framework

Microsoft .NET Framework 3.5 (Service Pack 1)

Note: The following conditions apply:

  • If you have the .NET Framework 4.0 installed, you must still install the .NET Framework 3.5 (Service Pack 1).
  • The .NET Framework Client Profile is not supported.
  • To run Toad, the .NET security policy must be set to unrestricted. See "User Requirements and Restrictions for Running Toad " for more information.

Additional Software

Web Browser

Microsoft Internet Explorer 6.0 or later

Server Requirements

Operating System

Windows XP (32-bit with Service Pack 2 or later and 64-bit)

Windows Server 2003 (32-bit or 64-bit) Service Pack 1 or later

Windows Vista (32-bit or 64-bit)

Windows Server 2008 (32-bit or 64-bit)

Windows Server 2008 R2 (64-bit)

Windows 7 (32-bit or 64-bit)

Database Server

Sybase ASE 12.5, 15.0.2, 15.0.3, 15.5, 15.7

Sybase IQ 15.0, 15.1, 15.2, 15.3, 15.4

Sybase SQL Anywhere 10, 11, 12

Virtualization Support

Review the following information about using Toad in virtual environments:

Application Virtualization

Limited testing has been performed for Citrix XenApp 5.0 support on Windows Server 2003.

Limited testing has been performed for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2.

Desktop Virtualization (VDI)

Toad has been tested with Quest vWorkspace 7.0 running on Windows XP Professional 32-bit (Service Pack 2).

Toad has been tested with Quest vWorkspace 7.0 running Windows 7 Enterprise 32 bit.

Note: Toad may work in virtualization environments other than the ones in which it was tested.

Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release is Unicode-enabled and supports any character set. It supports simultaneous operation with multilingual data. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.

This release has the following known capabilities or limitations: No known limitations.

Getting Started

Contents of the Release Package

The Toad release package contains the following products:

  1. Toad for Sybase 2.0 Beta
  2. Adobe® Acrobat Reader 7.0

  3. Product Documentation, including:

Installation Instructions

Refer to Toad for Sybase Installation Guide for installation instructions.

For More Information

Get the latest product information, find helpful resources, and join a discussion with the Toad for Sybase team and other community members. Join the Toad for Sybase community.

Contact Quest Software



Quest Software, Inc.

World Headquarters

5 Polaris Way

Aliso Viejo, CA 92656 


Web site

See our web site for regional and international office information.

Contact Quest Support

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a Quest product and have a valid maintenance contract. Quest Support provides unlimited 24x7 access to Support Portal at

From our Support Portal, you can do the following:

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, policies and procedures. The guide is available at:

Toad Community

Get the latest product information, find helpful resources, and join a discussion with the Toad for Sybase team and other community members. Join the Toad for Sybase community.


© 2013 Quest Software, Inc.


This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.

The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.

If you have any questions regarding your potential use of this material, contact:

Quest Software World Headquarters
5 Polaris Way
Aliso Viejo, CA 92656

Refer to our Web site ( for regional and international office information.


Quest, Quest Software, the Quest Software logo, Benchmark Factory, Spotlight, LiteSpeed, Simplicity at Work, Toad, TOAD, T.O.A.D., and TOAD WORLD and vToadare trademarks and registered trademarks of Quest Software, Inc. For a complete list of Quest Software’s trademarks, see Other trademarks and registered trademarks used in this guide are property of their respective owners.