Sybase IQ 12.6 installs and requires version 4.3 of the Sybase Central Toolkit. See the section “Before you install” in your Sybase IQ Installation and Configuration Guide for required plug-in and related components to support this version.
Sybase IQ plug-in changes The Sybase IQ plug-in for Sybase Central has been reorganized. Much of the information that was previously available in property sheets, dialog boxes, and folders in the left pane is now available on tabs in the right pane. For example, to view information about a foreign key, you now select the table that has the foreign key in the left pane and then select the Foreign Keys tab in the right pane. In previous versions, there was a separate Foreign Keys folder in the left pane.
Several other changes have been made to the plug-in, including the following:
The Code Editor and Table Editor are no longer separate windows. Now you can edit stored procedures, functions, and events, as well as edit tables, in the right pane of Sybase Central.
The toolbar buttons now change to include options specific to the object selected.
The SQL Statements log and server messages (the same information that appears in the Server Messages window) can now be viewed directly in the Sybase Central main window. To view this information, in Sybase Central choose File > Design Details. The Design Details pane appears at the bottom of the main Sybase Central window.
Enhanced clipboard support in the Sybase IQ plug-in Clipboard support has been enhanced in the Sybase IQ plug-in so you can copy and paste most objects within Sybase Central into other applications, such as Interactive SQL or a text editor. When you copy objects into other applications, depending on the object you select, either the object name or the SQL for the object appears. For example, if you copy an index in Sybase Central and paste it into a text editor, the CREATE INDEX statement for that index appears.
Debugger changes The database object debugger that lets you debug both stored procedures and Java classes has been integrated into Sybase Central. The user interface has been redesigned.
Editable data in Interactive SQL and Sybase Central You can update the database by editing Interactive SQL result sets, and by editing tables and views in Sybase Central. You can copy, edit, insert, and delete row values.
Data displayed in Sybase Central can be copied to the clipboard.
Procedure profiling Sybase Central contains a Profile tab that displays information about the number of calls and execution times for stored procedures, functions, events, and triggers. You can also view information about the execution speed for each line within a procedure. Profiling information is available through Sybase Central and SQL stored procedures.
For more information about viewing procedure profiling information in Sybase Central, see “Profiling database procedures” in Sybase IQ Performance and Tuning Guide.
For more information about obtaining procedure profiling information with SQL stored procedures, see sa_procedure_profile and sa_procedure_profile_summary in Adaptive Server Anywhere SQL Reference.
To use this feature, you must upgrade the database.
Sybase Central accepts COMMLINKS connection parameter (behavior change) In previous versions of Sybase IQ, Sybase Central ignored the COMMLINKS connection parameter. Sybase Central now accepts this parameter.
As a result of this change, some connection strings may behave
differently than in previous versions. Specifically, if you do not
supply COMMLINKS=tcpip, Sybase
Central does not look for servers on the network.
For more information, see “CommLinks connection parameter [Links]” in Sybase IQ System Administration Guide.
