In addition to supporting Transact-SQL alternative syntax, SQL Anywhere provides aids for translating statements between the Watcom-SQL and Transact-SQL dialects. Functions returning information about SQL statements and enabling automatic translation of SQL statements include:
SQLDialect(statement) Returns Watcom-SQL or Transact-SQL.
WatcomSQL(statement) Returns the Watcom-SQL syntax for the statement.
TransactSQL(statement) Returns the Transact-SQL syntax for the statement.
These are functions, and so can be accessed using a select statement from Interactive SQL. For example, the following statement returns the value Watcom-SQL:
SELECT SQLDialect( 'SELECT * FROM Employees' ); |
Using Sybase Central to translate stored procedures
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |