Re: How to initialize fields
On Thu, Aug 16, 2012 at 12:00 AM, Francesco Alfano <firstname.lastname@example.org>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
Jonathan Leffler <email@example.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