Migrating ASE Stored Procedures to Sybase IQ Syntax

Convert Adaptive Server Enterprise stored procedures to Sybase IQ syntax.

1. In Enterprise Explorer, open the Stored Procedures folder, right-click a stored procedure, and select Migrate to IQ Syntax.
2. (Optional) Filter by schema and name the stored procedures that appear.
3. Select the procedural objects to migrate and click Next.
4. Indicate whether to save the generated DDL, execute it, or both.
   

   Option	Description
   Generate Script	Generate a SQL file for the object. Specify an existing project or create a new project in which to store the SQL file. (Optional) Change the default file name in which to save the SQL code.
   Execute Immediately	Execute the SQL code immediately. If you do not select this option, you must execute the SQL script later to create the object. Select the Sybase IQ connection profile Type, Name, and Database. Create a Sybase IQ connection profile if one does not exist.

5. Click Finish.

   If you generated a script, it opens in SQL Scrapbook, where syntax errors are indicated by an error icon in the left margin. Problem view also lists any syntax errors and their location.

---

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com