I have another suggestion (Or maybe there is a setting I need to turn one). I think this will be an easy one, but correctly its causing a lot of issues for me.
I have a table in DB2 with a column defined as a varchar(120) but when I upload a spreadsheet its reformatting the date field as a time stamp with a bad formatting for db2 time stamp format.
Let me explain in greater detail.
Here is the Table DDL:
CREATE TABLE DateTEST (
Here is the spreadsheet:
I am using the import wizard (which I Love and its a great you can create templates and just fire those templates off whenever you want).
Here is screen one of the wizard:
As you can see its keeping the format of Date. Now when we go the next screen its re-formatting the data to this:
Here is the results in the table:
The problem with this format is DB2 can't cast it as a date as I need it in the format of date when I push to final table.
When you run this SQL: Select cast(cola as date) from DateTEST
You get this error: Lookup Error - DB2 Database Error: ERROR  [IBM][DB2] SQL0181N The string representation of a datetime value is out of range.
My suggestion is can you keep it as a date field and not convert the value to a time stamp? Or better yet can you rather format the time stamp as what is stated in the settings?
Such as this:
I know Dates and Time stamps are hard to use in Db2 for z/OS if they are not formatted correctly.
Thanks again for bringing a great product to us.
Toad for DB2 Beta 18.104.22.168 (64 bit)