New answers tagged

0

My main concern, regardless of the migration mechanism used, would be for the consistency of the migrated data. How are you going to ensure that you don't miss changes while the data is transferred. One of the classic Informix tools could be DB-Export, which (by default) locks the database so it isn't being changed while the export occurs. It gives you ...


0

The "SQLException: Illegal SQL statement in SPL routine" error is probably due to the inclusion of certain statements in the stored procedure that cannot be used when called from a DML statement. Here's the Informix document. A workaround is to execute the stored procedure, then fetch from it. This is not as elegant as your SELECT FROM TABLE() would have ...



Top 50 recent answers are included