Re: Sql parameter help

[aender.lara@xxxxxxxxx]

Hi,

You can do it, you must use the sentence PREPARE of SQL, you must create the sentence declare with variables.

Regards.
Aender Lara
Computer consulting in AS400 and ERP BPCS
Mexico city
Enviado desde mi oficina móvil BlackBerry® de Telcel

-----Original Message-----
From: Luis Rodriguez <luisro58@xxxxxxxxx>
Sender: rpg400-l-bounces@xxxxxxxxxxxx
Date: Mon, 24 Jan 2011 14:14:22 
To: RPG programming on the IBM i / System i<rpg400-l@xxxxxxxxxxxx>
Reply-To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Subject: Re: Sql parameter help

Mike,

Why do you need Dynamic SQL? You can change your statement to embedded SQL
by using:

EXEC SQL
select * from oncontac00 join ondept00
         on coid = onid
         where colast >= :COLAST_VAR +
         and coid = :COID_VAR +
         order by COlast
;

Also, check the use of the CASE statement. It could help you with dealing
with different conditions.

HTH,


Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Mon, Jan 24, 2011 at 2:04 PM, Smith, Mike <Mike_Smith@xxxxxxxxxxxxxxxx>wrote:

> I'm working on a sql subfile program and I'm trying to make use of
> parameter markers.
> I can get it working when only doing a Position to marker, but now I
> have introduced more complex criteria and I can't figure out how to make
> this work effectively.
>
> Subfile has a Position TO field.  This should be a parameter marker.
> Also I'm allowing user to select a specific department.  This should be
> a parameter marker
>
>  selct = 'select * from oncontac00 join ondept00 +
>          on coid = onid +
>          where colast >= ? +
>          and coid = ? +
>          order by COlast' ;
>
> Do I need to set up multiple select statements for all possible
> conditions?
> Do I need to set up multiple open statements to coincide with the
> different conditions also.
>
> Any examples would be appreciated.
>
> Thanks
>
> Mike
>
>
>
> NOTICE:  This message, including any attachment, is intended as a
> confidential and privileged communication. If you have received this message
> in error, or are not the named recipient(s), please immediately notify the
> sender and delete this message.
> --
> This is the RPG programming on the IBM i / System i (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.