Does the Informix Dynamic Server Stored Procedures Parser have any limitations?
Yes. The limitations of the Informix Dynamic Server parser are: The parser moves all user-defined comments within the original Informix Dynamic Server stored procedure from their original position to the top of the Oracle stored procedure where they display in a single unit. You must place a date format mask in front of any variable or literal that is assigned to a DATETIME column. A single Informix Dynamic Server trigger can contain both BEFORE and AFTER constructs. Triggers of this type generate two distinct triggers, a BEFORE and an AFTER trigger, within the Oracle destination database. The stored procedure parser for this release displays code for both of the resulting Oracle destination database triggers in one screen. Access these triggers through the Triggers Property Sheet within the Oracle Model. However, the parser only creates the first trigger in the destination Oracle database. You must create the second trigger manually. To do this, copy the text from the Triggers Propert
