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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere 16 - Changes and Upgrading » What's new in version 12.0.1 » Administration tools new features


Interactive SQL new features

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

  • Connect window supports SAP Sybase IQ   You can use Interactive SQL to connect to an SAP Sybase IQ database. In the Connect window, click Change Database Type, and then click SAP 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 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].