To: "DATASTAGE DEVELOPERS" <DATASTAGE-DEVELOPERS (AT) googlegroups (DOT) com>
Subject: User defined queries in Oracle OCI Stage on the input stage
Date: Sun, 01 Jan 2006 22:25:14 -0000

Hi,
Is it possible to use a replaceable parameter on a user-defined input
query on the Oracle OCI input stage?

I ran into a situation where a customized query must run with two
parameters. I can call this job from a control job by passing it
parameters through the Call DSSETPARAM basic call.

I would like to then use these parameters in a user-defined query. So,
if I am passing P1 and P2 as parameters for the job, I would like to
the query to use P1 and P2.

I did not see any specific documentation that states that a
user-defined query can handle a replaceable parameter. I tried to use
#P1# and it did not work.

To repeat the question, can we use replaceable parameters on a
user-defined query?

Thanks for your help.