How to pass two values from parameter

hari_dsx · Post by **hari_dsx** » Fri Feb 08, 2008 5:25 am

Hi,

I have to pass two values from parameter file.
The environment variable
$pSiteConvGrp = TEXAS, DETROIT

My source database is oracle.

SELECT * FROM STAGE_EQUIP_MSTR_DETL_SPEC WHERE SITE_CONV_GRP in ('#$pSiteConvGrp#')

Please let me know how to pass two or more values from one environment variable.

Thanks,
Hari.

Maveric · Post by **Maveric** » Fri Feb 08, 2008 5:31 am

What have you tried till now? What is happening when you pass the values as in your post? I guess it would work the way you have posted it. Pass the value as a string.

ankita · Post by **ankita** » Fri Feb 08, 2008 6:50 am

I am also having similar requirement , not able to get the solution. Job is aborting. Please let us know if you find any solution.

chulett · Post by **chulett** » Fri Feb 08, 2008 7:10 am

As noted, on the surface that should work just fine. We'd need specifics of the problem/abort to be able to help.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 08, 2008 2:15 pm

In particular, you need to manage the single-quote characters, required in the context of the IN clause, when passing from a job parameter.