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 16.0 » Administration tools new features


Interactive SQL new features

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

  • Support for SAP HANA databases   Use the -hana command line option for the Interactive SQL utility (dbisql) to connect to an SAP HANA database. Alternatively, in the Connect window in Interactive SQL, click Change Database Type, and then click SAP HANA.

    Text completion in the SQL editor, table and column name browsing, procedure name and source browsing, importing and exporting are all supported.

    The following Interactive SQL statements are not supported: CONNECT statement, SET CONNECTION statement, and START SERVER statement.

    The plan viewer for SAP HANA is new, but works similarly to the other plan viewers. The Spatial Viewer is not supported.

  • OEMs can disable the Interactive SQL fast launcher   You can disable the fast launcher feature for Interactive SQL and prevent users from re-enabling it using the OEM.ini file. See Administration tools configuration.

  • OEMs can specify how results are to be displayed in Interactive SQL   In the OEM.ini file, use the following options to specify how results are to be displayed: defaultShowResultsForAllStatements and defaultShowMultipleResultSets. See Administration tools configuration.

  • Numeric values are displayed right-aligned in textual result sets   Result sets are displayed as text when run as a console application, or as a windowed application when the Show results as text option is selected. Previously, all values were displayed left-aligned. Now, numeric values are displayed right-aligned. This makes it easier to compare the values.

  • The error window displays line numbers   If executing a statement causes an error, the error window that appears now displays the line number of the error.

  • The text completion feature shows parameter lists   The Show tool tips option in the Options window in Interactive SQL now displays parameter lists as you type for procedures, functions, and spatial methods. Close the parameter list by pressing Esc.

  • The text completion feature automatically inserts closing brackets, apostrophes and quotation marks   The text completion feature inserts the closing punctuation mark when you type an opening parenthesis, square bracket, brace, apostrophe, or quotation mark. To control the insertion of the closing punctuation marks, click Tools » Options » Editor » Text Completion.

  • The Import Wizard can read column names from imported text files   The Import Wizard can read a list of column names from the first line of the file. This option is available only when importing delimited text files.