Link to this page

Print this page

Parent topic: Data dictionary

SQL adaptation guide For SQL SERVER 2005, 2008, 2012 / Data dictionary

Stored procedures

Both Informix^® and Microsoft™ SQL SERVER support stored procedures, but the programming languages are totally different:

Informix stored procedures must be written in SPL.
Microsoft SQL SERVER stored procedures must be written in Transact-SQL.

Solution

Informix stored procedures must be converted to Microsoft SQL SERVER "by hand".