Physical Modeling › Stored Procedures › DBMS Migration Example

DBMS Migration Example

You can use the %ForEachATT macro to generate variable definitions, as illustrated below:

DEFINE p_renting_customer integer;
DEFINE p_master_number integer;

If you change the target server to Sybase, which uses a different syntax for defining variables, you must manually change the word DEFINE to DECLARE, and assign the "v" macro variable the value "@."

DECLARE @renting_customer int
DECLARE @master_number int

The Informix Stored Procedure Example and the Sybase Stored Procedure Example show the same stored procedure template code and expanded code.

More information:

Stored Procedures