How do I convert Sybase Stored Procedures to Informix?
verdy_p@msn.com (Philippe Verdy) writes: Such a converter exist to convert Sybase Transac-SQL to Informix SPL. Ask your local informix representative that will provide you the tools required. I have worked on these tools and successfully converted up to 30+ACU- of our Sybase SQL procedures without need to rewrite them, at least for the first release. Then it required many enhancements to the converter, and I have completely revamped it to satisfy our needs for up to 95+ACU- of our procedures (on 600 and more Sybase procedures, only 12 had to be patched manually, mainly due to semantics difference of some Sybase constructs like ambiguous +- operator for string concatenation or numeric addition, concatenation of NULL-possible values). Then I have written the support procedures that allow unlimited use of Sybase constructs in Informix SQL language: explicit conversions, handling substring(), isnull(), datetime conversion styles. Because I did it with the aggreement of Informix I am not au
Related Questions
- Why is the output for Database Sizes and Transaction Logs sizes different from Sybase stored procedures like sp_helpdb and sp_spaceused?
- What is the minimal software required to simply expose stored procedures in a Sybase DB as a Web service end point?
- How do I convert Sybase Stored Procedures to Informix?
