RE: SQL wrapper around service program -- RPG400-L

Hi Martijn,

have you thought about procedure overloading?
Did you pass the parameters in the expected format (data type / length).
If you are testing with constant values try to cast the values into the expected data type.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization – Education – Consulting on IBM i

"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 Martijn van Breden
Sent: Dienstag, 22. November 2022 09:57
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: SQL wrapper around service program

Hello Buck

Thank you for thinking with me. I didn't yet think of an authority failure resulting in a 'not found error'. I use the same profile in 5250 and ACS though and via a group profile I have *AllObj so that should be enough 😊

We have an initial script that I can run from 5250, ACS and RDi. I checked the results from the Library_List_Info view and they match my expectations. So, still no clue of why this is happening.

Kind regards

Martijn van Breden
lead software architect

--
Pantheon Automatisering B.V.
T. 0513 657 357
M. 06 2075 2931

E-mail disclaimer

-----Oorspronkelijk bericht-----
Van: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> Namens Buck Calabro
Verzonden: maandag 21 november 2022 17:01
Aan: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Onderwerp: Re: SQL wrapper around service program

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

On Fri, 18 Nov 2022 at 11:34, Martijn van Breden <m.vanbreden@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I checked the library list (over and over again...) and looked in SYSPROCS and SYSROUTINES for anomalies but couldn't find anything.

Is the same user profile doing the CALL in both environments?
Authority can cause a 'not found' error.
I sometimes forget that the ACS scripting tool does not run my initial program, but green screen does - which sets my green screen library list but not my ACS *LIBL.
I tend to check the library list this way: select * from qsys2.library_list_info; Often, I find that I need to alter the *LIBL is ACS like: cl: addlible pwslib *first

--buck
--
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
--
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