ADSM-L

Select odd behaviour

2002-05-01 08:49:36
Subject: Select odd behaviour
From: "Warren, Matthew James" <matthewjames.warren AT EDS DOT COM>
Date: Wed, 1 May 2002 13:49:23 +0100
(Apologies. Re-Send with correct subject line)

In addition to what I said below, the following statement generates a return
code 3 from TSM;

select db.pct_utilized,log.pct_utilized,(select count(*) from volumes where
access='READONLY'),(select count(*) from volumes where
access='UNAVAILABLE'),(select count(*) from volumes where
access='UNAVAILABLE') from db,log



but If I change the end very slightly to

select db.pct_utilized,log.pct_utilized,(select count(*) from volumes where
access='READONLY'),(select count(*) from volumes where
access='UNAVAILABLE'),(select count(*) from volumes) from db,log



(removing the :  "where access='UNAVAILABLE'")

It works fine!

Is it me, or TSM?

Thanks,

Matt.


<Prev in Thread] Current Thread [Next in Thread>