Informix Error -487
-487 A cursor can only be declared as static or dynamic.
The specified SQL statement requires you to declare a cursor as static or dynamic. Declare the cursor as static or dynamic, depending on which type of cursor is required, and retry the specified operation.