DSXchange

quote="kumar_s"]A quick search on SQLSTATE=22005 will should you that, its due to data type mismatch. The same reason why Arnd asking the question. Also check if the value that been send for lookup fields (key1 and ...[/quote] THe job is working now. There was a problem with the source file. There w...

There is a simple job.I am trying to create a Hash file. A sequential flat file is input and DB2 table as the lookup. Director is showing me the error as : Error in assignment. SQLSTATE=22005 SQLExecute: Error executing statement 'SELECT key1,key2,a,b,c FROM schema.table WHERE key1 = ? AND key2 = ?A...