Hi ,
I am geeting the following error while running the DS job.And got aborted
Please help me out.
Stlkp..Transformer_1: [Informix][Informix ODBC Driver]Unspecified System Error = -11103.
SQLBindCol: Failed to bind result set column 'o_st_uid' for SQL statement: SELECT o_st_eid from o_st where o_st_uid = ?.
Getting -11103 while running DS job
Moderators: chulett, rschirm, roy
Re: Getting -11103 while running DS job
it seems that the problem cuold be that you have no informed the value of the key o_st_uid
regards,
Cristina
regards,
Cristina
Das wrote:Hi ,
I am geeting the following error while running the DS job.And got aborted
Please help me out.
Stlkp..Transformer_1: [Informix][Informix ODBC Driver]Unspecified System Error = -11103.
SQLBindCol: Failed to bind result set column 'o_st_uid' for SQL statement: SELECT o_st_eid from o_st where o_st_uid = ?.
Re: Getting -11103 while running DS job
This implies you used user defined sql for some reason and did not match the columns defined in the stage to it. My first piece of advice would be to allow the stage to generate the sql to avoid this kind of problem. Nothing in this simple select requires custom sql.Das wrote:SQLBindCol: Failed to bind result set column 'o_st_uid' for SQL statement: SELECT o_st_eid from o_st where o_st_uid = ?.
![Confused :?](./images/smilies/icon_confused.gif)
To fix this, you'll need two columns defined in the stage: o_st_uid and o_st_eid. You'll also need to select both columns (in the proper order) and mark o_st_uid as the Key column.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers