Re: ILE and locked file

Do the CLs perform all four calls, or do the CLs perform one call and the
CLs are called four times?

If the CLs are called four times, the *NEW CL disposes of the activation
group after every call. The *CALLER CL would not. What does the SQL? If
it's an ILE program, what's the CLOSQLCSR() setting?



date: Wed, 20 Jul 2022 10:17:54 -0400

from: Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
subject: ILE and locked file

I have a *SRVPGM that runs in a named activation group.
It contains a procedure that does the following...
- dltf qtemp.file
- create table qtemp.file
- inserts/updates the qtemp.file

From a CLLE pgm that runs in *NEW, I am testing this procedure call in the

*SRVPGM.
The procedure is called 4 different times with no issues. Expected results
for each call.

Now I place those same 4 calls to the procedure into a different CLLE that
runs in *CALLER (this may have nothing to do with it but just throwing it
out there).
On the 2nd call to the procedure when it tries to do the DLTF, it cannot
allocate the file and fails.
I have tried to DLCOBJ the file from lock state *SHRRD prior but that does
not work.
(when i do a wrkobjlck on the qtemp.file I see it is locked with *SHRRD)

What are my other options to overcome this? Why does it not do this in my
test CLLE?

tia

Jay