Re: Dynamic query

[Rod Wright <rwright@THEROUSECOMPANY.COM>]

Recode the first two to include single quotes around the concatendated variable:

          Let $Where_Clause_type_cd ='AND D.ADJ_TYPE_CD = ''' || $AdjTypeCd ||
''''






"Srivastava, Alka" <asrivastava@KPMG.COM> on 09/01/2000 01:14:28 PM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Rodney Wright/Trcb/Rouse)

Subject:  Dynamic query




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



*****************************************************************************
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else
is unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. When addressed to our clients any opinions or advice
contained in this email are subject to the terms and conditions expressed in
the governing KPMG client engagement letter.
*****************************************************************************