Re: How to initialize fields

On Thu, Aug 16, 2012 at 12:00 AM, Francesco Alfano <edacedpa@yahoo.it>wrote:

> How can I write a routine in Esql/C which initialize to 0 (zero) all
> numeric fields (smallint, decimal, etc) and to (' ') space the other
> fields in a table?
>

You've been given answers. I'm going to raise the types not covered by
your question, notably the date and time types.

Zeroing a DATE gives you 1899-12-31. Zeroing an INTERVAL is fine. Zeroing
a DATETIME gives you an error; so does blanking it. What about BYTE and
TEXT and BLOB and CLOB and ...

You don't have to respond to this question — you probably should think
about it enough that you know what you want to do with these types when
they appear.

--
Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."