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.

I have found out we can. It was more synatical errors that caused the
problems that I have shown above. The usual #param# may be used in a
user-defined query. I had used a date and the TO_DATE conversion was
incorrect.

Hence the answer is yes, a parameter can be used in a user-defined
query.