Re: SQL Question

[Pete Helgren <Pete@xxxxxxxxxx>]

No better way I know of either.  I am not sure how you *could* do it 
differently since the Prepare has no way to know how those markers 
relate to one another.

Pete

Michael_Schutte@xxxxxxxxxxxx wrote:
> All 5 times.  You must provide one replacement variable for each parameter
> marker. as i understand it.
>
>
> Michael Schutte
> Admin Professional
> Bob Evans Farms, Inc.
>
>
> rpg400-l-bounces@xxxxxxxxxxxx wrote on 10/29/2008 03:33:45 PM:
>
>   
> > I have a dynamic SQL statement with parameter markers.
> > The field value that I want to use is the same for all 5 parameters.
> > In the Open statement, do I have to list the field all 5 times (once
> > for each ? in the SQL statement) or is there a better way?
> >
> > TIA,
> >
> > Jeff Young
> > Sr. Programmer Analyst
> > IBM -e(logo) server Certified Systems Exper - iSeries Technical
> > Solutions V5R2
> > IBM  Certified Specialist- e(logo) server i5Series Technical
> > Solutions Designer V5R3
> > IBM  Certified Specialist- e(logo)server i5Series Technical
> > Solutions Implementer V5R3
> > --
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> >     
> list
>   
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> >
> >