Contents Index Transact-SQL batch overview Using Sybase Central to translate stored procedures

ASA SQL User's Guide
  Transact-SQL Compatibility

Automatic translation of stored procedures


In addition to supporting Transact-SQL alternative syntax, Adaptive Server 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:

These are functions, and so can be accessed using a select statement from Interactive SQL. For example:

select SqlDialect('select * from employee')

returns the value Watcom-SQL.


Using Sybase Central to translate stored procedures

Contents Index Transact-SQL batch overview Using Sybase Central to translate stored procedures