Dynamic query

[Alka Srivastava <asrivastava@KPMG.COM>]

Let $AdjTypeCd = 'W-LATE'

 1. Let $Where_Clause_type_cd ='AND D.ADJ_TYPE_CD = ' ||
$AdjTypeCd
 2. Let $Where_Clause_Opr_Class = 'AND G.OPRCLASS NOT IN
($test1, $test2)'

This where clause is giving me error.

If I write it like this, it works fine.

Let $Where_Clause ='AND D.ADJ_TYPE_CD = ''TEST'''
Let $Where_Clause = 'AND G.OPRCLASS NOT IN ''TEST'''

What I am missing in the first two syntax.


Any help.


Thanks,
Alka