Catalog Views in SQL:
SYSVIEWS, SYSINDEXES, SYSCOLUMNS, etc.
There is also a view which shows dependencies between views: SYSVIEWDEP
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
"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 Greg
Wilburn
Sent: Donnerstag, 9. Juni 2022 19:37
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Working with Schemas & Run SQL Scripts in ACS
It very well could be nested in another view. Unfortunately, I had created
many of these in RDi and stored them in my workspace (which was lost during
an attack last year).
I used CREATE OR REPLACE VIEW to change V_BOX_TYPES. I don't recall ever
touching the view that was deleted. HOWEVER, that view does contain a join
to V_BOX_TYPES.
Mark brings up a VERY good question.
DSPDBR works well for PF or Tables... but what about Views within Views
within Views? I have lots of those. Would be nice to see my woven web of
views.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Birgitta Hauser
Sent: Thursday, June 9, 2022 10:17 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Working with Schemas & Run SQL Scripts in ACS
Could it be a nested view, i.e. a view that is used in a different view.
And you just (re)created the first view and not the dependent one?
Did you work with CREATE VIEW or CREATE OR REPLACE VIEW
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization - Education - Consulting on IBM i
"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 Greg
Wilburn
Sent: Donnerstag, 9. Juni 2022 15:12
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Working with Schemas & Run SQL Scripts in ACS
While working with ACS Run SQL Scripts and the Schemas applications,
something very strange occurred.
I used Schemas to locate an SQL View called V_BOX_TYPES and generate SQL in
Run SQL Scripts - I wanted to add a column.
This morning, one of our reports was failing because another view in that
same library was completely missing - the object was just gone. I went into
Schemas to find two objects I didn't recognize.
"Box Types" was the description of the view I was changing.
"Closing Log" was the description of the view that was deleted.
"GWILBURN" is me.
The timestamp is right is virtually the same time I modified V_BOX_TYPES.
Q_AT000003
Q_AT000003
QDFTOWN
GWILBURN
06/08/2022 04:49:48 PM
Box Types
Q_AT000004
Q_AT000004
GWILBURN
GWILBURN
06/08/2022 04:49:48 PM
Closing Log
Any ideas how I would have mucked this up?
TIA
[Logo]<
https://www.totalbizfulfillment.com/> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
1 Corporate Dr
Grantsville, MD 21536
www.totalbizfulfillment.com<
http://www.totalbizfulfillment.com>
--
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.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
--
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.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
--
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.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
