SQL Update on a Date Column in Informix

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:

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.