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



i5/OS SQL allows two different object naming types: *SYS and *SQL.

Naming *SYS uses the job's library list to find objects, and the
separator between schema and object (library and object) is "/":
SYSIBM/SYSDUMMY1.

Naming *SQL uses SQL rules to find objects: typically objects are
qualified, or otherwise found in the schema with the same name as the
user making the request IIRC. The separator is ".": SYSIBM.SYSDUMMY1.

HTH,
Loyd

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Lowary, Jim
Sent: Thursday, April 30, 2009 12:54 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: SQL question on default *LIBL at connection

Elvis,

No it is *SQL, but when we try and create it with *SYS; we are getting,
Message: [SQL5016] Qualified object name GETAGENT not valid."

So not sure what we might be doing wrong.


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.