Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » SQL dialects and compatibility » Automatic translation of stored procedures

 

Translating a stored procedure

Translate stored procedures between SQL dialects, for example between Watcom-SQL and Transact-SQL.

Prérequis

You must be the owner of the procedure or have one of the following privileges:

  • ALTER ANY PROCEDURE system privilege
  • ALTER ANY OBJECT system privilege
 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Click the Procedures & Functions folder and select one of the stored procedures in the list.

  3. In the right pane, click the SQL tab and then click the text window.

  4. Click File and click one of the Translate To options.

    The procedure appears in the right pane in the selected dialect. If the selected dialect is not the one in which the procedure is stored, the database server translates it to that dialect. Any untranslated lines appear as comments.

  5. Rewrite any untranslated lines.

  6. Click File » Save.

Résultat

The stored procedure is translated and saved in the database.

 See also
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0