Dave,
Here is an example of an SQL statement that has a mix of hard coded and variable values. The host variables are always preceded by a colon ':'.
Exec SQL
select substr(sxdata,1,32) into :hld_pcdesc
from sycdx
where sxcomp = 'I' and
sxnem = 'PC' and
sxrgn = '*' and
substr(sxcde,1,2) = :hld_pc;
Eric Hill
Senior Software Developer
Integrated Corporate Solutions
ehill@xxxxxxxxxxxxx
256-760-8239
NOTICE:
This message may contain privileged or otherwise confidential information.
If you are not the intended recipient, please immediately advise the sender
by reply e-mail and delete the message and any attachments without using,
copying or disclosing the contents.
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Dave
Sent: Monday, October 9, 2023 8:26 AM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: Embedded SQL host variables
CAUTION: This email originated from outside the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
OK I’m on 7.3 now and I still don’t know how to define a host variable without hard coding it.
Any advice ?
Thanks
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
midrange.com
