Weird error

[kool_cons]

I was getting follwoing error while running the job. i used some user- defined sql in the table look up.i ran the same query in database,it was giving required results.but when i try to run through datastage job,it couldnot work.please help me guys.
[ODBC 20101 driver]6033
SQLExtendedFetch: Error retrieving results from data source.


thanks in advance

[tcj]

Looking up the number 6033 on google I found the error message

6033 "Number of bound columns exceeds the number of result columns."

Check the number of columns your query is returning and how many columns datastage thinks the query should be returning.

Tim