DSXchange

Hi

I am using Oracle Enterprisestage for Reading the data from a DB tables

In the SQL statement I am using 'LIKE' . I need to pass the parmeter value to LIKE in the sql select statement .

WHERE BA.col3 = SA.col3
AND MP.col2 LIKE 'SampleTable'

I want to parameterise the SampleTable value

Can you please provide the syntax for sql statement(LIKE 'SampleTable'
) and if any special syntax is there at under Prameters Tab please provide me this also

Thanks
Srini

Have you not used job parameters yet? They are typically enclosed in hash / pound signs when referenced, so:

WHERE BA.col3 = SA.col3
AND MP.col2 LIKE '#SampleTable#'

Where "SampleTable" is the name of your parameter. That's the basics, let's start there and see if it helps.

probably, it should be like,

LIKE '%#SampleTable#%'

depends on your requirements it may vary