Okay, here's a follow-up to my last question. I've got a TIME field and
a DATE field in my raw data. I'd like to derive a TIMESTAMP field upon
INSERT from these two fields. This seems like it should be obvious, but
I can't figure the syntax. It should be something like:

INSERT INTO TABLE
(TIME, DATE, TIMESTAMP)
VALUES
(TIME('01.00.00'), date('2006-05-06'), TIMESTAMP_ISO(DATE,TIME) );

but that's not it. And the documentation says it will only take one of
the other, but there's not much point in a timestamp unless it can
accept both time and date, right?

TIA

DB2 & UDB email list listserv db2-l LazyDBA home page