chaitanya bharath
New User
Joined: 15 Apr 2016 Posts: 1 Location: India
|
|
|
|
Hi ,
Need to know what will happen in the below scenario.
UNLOAD TABLESPACE
DB2 YES
SELECT *
FROM TableA
WHERE NST_ID = 'XYZ'
AND XY_ID IN ('ADB', 'PVR')
AND XYZID IN (SELECT XYZID FROM TableA
WHERE XY_ID = 'ADB'
AND ACCESS != '4');
OUTDDN (SYSREC)
UNLOAD SHRLEVEL CHANGE CONSISTENT NO INFILE IMAGECOPY FULL 0
SELECT *
FROM TableA
WHERE NST_ID = 'XYZ'
AND XY_ID IN ('ADB', 'PVR')
AND XYZID IN (SELECT XYZID FROM TableA
WHERE XY_ID = 'ADB'
AND ACCESS != '4'); |
|