Hi,
I have a table that have two columns to store date and time. Date column defined as Date data type where as Time column defined as CHAR(4). We would like to alter the table for an additional column with TIMESTAMP data type. The data to the new column should be populated from exisitng date and time columns. Is there any way Can I do using SQL to poulate the data into this column.

Table
COL1 DATE
COL2 CHAR(4)
COL3
--
NEWCOL TIMESTAMP.

TIMESTAMP function accept "valid string representation of a time" for the second argument,
if the first argument was a DATE or a valid string representation of a date.

See Information Center.
TIMESTAMP - IBM DB2 9.7 for Linux, UNIX, and Windows