Re: sql prepare

This is a guess, but if you try
CHGJOB LOG(4 00 *SECLVL) LOGCLPGM(*YES)
and
STRDBG PGM(*NONE) UPDPROD(*YES)
and analyze your joblog does that help?

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



                    "Smith, Mike"
                    <Mike_Smith@RGCReso       To:     "'rpg400-l@midrange.com'" 
<rpg400-l@midrange.com>
                    urces.com>                cc:
                    Sent by:                  Fax to:
                    rpg400-l-admin@midr       Subject:     sql prepare
                    ange.com


                    02/27/2002 11:29 AM
                    Please respond to
                    rpg400-l






I have a program that uses a prepare statement.  This program has up until
now had my own parameter markers and i did replaces on the string in order
to place my values.
I'm now trying to turn this into real parameter markers ?
i'm getting error code -514 but my real question is how do i see the entire
select statement after it has done the replacement of my values for the ?
marks.


Thanks

Mike
_______________________________________________
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.