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].

Discuter à propos de cette page dans DocCommentXchange.