Apologies on my part, I re-read your previous post. Insert is working but update is not huh..
Have you tried generated sql query as I asked you before.
The error maybe due to the fact that you are passing less number of columns in update as compared to the number specified in the column's tab. Try adding all the columns and see if that works.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
I think it doesn't like the string '9999-12-31' - what is the column data type for that value? Perhaps you need to cast this string to a date or timestamp...
You think its the CURRENT DATE that might be the problem? What database are you connecting to. Get the current date within the transformer and pass it to the column "EFF_DT"
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Did you try ArndW's suggestion?
Alternatively, do all the hardcoding in the transformer and dont hardcode anything inside the sql.
Are you getting any sql codes along with your error message, including the warning messages?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ArndW wrote:What are your column definitions? At least one of these is incorrect for DataStage.
Post the reply for ArndW's question. There is little we can do sitting on the other side of your screen. Try making the date column as varchar and see if that helps.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.