What is the SQLCODE or SQLSTATE that is returned?
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
SReeves@xxxxxxxxxxxxxxxxxx
Sent: Mittwoch, 23. Juni 2021 17:59
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: SQLRPGLE & variable path
Hi,
I'm testing out using SQLRPGLE which I haven't really touched before.
The command I'm running is
EXEC SQL select NETSERVER_SESSION into :pHold from
table(IFS_OBJECT_LOCK_INFO(Path_NAME => '/home/IBMIFS/file.csv'
));
Which works as above with the hard-coded path.
However when I pull out the hard-coded path and pass it as a variable, the
command doesn't return a result. In debug the variable/path returns exactly
as it is shown in the first test. Can a variable not be used?
pPath = '/home/IBMIFS/file.csv'; //first test
pPath = '''/home/IBMIFS/file.csv'''; //second test
EXEC SQL select NETSERVER_SESSION into :pHold from
table(IFS_OBJECT_LOCK_INFO(Path_NAME => :pPath));
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.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
