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


Using Sybase Central to translate stored procedures

Sybase Central has facilities for creating, viewing, and altering procedures and triggers. You can also export the text to a file for editing outside Sybase Central.

 To translate a stored procedure (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority or as the owner of the procedure.

  2. Open the Procedures & Functions folder.

  3. In the right pane, click the SQL tab and then click in the editor.

  4. Choose File and select one of the Translate To commands.

    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 server translates it to that dialect. Any untranslated lines appear as comments.

  5. Rewrite any untranslated lines.

  6. Choose File » Save.