RE: Imbedded SQL fails

[rob@xxxxxxxxx]

Thanks Gord,

I had it that way at one time but changed it.  The interim problem was that
the length of Exchange was wrong.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    Gord Royle
                    <GRoyle@cott.com>       To:     "'rpg400-l@midrange.com'" 
<rpg400-l@midrange.com>
                    Sent by:                cc:
                    rpg400-l-admin@mi       Fax to:
                    drange.com              Subject:     RE: Imbedded SQL fails


                    02/12/2002 09:51
                    AM
                    Please respond to
                    rpg400-l






Hi Rob

I think that your where clause is passing the value of :ex and :ac with
imbedded 'apos' values ie  (and eold=:ac and eexc=:ex) translates as
(eold=''123'' and eexc=''246''). I think that you can just say (where
eold=:OldAreaCode and eexc=:Exchange)

Gord Royle

-----Original Message-----
From: rob@dekko.com [mailto:rob@dekko.com]
Sent: Tuesday, February 12, 2002 9:31 AM
To: rpg400-l@midrange.com
Subject: Imbedded SQL fails

<snip>

I have an SQL statement that fails in my RPG but not when ran
interactively.

     C/EXEC SQL
     C+ SELECT enew into :retField
     C+ from exfile join acfile on eold=cold
     C+ where enew=cnew and days(curdate())-days(
     C+ date(cepmth concat '/' concat cepday concat '/' concat cepyr))
<:CutDays
     C+ and eold=:ac and eexc=:ex
     C/end-exec

<end>


Cott - The Leader in Premium Retailer Brand Beverage Innovation.


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.