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 = ?AND key2 in ('op1', 'op2', 'op3', 'op4')'.
Can anyone help.
Error in assignment. SQLSTATE=22005
Moderators: chulett, rschirm, roy
What are you datatypes for key1 and key2 and what is the datatype in your DS job with which you are filling them? For those 2 values of key1 and key2 what happens when you try to manually type in the SELECT clause from the command line and the DB2 command?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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 key2) are of compatiable datatype.
Also check if the value that been send for lookup fields (key1 and key2) are of compatiable datatype.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
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 was an extra french character,in the source file i.e. the corrupted dat file which was crreating problem.
Thanks.
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 was an extra french character,in the source file i.e. the corrupted dat file which was crreating problem.
Thanks.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Are you saying that there was a French character in the source file that was passed to either key1 or key2? DataStage should have no trouble with this!
However SQL Server may require NVarChar rather than VarChar (or NChar rather than Char) and this may have engendered the data type mismatch error from SQL Server.
However SQL Server may require NVarChar rather than VarChar (or NChar rather than Char) and this may have engendered the data type mismatch error from SQL Server.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.