... and why won't you simply use System Naming conventions instead of SQL
Naming conventions?
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@xxxxxxxxxxxxxxxxxx> On Behalf Of John
Yeung
Sent: Freitag, 11. Februar 2022 16:53
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxxxxxxxx>; Midrange
Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [IBMiOSS] UDF works in STRSQL but not over ODBC using Python
Thank you all for your responses. They each gave me clues, and ultimately
helped me figure out how to make it work!
In my case, I had two issues to resolve. First, SQL couldn't find the
function. This was remedied by either qualifying the function name on the
call, or by setting the CURRENT PATH special register appropriately before
using the unqualified function name.
Second, once SQL could find the function and call it, the underlying RPG
program needed an additional library to be added to the library list (which
is not the same thing as the SQL path). Without it, I would get SQL0443
(general program error, very nondescript).
John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-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
