DSXchange

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 = ?.

it seems that the problem cuold be that you have no informed the value of the key o_st_uid

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 = ?.

Check the Query in the Lookup table.

Hi Das,
Did you found out what is the Informix error corresponding to the error code?
What is the exact query that been used in Lookup table?

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 = ?.

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.

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.