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
midrange.com
