LISTDEF wildcard question

JH

LISTDEF wildcard question
To all:
Is there a way to wildcard all database under one
LISTDEF?
ie.
LISTDEF J INCLUDE TABLESPACES DATABASE *

I tried with no sucess.

The best I could do is
LISTDEF J INCLUDE TABLESPACES DATABASE A*
INCLUDE TABLESPACES DATABASE B*
etc....

Thanks for your advice





__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------------------------
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

Ahmed Elbana

Re: LISTDEF wildcard question
(in response to Dave Petronella)
Hi,

You may try that:


LISTDEF NAME1 INCLUDE TABLESPACE DBxx001.*
INCLUDE TABLESPACE DBxx001.*
EXCLUDE TABLESPACE DBxx001.SS*

Thanks, Ahmed.




JJ <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/28/2006 10:27 AM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[DB2-L] LISTDEF wildcard question






To all:
Is there a way to wildcard all database under one
LISTDEF?
ie.
LISTDEF J INCLUDE TABLESPACES DATABASE *

I tried with no sucess.

The best I could do is
LISTDEF J INCLUDE TABLESPACES DATABASE A*
INCLUDE TABLESPACES DATABASE B*
etc....

Thanks for your advice





__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------------------------
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



*************************** IMPORTANT
NOTE***************************** The opinions expressed in this
message and/or any attachments are those of the author and not
necessarily those of Brown Brothers Harriman & Co., its
subsidiaries and affiliates ("BBH"). There is no guarantee that
this message is either private or confidential, and it may have
been altered by unauthorized sources without your or our knowledge.
Nothing in the message is capable or intended to create any legally
binding obligations on either party and it is not intended to
provide legal advice. BBH accepts no responsibility for loss or
damage from its use, including damage from virus.
************************************************************************

---------------------------------------------------------------------------------
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

Dave Petronella

Re: LISTDEF wildcard question
(in response to JH)
Try

LISTDEF J INCLUDE TABLESPACE A.*
INCLUDE TABLESPACE B.*


Thanks.
Dave.
x7747



JJ
<[login to unmask email]
> To
Sent by: DB2 Data [login to unmask email]
Base Discussion cc
List
<[login to unmask email] Subject
ORG> [DB2-L] LISTDEF wildcard question


12/28/2006 10:27
AM


Please respond to
DB2 Database
Discussion list
at IDUG
<[login to unmask email]
2-L.ORG>






To all:
Is there a way to wildcard all database under one
LISTDEF?
ie.
LISTDEF J INCLUDE TABLESPACES DATABASE *

I tried with no sucess.

The best I could do is
LISTDEF J INCLUDE TABLESPACES DATABASE A*
INCLUDE TABLESPACES DATABASE B*
etc....

Thanks for your advice





__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

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