Hi,

I have a SQL like this(please find the SQL below) to unload the target table .

Select carrd_cd,carr_path,platg_carr_cd from f_abcd_path where
platg_carr_cd='KK' AND (carr_path LIKE '%AA%' OR carr_path LIKE '%BB%' OR carr_path LIKE '%CC%' OR carr_path LIKE '%DD%' OR carr_path LIKE '%EE%' OR carr_path LIKE '%FF%' OR carr_path LIKE '%DD%' OR carr_path LIKE '%HH%' OR carr_path LIKE '%II%' OR carr_path LIKE '%JJ%');

Since each month I recieve a new carr_path,I have to parameterize all the carr_path which I have in the where clause.Currently,I have a shell script(carr_path.ksh) which lists all these carr_path like 'AA','BB','CC','DD','HH','II','JJ' .. etc.But when I use it in the SQL as parameter to unload my target table ,it doesn't work.

Select carrd_cd,carr_path,platg_carr_cd from f_abcd_path where
platg_carr_cd='KK' AND (carr_path LIKE '%${carr_path}%');

Could you help me to resolve this.

Thanks
Kavitha