× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



how is that different than this?

closqlcsr = *ENDMOD,

I really want to try this but I had stripped out that external proc and put
in a *PGM so I can run that pgm in *CALLER... I can't change the *SRVPGM to
*CALLER as other external procs are being called fine from it by other
processes and don't want to impact any of that.

If I still get the lock with my new *CALLER *PGM I will implement this sql
opt also.

thanks a bunch!

Jay

On Wed, Jul 20, 2022 at 11:34 AM Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

Pseudo-closed cursor?

Try adding
clssqlcsr = *ENDMOD

to your SET OPTION statement...

Normally not recommended...

Charles

On Wed, Jul 20, 2022 at 9:22 AM Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

unfortunately not... but I think I will take your advice and revert my
attention to my "real" CLLE

But what could possibly be in there that would be interfering with a DLTF
for a temp file created in my external procedure that is only used in
that
external proc?

thanks!

Jay

On Wed, Jul 20, 2022 at 11:19 AM Daniel Gross <daniel@xxxxxxxx> wrote:

So let me recite Linus Thorvalds "Talk is cheap, show me the code" ;-)

I think that then, the program lies in your "real" CLLE - not in the
"test" CLLE. Are you in the position to post the source? And the build
commands?

Regards,
Daniel

Am 20.07.2022 um 17:15 schrieb Jay Vaughn <jeffersonvaughn@xxxxxxxxx
:

so to entertain this theory of death and destruction...

I created a new test CLP that runs in DAG.
It calls my current test CLLE that I just changed to *CALLER.
*CALLER calls my *SRVPGM running in its named actgrp.
But runs fine - no locks on my files.

so this is the same model as the layout that does not work right..
but
this
runs fine.

What else?

Jay

On Wed, Jul 20, 2022 at 11:02 AM Charles Wilt <
charles.wilt@xxxxxxxxx

wrote:

Besides calling the *SRVPGM procedures...

What else are the CLLE *PGM's doing?

I too suspect there's a problem running the *CALLER CLLE in the
(poorly
named) default activation group (DAG).

For instance, if you are calling the CLLE from the command line,
then
it
would get activated into the DAG. Running ILE code it the DAG is
one
of
Jon Paris' 7 deadly sins of ILE.

Also as mentioned, best practice would be to have the SRVPGM as
*CALLER.
Your CLLE should be either a named activation group or *NEW.

Charles

On Wed, Jul 20, 2022 at 8:18 AM Jay Vaughn <
jeffersonvaughn@xxxxxxxxx

wrote:

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

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

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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.