Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere 11 - Changes and Upgrading » What's new in version 10.0.0 » Sybase Central and Interactive SQL

 

New features

Following is a list of additions to Sybase Central and Interactive SQL introduced in version 10.0.0.

Sybase Central

This section describes new features in Sybase Central. Changes and additions made to the Sybase Central plug-ins are described in the following sections:

  • Sybase Central Task list   You can choose to view tasks in the left pane of Sybase Central, instead of a tree structure of the database. The Task list shows common tasks related to the object that is currently selected. The Task list includes common tasks, navigation options, and links to the documentation. See Navigating Sybase Central.

  • New Connections menu   In previous releases, you could press F11 to open the New Connection window that let you choose the plug-in you wanted to connect with. Sybase Central now provides a Connections menu where you can choose the plug-in you want to use. The New Connection window has been removed, but pressing opens the Connections menu where you can choose the plug-in you want to use for your connection.

  • Connection profile enhancements   You can now add descriptions to Sybase Central connection profiles. Connection profiles can also be imported and exported.

  • Plug-in searches   You can now search for objects that contain specified text within the plug-ins and databases in Sybase Central by choosing View » Search Pane.

  • Context dropdown list   The new Context dropdown list shows you the object that is currently selected in the object tree to make it easier to navigate through plug-ins, especially when the object tree is not open in the left pane.

SQL Anywhere plug-in
  • Deadlocks database tab   When you are connected to a SQL Anywhere database in Sybase Central, you can view information about deadlocks on the Deadlocks tab. See Viewing deadlocks from Sybase Central.

  • Entity-relationship diagrams   Sybase Central displays entity-relationship diagrams for databases, showing the tables in the database and their foreign key relationships. See Viewing entity-relationship diagrams from the SQL Anywhere plug-in.

  • New Create Schedule wizard and other enhancements to the Events folder   For each scheduled event, the Events folder now displays the next scheduled time when the event will be triggered. For each conditional event, the folder displays the system event and optionally the trigger conditions that trigger the event. Schedules are created using the new Schedule Creation wizard. When creating a new scheduled event, the Event wizard allows you to create a single schedule, but you can later add additional schedules to an event if required. See Defining schedules.

  • Maintenance plans   You can set up a schedule for validating and backing up a database automatically and have the output log emailed to you. See Creating a maintenance plan.

  • New Restore Database wizard   You can now use the Restore Database wizard to restore a database from an archive backup. See Restore from an archive backup.

  • Editor enhancements for Sybase Central and Interactive SQL   You can choose the font used in the editor windows of Sybase Central and Interactive SQL on the Format tab of the Options window.A typing completion option has been added to the editor for database object names. See Using text completion.

New plug-ins for Sybase Central
  • QAnywhere plug-in   The QAnywhere plug-in provides an easy-to-use graphical interface for creating and administering your QAnywhere applications.

    See New QAnywhere plug-in for Sybase Central.

  • UltraLite plug-in   The UltraLite plug-in allows you to create, modify, and administer your UltraLite databases in a graphical user interface.

    See Graphical administration tools.

  • MobiLink Create Synchronization Model wizard and Model mode   You can now create a synchronization model using a wizard, and edit your model in the MobiLink plug-in using the new Model mode. You can also set up MobiLink server-initiated synchronization. The old features of the MobiLink plug-in have also been enhanced and are preserved in Admin mode.

    See Enhancements to the MobiLink plug-in for Sybase Central.

Interactive SQL
  • Interactive SQL can connect to UltraLite databases   You can now use Interactive SQL to develop and test SQL statements with UltraLite databases. The ulisql utility has been deprecated. See Graphical administration tools.

  • Interactive SQL integrates with third party source control systems   Interactive SQL can integrate with third party source control systems, allowing you to perform a number of common source control operations on files from within Interactive SQL, such as checking in, checking out, and comparing against old versions. See Using source control integration.

  • New Interactive SQL options   The isql_maximum_displayed_rows option lets you specify the number of rows that appear in the result set in Interactive SQL, while the isql_show_multiple_result_sets option specifies whether multiple result sets can appear in the Results pane in Interactive SQL. See isql_maximum_displayed_rows option [Interactive SQL] and isql_show_multiple_result_sets [Interactive SQL].

  • Text completion   Interactive SQL now includes a typing completion option that can fill in the names of the following object types: tables, views, columns, stored procedures, and system functions. See Using text completion.

  • DESCRIBE statement now supported by Interactive SQL   The DESCRIBE statement enables you to obtain the following information about a specified table or procedure:

    • all columns found in the table
    • all indexes found in the table
    • all parameters used with the stored procedure

    See DESCRIBE statement [Interactive SQL].

  • Interactive SQL supports the @data option   When starting Interactive SQL from a command prompt, you can specify the @data option to read in options from the specified environment variable or configuration file. See Interactive SQL utility (dbisql).

SQL Anywhere Console utility
  • SQL Anywhere Console supports the @data option   When starting the SQL Anywhere Console from a command prompt, you can specify the @data option to read in options from the specified environment variable or configuration file. See SQL Anywhere Console utility (dbconsole).