I have a text file which needs to be transformed and inserted/updated into a DB2 Table.
When I do it for the first time using "Table Output" my transformation works fine.
Now, when the file comes for the second time, I need to use "Insert/Update" as I need to inserts new rows and update the existing rows in a DB2 Table.
Here is the problem, I have date fields in the DB2 table and the input file has the date in the format mm/dd/yyyy hh:mm.
Now, when I am using "Table Output" as the final output step I am able to get all the records in the input file inserted into the DB2 Table.
The problem occurs when I use "Insert/Update" to acheive inserts/updates to the same table using the same date format in the input file and it gives me -181 SQL error.
I am still wondering how can the same Date Format work for "Table Output" and not for "Insert/Update"
Is this an existing problem with "insert/update" ?