|
All,
The vendor got back to me and said they opened up the tool to allow it
to see system tables.
Based on this, I believe Jim was right in saying I should open a
ticket with IBM.
How is this view being created, which based on discussions with
internal developers, created no differently than other views, so as an
object it is being seen as a system table.
Ken
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Ken Meade via MIDRANGE-L
Sent: Thursday, December 19, 2024 9:34 AM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Ken Meade <kmeade@xxxxxxxxxxxxxxxxx>
Subject: RE: [ EXTERNAL ]Re: When is a View not a View
Martijn and All,
These views are all in the same library and All looked normal in the
sys catalogs.
UPDATE:
The vendor for my new product sent me an updated Jar file last night
and we got it loaded this morning. It has addressed the issue within
this toolset.
I do have some open questions as to what they did to make this work,
and if I get an answer I'll report back here.
Like I had noted this is also happening in the ODBC driver, not
associated with this vendor's product and so, my feeling is that there
is something, somewhere that is defining these objects a bit
differently. But, I'm not finding it in any of the QSYS2 files I've looked at thus far.
But it's working where I need it working, and so I can continue our
migration process.
Thanks to all with your ideas!
Ken
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Martijn van Breden
Sent: Thursday, December 19, 2024 2:01 AM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [ EXTERNAL ]Re: When is a View not a View
[You don't often get email from m.vanbreden@xxxxxxxxxxxxxxxxxxxxxxxxxx.
Learn why this is important at
https://aka.ms/LearnAboutSenderIdentification ]
Hello Ken,
That's pretty peculiar... a couple of things pop up in my head:
1.
Are these views all defined in the same library/schema?
2.
If not, are all libraries defined as schemas, so with their own views
on the catalog?
3.
Do you see any particular differences in their definitions when you
query the views in the system catalog (qsys2.sysviews and
qsys2.sysviewdep)
Kind regards, Met vriendelijke groet,
Martijn van Breden
lead software architect
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
https://list/
s.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=05%7C02%7Ckmeade
%40littletoncoin.com%7Cbfb827d2cab44b59b29008dd205bd845%7Cf671045cabcb
483e800849f5e77d0a0d%7C0%7C0%7C638702301044242631%7CUnknown%7CTWFpbGZs
b3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIj
oiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=16TwVKab6fhc2QsPtpEers7x
pEHeurfkL6sHHXfQcYY%3D&reserved=0 or email:
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
https://list/
s.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=05%7C02%7Ckmeade
%40littletoncoin.com%7Cbfb827d2cab44b59b29008dd205bd845%7Cf671045cabcb
483e800849f5e77d0a0d%7C0%7C0%7C638702301044297765%7CUnknown%7CTWFpbGZs
b3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIj
oiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=xxRIWVXuZKYZrR%2Fm3Ng%2B
c2rIPlNWh1CYFKLjjZi7ZOg%3D&reserved=0
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
