Conversion of Sybase Adaptive Server Anyware CALL to Microsoft SQL Server

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) 
begin 
call sp_func('MTN' + ':' + 'FTN',@a+3); 
end; 
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 
end 