Re: AW: Library list for Stored procedure

On Oct 13, 2015, at 5:26 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx> wrote:

Which naming conventions (System or SQL) were used when creating the stored
procedure?
If System Naming was used, the library list at runtime is searched.
If SQL Naming is used, the default library/schema (at least for static SQL
statements) is determined at compile time. Unqualified specified Tables and
views are searched (at runtime) in the default schema determined at compile
time. For dynamic SQL it depends on the compile option DYNDFTCOL whether the
unqualified specified database objects are searched at runtime in the
default schema determined at compile time or the current schema.

Independent which naming convention is used when calling a stored procedure
or UD(T)F, the stored procedure/UDTF is executed with the same naming
convention under which they are created.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

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

-----Ursprüngliche Nachricht-----
Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
Chella R
Gesendet: Tuesday, 13.10 2015 04:58
An: midrange-l@xxxxxxxxxxxx
Betreff: Library list for Stored procedure

Hi,

I have three environments in my test server and have stored procedure entry
in 2 libraries. When the stored procedure is invoked by the .net program
outside of this server, it is executing the program as per the stored
procedure logic, but the PF/LF that is being referred to is being fetched
from another environment's library. I suppose this is down to the logic in
which the job description is assigned for the job that executes the stored
procedure. Though the QZ* job is running under QUSER, the library list I
suppose is decided by something else? Can this please be clarified on how it
is assigned, so that I can fix my issue accordingly?

Best Regards
Chella Govindarajan R


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Disclaimer~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Information contained and transmitted by this e-mail is confidential and
proprietary to IGATE and its affiliates and is intended for use only by the
recipient. If you are not the intended recipient, you are hereby notified
that any dissemination, distribution, copying or use of this e-mail is
strictly prohibited and you are requested to delete this e-mail immediately
and notify the originator or mailadmin@xxxxxxxxx
<mailto:mailadmin@xxxxxxxxx>. IGATE does not enter into any agreement with
any party by e-mail. Any views expressed by an individual do not necessarily
reflect the view of IGATE. IGATE is not responsible for the consequences of
any actions taken on the basis of information provided, through this email.
The contents of an attachment to this e-mail may contain software viruses,
which could damage your own computer system. While IGATE has taken every
reasonable precaution to minimise this risk, we cannot accept liability for
any damage which you sustain as a result of
software viruses. You should carry out your own virus checks before
opening an attachment. To know more about IGATE please visit www.igate.com
<http://www.igate.com>.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.