Interactive SQL new features

Following is a list of additions to Interactive SQL introduced in version 12.0.1.

  • Connect window supports Sybase IQ   You can use Interactive SQL to connect to a Sybase IQ database. In the Connect window, click Change Database Type, and then click Sybase IQ.

  • Text Completion   The following list describes changes related to the text completion feature in Interactive SQL and Sybase Central:

    • By default, the text completion window now opens automatically when you type in the SQL Statements pane. You can also open the text completion window by clicking Edit » Open Text Completer or pressing Ctrl+Space.

    • By default, SQL keywords and completed database object names are enclosed in double quotes.

    • SQL statements and keywords are now included in the list of suggestions.

    • The text completion window now handles databases where strings are treated as case-sensitive, but identifiers are not.

    • The following keyboard shortcuts have changed:

      Old shortcut New shortcut Description
      Tab Ctrl+A Shows a context-free list of matches.
      + Ctrl+Plus Sign (+) Adds the item with its parameter list to the SQL Statements pane.
      * Ctrl+Asterisk Adds the item with its parameter and type list to the SQL Statements pane.
      ' Ctrl+Double quote (") Adds the item enclosed in quotation marks to the SQL Statements pane.
      N/A Tab Accepts the selection and closes the text completion window.

    For a complete list of shortcuts, see Text completion keyboard shortcuts.

    For more information, see Using text completion.

  • New Import/Export option   When you click Options » Import/Export, you can specify how nulls should be exported in the Export NULL values as field. See output_nulls option [Interactive SQL].

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1