Re: Calling Scott's IFSDIR Stored procedure error -- RPG400-L

I moved to using QSYS2.IFS_OBJECT_STATISTICS and it works for me.

I had a main program that was reading a cursor and calling the program with
IFSDIR for every row.

I was closing my cursor after a single fetch.

On Wed, May 24, 2023 at 1:37 PM Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

Ok, yeah...I was just glancing at it...

Hmmm...

How are you using it?

For instance, in his demo code, he is using it in a cursor and his code
includes a close of the cursor. Which should fire the close_event and thus
the closedir.

Charles

On Wed, May 24, 2023 at 11:11 AM Art Tostaine, Jr. <atostaine@xxxxxxxxx>
wrote:

I didn't create it so I'm not sure how they did it. His CRTIFSDIR program
has NO FINAL CALL.
I'll try to run CRTIFSDIR again.

On Wed, May 24, 2023 at 1:01 PM Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

Hmmm...

How are you calling it?

The error would imply that the closedir is not getting called...

Did you create everything using Scott's CRTIFSDIR program?

If you ran the CREATE FUNCTION manually, did you include FINAL CALL?
That's what should cause the closedir to be called.

Charles

On Wed, May 24, 2023 at 10:44 AM Art Tostaine, Jr. <

atostaine@xxxxxxxxx>

wrote:

I'm calling this many times to check if a file wildcard exists.

After

using it about 100 times it's returns this error:

1 -- The external program or service program returned SQLSTATE

38998.

The
text message returned from the program is: opendir: Too many open

files

for
this process. .

Has anyone seen this before?
--
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.

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

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

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