ADM - PANELID ADB1S - DROP at COMMAND line does not provide process to DROP RESTRICT ON DROP

Dropping at the command line does not allow the capability to have DROP ON RESTRICT ALTERS be generated. When entering DROP in the SELECT field, panels are displayed to accomplish this. This should also be done for DROP at the command line. This should be done with a single popup panel that allows all the restricted drops.

DB21S in DDA1 Table Spaces Row 1 to 17 of 28

Command ===> DROP Scroll ===> CSR

More:

Select Name DB Name Parts Bpool L E S I C Tbls Act pages Segsz T L

* * * * * * * * * * * * * *

------ -------- -------- ------ ------ - - - - - ----- ----------- ------ - -

SMAPH001 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH002 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH003 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH004 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH005 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH006 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH007 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH008 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH009 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH010 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH011 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH012 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH013 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH014 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH015 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH016 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH017 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

ADB21S in DDA1 Confirm Drop - Table Spaces Row 1 to 13 of 2

Command ===> Scroll ===> CSR

Enter required field More:

Confirm that the following table spaces are to be dropped.

Select a choice.

1 1. Continue to drop all the listed table spaces

2. Cancel drop

Select Name DB Name Parts Bpool L E S I C Tbls Act pages Segsz T L

------ -------- -------- ------ ------ - - - - - ----- ----------- ------ - -

SMAPH001 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH002 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH003 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH004 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH005 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH006 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH007 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH008 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH009 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH010 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH011 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH012 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

SMAPH013 DLOADMAP 1 BP1 A N A N Y 1 -1 64 G Y

ADB2E1 in --------------------- DB2 Error Display 1 --------------------- 10:4

Command ===>

Rollback done

SQLCODE : -672 DSNTIAR CODE : 0

DSNT408I SQLCODE = -672, ERROR: OPERATION DROP NOT ALLOWED ON TABLE

LOAD.PGHST001

DSNT418I SQLSTATE = 55035 SQLSTATE RETURN CODE

DSNT415I SQLERRP = DSNXIDTB SQL PROCEDURE DETECTING ERROR

DSNT416I SQLERRD = 25 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION

DSNT416I SQLERRD = X'00000019' X'00000000' X'00000000' X'FFFFFFFF'

X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION