RE: [ EXTERNAL ]Re: When is a View not a View

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://lists.midrange.com/mailman/listinfo/midrange-l
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.