When using System Naming convention the library list can be set within IBM i
Navigator's Run an SQL Scripting tool, by selecting
Connection --> JDBC Settings --> System --> Schema list
Reconnect after having set the library list.
Another way to modify the library list is to execute a CL command, such as
ADDLIBLE, RMVLIBLE or CHGLIBL. The CL command must be prefixed with CL and
ended with a semi colon. After it can be executed like any SQL command.
Example:
cl: ADDLIBLE LIB(MYLIB) POSITION(*AFTER QTEMP);
BTW If a default/current schema is explicitly set, the library list is not
searched to find unqualified specified tables or views, not even if System
Naming conventions are used.
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-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von CRPence
Gesendet: Saturday, 25.5 2013 00:23
An: midrange-l@xxxxxxxxxxxx
Betreff: Re: syntax issue
The default for SQL is to use the Authorization Identifier as the
qualifier for unqualified TABLE-references in a statement.
Resolve the issue in one of the following ways:
- change the connection properties to use *SYS naming vs *SQL naming, for
which unqualified table-references use *LIBL; then of course, the TABLE
names expected to be found must be in the Library List of the server job...
which is yet more connection properties
- SET CURRENT SCHEMA to the library name where the file(s) reside
- explicitly qualify the TABLE name with its schema [library] name
Regards, Chuck
On 24 May 2013 15:14, Crystal Reports wrote:
I did run finally the SQL query but had some errors why is it using my
name as the library
Connected to relational database S9090abc on 1nn.1nn.n.n as
crystalcleardecisions - 644367/Quser/Qzdasoinit
SELECT <<SNIP>>
FROM OEORH41 INNER JOIN REFER1 <<SNIP>>
SQL State: 42704
Vendor Code: -204
Message: [SQL0204] OEORH41 in crystalcleardecisions type *FILE not
found. <<SNIP>>
--
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.
midrange.com
