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 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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|