DB2 Read error

[_chamak]

Hi,

I am reading a DB2 table and its a simple select statement with a where clause and writing to a Dataset

SELECT PART_ID, SYSTEM_ID, TYPE_ID, EFFECTIVE_DT
FROM
#jp_SCHEMA#.HUB
WHERE TYPE_ID #jp_LIST#
FOR READ ONLY WITH UR

Its a multi instance job. This job ran fine with one instance and failed for another instance. Both the parameters for this select statement are same.
Below is the error i am facing
Error occurred during initializeFromArgs().
Property : Property not valid in source context

I serached for this but did not get correct solution.

can someone help me on this issue.

[qt_ky]

What stage type are you using to read from DB2?

What is the value passed to #jp_LIST#?

Are you running both instances at the same time?

If you run the failing istance by itself does it always fail?

[SURA]

SELECT PART_ID, SYSTEM_ID, TYPE_ID, EFFECTIVE_DT
FROM
#jp_SCHEMA#.HUB
WHERE TYPE_ID #jp_LIST#
FOR READ ONLY WITH UR

As qt_ky commented what value you are passing. But if i look into the query WHERE TYPE_ID = #jp_LIST# / WHERE TYPE_ID IN #jp_LIST# should be there is my understanding.

DS User