User defined sql in DB2 API Stage

[peeyushanand]

Hi,

I am using the DB2 API stage for writing a user - defined SQL that will insert some values into the table using a left outer join between two tables. But when I am doing so, I am getting an error :-

"This SQL statement did not contain the same number of parameters as columns on this link. This usually happens with user-defined SQL."

Since the API stage cannot run on its own, so I am using a row generator and connecting it to the API stage.

The DB2 Database is a remote v 8.2 database.

Please help.

Thanks in Advance

Peeyush Anand

[ray.wurlod]

Not really enough information. However, the problem is that one of your SQL statements in your job contains a number of parameter markers that is different from the number of columns defined on that link. You must find out where that is, and fix it.

[chulett]

How many parameter markers are in your SQL? You'll need the same number of columns defined in the DB2 stagte as well.

[thurmy34]

Hi
This message appears when you add a column whithout specify its type and its legnth.
Happens to me yesterday.

[Harichandrar]

Please let me know if you solved this issue. I have got the similar issue and still didn't get any clue.