With Restrict on Drop

Steve Grimes

With Restrict on Drop
Hello, DB2 7.2, Z/os 1.4 here.

Does anyone know how to find out whether a table is defined as "Restrict on
Drop"? I can't seem to find it in SYSTABLES.

TIA!

Stg

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

HEPP SHERY C

Re: With Restrict on Drop
(in response to Steve Grimes)
Hi Steve- check the clustertype column in systables.

Regards, Shery

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: Monday, January 03, 2005 2:00 PM
To: [login to unmask email]
Subject: [DB2-L] With Restrict on Drop

Hello, DB2 7.2, Z/os 1.4 here.

Does anyone know how to find out whether a table is defined as "Restrict on
Drop"? I can't seem to find it in SYSTABLES.

TIA!

Stg

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Al Greuter

Re: With Restrict on Drop
(in response to HEPP SHERY C)
Use the field CLUSTERTYPE to determine if it has Restrict on Drop. If it is
blank you can drop it. If it is Y you cannot drop it with remove the
RESTRICT first.

HTH
Thanks,

Al Greuter
Lockheed Martin
DB2 Database Administrator
(410) 496-9547

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of [login to unmask email]
Sent: Monday, January 03, 2005 4:00 PM
To: [login to unmask email]
Subject: [DB2-L] With Restrict on Drop

Hello, DB2 7.2, Z/os 1.4 here.

Does anyone know how to find out whether a table is defined as "Restrict on
Drop"? I can't seem to find it in SYSTABLES.

TIA!

Stg

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steve Grimes

Re: With Restrict on Drop
(in response to Al Greuter)
Cool -- ClusterType works! (I did before and after Selects.)

Thanks!

Stg

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm