RE: library list vs Run SQL Scripts

Check whether you set a Default/Current schema.
If a Default/Current schema is explicitly set (in the connection or by
executing the SET CURRENT SCHEMA command), the library list is ignored, even
when working with *SYS naming conventions.

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!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob
Berendt
Sent: Freitag, 4. Oktober 2019 16:24
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: library list vs Run SQL Scripts

I changed the JDBC configuration again. Changed the format from *SQL to
*SYS. Now it searches the library list. However it still does not find the
table: LOOKUP_TABLE in *LIBL type *FILE not found.

My bad. When you edit the JDBC configuration it closes a few things. Like
the
cl: addlible gdihq;
statement. Had to run that again.

Now it works.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob
Berendt
Sent: Friday, October 4, 2019 10:00 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: library list vs Run SQL Scripts

Version: 1.1.8.2

JDBC Configuration:
Default SQL Schema: Use library list of server job
Library list: *LIBL

select *
FROM QSYS2.LIBRARY_LIST_INFO;
Shows GDIHQ as an entry.

select *
from SYSIBM.sqltables
where table_name = 'LOOKUP_TABLE'
;
Says it is in GDIHQ.

Here's the problem:
select Lookup_value_integer
from LOOKUP_TABLE
where Lookup_item = 'JOURNAL_SEQUENCE_NUMBER'
;
SQL State: 42704 Vendor Code: -204 Message: [SQL0204] LOOKUP_TABLE in ROB
type *FILE not found.
Why is it looking in ROB?



Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com