Table of ContentsPreviousNext

Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.
Ispirer Sybase ASA to SQL Server Migration overview.

Ispirer SQLWays Database Migration Software

Conversion of Sybase Adaptive Server Anyware CALL to Microsoft SQL Server

The Sybase Adaptive Server Anyware CALL statement is used to invoke a procedure that has been previously created. Sybase Adaptive Server Anyware CALL allow specifying expressions in the argument list.

The EXECUTE statement is used to invoke procedures in Microsoft SQL Server. Microsoft SQL Server EXECUTE allows specifying only constants or variables (not expressions) in the argument list.

SQLWays converts Sybase ASA CALL to the Microsoft SQL Server EXECUTE statement. For each expression in CALL, SQLWays creates a local variable, assigns the expression to the variables, and use this variable in the EXECUTE statement.

TABLE 40. Example of the conversion
Sybase Adaptive Server Anyware
Microsoft SQL Server
create procedure asa_sp_call (@a int) 
call sp_func('MTN' + ':' + 'FTN',@a+3); 
create procedure asa_sp_call @a INT  
   AS begin 
   DECLARE @par01 CHAR(10) 
   DECLARE @par02 INT 
   set @par01 = 'MTN' + ':' + 'FTN' 
   set @par02 = @a + 3 
   EXECUTE sp_func @par01, @par02 

Table of ContentsPreviousNext
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.