Unanswered: Alter Table GUI: Date to Timestamp conversion
DB2 ESE v22.214.171.1242 FP14, Win 2k3
I've searched the forums and havent found a post which "directly" addresses my question, maybe I can get some help.
I'm attempting to change a DATE column to a TIMESTAMP using the "alter table" gui in cc (which appears to use SYSPROC.ALTOBJ). I understand I can do this manually but I figured something so simple as changing a date to a timestamp is something this should handle, right?
Created a simple table, 2 columns: varchar(10), date
Added 1 row, values: 001, 2008-01-12
In the "Conversion expression (date to timestamp)" box I've tried:
which both work successfully if I use them in a select, but on the LOAD portion of the alter I get status INVALID. When I check the temp table created by ALTOBJ the data is still stored as DATE, which is why I'm assuming it fails on the import. Is there some trick to getting the Conversion expression working for timestamps? Can anyone shed some light on this?
Yeah, you're right about the black box method, I guess the last thing I want to do is send my data down a path of uncertainty. It’s unfortunate we can’t rely on these built-in features provided by IBM for a quick fix.