BusinessWorks

Well,

Here is a small example.

SELECT tst.TEST_ID

FROM APP_TEST tst

WHERE tst.TEST_CODE in ('Code1', 'Code2', Code3')

The number of parameters can change.

WHERE tst.TEST_CODE in ('Code1', 'Code2')

or WHERE tst.TEST_CODE in ('Code1', 'Code2', 'Code3', 'Code4')

etc...

It's easy to do this with a Direct SQL Activity but I would like to know if it's possible to achieve this with a JDBC Query Activity.

The query would be like this :

SELECT tst.TEST_ID

FROM APP_TEST tst

WHERE tst.TEST_CODE in (?)

Best regards,

Mathieu

Thx,

I was expecting this answer.

Hope one day tibco will add this functionnality.

Best regards,

Mathieu

Sure it will works.

But this means to update the code list in the database before hand.

It answer my question but I think I was not clear enough when I explain my case.

I would like to do this with direct input of the activity and not with a sub-request (which seems to be impossible for the moment).

Thx

Mathieu