Code Place

FIND ALIASES WITHOUT EXISTING TABLES  

Aug 30, 2018 04:40 PM

SQL statement for DB2 on Z; identify and create DROP statements for all aliases whose tables (or views) do not currently exist.  (Uses Common Table Expression and UNION to create multi-line output)

Attachment(s)
docx file
ALIASES WITHOUT EXISTING TABLES.docx   14 KB   1 version
Uploaded - Jun 05, 2020
txt file
FIND ALIASES WITHOUT EXISTING TABLES.txt   3 KB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.