Re: Sql parameter help

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.