If I had my way, Java applications that do not to directly access, e.g., file-based inter-application one-way communication, legacy systems written in Informix 4GL will use other RDBMS’s that are modern, robust, scalable, and cheaper instead of reusing a fossil. This is just one among many ways to escape a vendor lock-in. Slowly but surely.
To perform an SQL Update on a Date field in Informix through some other SQL Editor like Aqua Studio, do something like this:
UPDATE A_TABLE SET DATE_FIELD_A = EXTEND(DMY(28,11,2013), YEAR to SECOND)
WHERE COUNTRY = 'Singapore' AND ID = 'ABCDEF12345'
You may not be able to perform the “normal” update of a date using your preferred editor or older libraries.
Why not use dbaccess? It is a primitive tool.