SELECT statements can operate on stored procedure result sets In SELECT statements, a stored procedure call can now appear anywhere a base table or view is allowed. However, CIS functional compensation performance considerations apply. For more information, see FROM clause on page 486 of Sybase IQ Reference Manual.
Unqualified table references with multiple matches are reported as syntax errors (behavior change) In previous releases, if a query contained a reference to a table without an owner name specified (an unqualified table reference) and if more than one match was possible on that table, the first match found was used. Unqualified table references now cause an error. See Chapter 6, “Database Error Messages” in Sybase IQ Troubleshooting and Error Messages Guide.
Square brackets can delimit identifiers You can use square brackets to delimit identifiers. Square brackets can always be used, regardless of the setting of the QUOTED_IDENTIFIER option.
For more information, see “Identifiers” in Chapter 3, “SQL Language Elements” in Sybase IQ Reference Manual.
New global variable compatible with Microsoft SQL Server A new global variable has been introduced to allow for Microsoft SQL Server compatibility. The @@fetch_status global variable is the same as the @@sqlstatus global variable, except that it returns the status of the most recent fetch in different values.
For more information, see “Global variables” in Sybase IQ Reference Manual.
Return empty string as a NULL string for TDS connections (behavior change) The TDS_EMPTY_STRING_IS_NULL option controls whether the server returns empty strings as a string containing one blank character or a NULL string for TDS connections. For more information, see “TDS_EMPTY_STRING_IS_NULL option [database]” in Sybase IQ Reference Manual.
