What is the purpose of the following query? SELECT DBNAME, NAME FROMSYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME,TP.TSNAMEFROM SYSIBM.SYSTABLEPART TP WHERE TP.DBNAME = TS.DBNAMEAND TP.TSNAME = TS.NAME);
A. It displays the number of inconsistent rows in SYSIBM.SYSTABLESPACE.
B. It identifies which tables do not have related rows in SYSIBM.SYSTABLEPART.
C. It identifies whichtable spaces have missing related rows in SYSIBM.SYSTABLEPART.
D. It displays which rows in SYSIBM.SYSTABLEPART do not have a matching table name in SYSIBM.SYSTABLESPACE.
What is the purpose of the following query? SELECT DBNAME, NAME FROMSYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
What is the purpose of the following query? SELECT DBNAME, NAME FROMSYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!