Indeed yes - I realize now that your question was not one of syntax, it was of other behavior.

Oh, well, an answer that didn't matter!  :)

Vern

On 3/16/2020 7:57 AM, Justin Taylor wrote:
*LIBL works differently between the two.

"--For system naming, the default schema is the job Library List (*LIBL)
--For SQL naming, the default schema currently used in the SQL environment where the SQL routine is created will be adopted."
https://www.ibm.com/developerworks/ibmi/library/i-system_sql2/index.html


Thanks




-----Original Message-----
From: Vernon Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxx]
Sent: Saturday, March 14, 2020 4:54 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Determine SQL or System naming?

Seems I recall that one can use either system or sql naming - either works with no need to set it one way or the other.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

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.