The SET PATH Statement is necessary when using SQL Naming convention for
finding unqualified specified stored procedures, user defined functions or
user defined table functions.
When using SQL Naming conventions are used the libraries specified in the
SET PATH Statement is searched. The real library list is ignored.
The special value *LIBL can be specified in the SET PATH statement.
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: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> On Behalf Of David Gibbs
Sent: Dienstag, 26. Juni 2018 21:27
To: midrange-l@xxxxxxxxxxxx
Subject: 'SET PATH' statement when using QSQGNDDL api or GENERATE_SQL
procedure?
Folks:
Does anyone know what controls the value of the 'SET PATH' statement that
appears when you use the QSQGNDDL api or GENERATE_SQL procedure?
99% of the time it's set to *LIBL ... but on very rare occasions I've seen
libraries (although I can't remember a specific instance).
Thanks!
david
--
IBM i on Power Systems: For when you can't afford to be out of business!
I'm riding 615 miles (Yes, you read that right) in the American Diabetes
Association's Tour de Cure to raise money for diabetes research, education,
advocacy, and awareness. You can make a tax deductible donation to my ride
by visiting
https://mideml.diabetessucks.net.
You can see where my donations come from by visiting my interactive donation
map ...
https://mideml.diabetessucks.net/map (it's a geeky thing).
I may have diabetes, but diabetes doesn't have me!
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
