Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » SQL dialects and compatibility

 

Automatic translation of stored procedures

In addition to supporting Transact-SQL alternative syntax, SQL Anywhere provides aids for translating statements between the Watcom SQL and Transact-SQL dialects. SQL language built-in functions returning information about SQL statements and enabling automatic translation of SQL statements include:

  • SQLDialect(statement)   Returns Watcom-SQL or Transact-SQL.

  • Watcom SQL(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