Re: Indexes not in a job's library list

I am using a V7R3 system.

I have a library that has a data file in it [DDS] and a SQL index over it
in that same library. That SQL index is also duplicated in another
developer library, so the DDS file has two SQL indexes over it, one in the
developer's library, and one in the library the data file is located in.

I call a program that has a SQL statement in it in a session that does not
have the developer's library name in the library list. When I entered
WRKACTJOB and took option 5 then 14 on that job, the list showed the
program had open the SQL index in the developer library, something I was
surprised to see.

I then deleted the file in the developer's library and called the program
again. The 5-14 then shows the program using the same index, but the one
in the library where the data file is located, which is correct.

Has anyone experienced this, where an SQLRPGLE program uses indexes that
are not in its library list? There is no hardcoding in the program source
to go to the developer's library.

Thank you,

Doug


"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments
accompanying it) contain confidential information belonging to the sender.
The information is intended only for the use of the intended recipient. If
you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution or the taking of any action in reliance
on the contents of the information is strictly prohibited. Any
unauthorized interception of this transmission is illegal under the law.
If you have received this transmission in error, please promptly notify the
sender by reply e-mail, and then destroy all copies of the transmission."
--
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