Hello TSM'ers
I am trying to run the following simple SQL query
select db.pct_utilized,log.pct_utilized,(select count(*) from volumes where
access='READONLY'),(select count(*) from volumes where access='UNAVAILABLE')
from db,log
The above works fine, but if I add 'as' into it like so;
select db.pct_utilized,log.pct_utilized,(select count(*) as 'READONLY' from
volumes where access='READONLY'),(select count(*) as 'UNAVAILABLE' from
volumes where access='UNAVAILABLE') from db,log
I get an unexpected literal SQLtoken. Am I worng in how I am writing the
'as' statements?
Also, if I extend the top command to read
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
(the last bracketed select is simply repeated again)
I get nothing but a return code 3 from TSM.
Am I wildy innacurate with my SQL selects, or are there some 'odd
limitations' to TSM's pseudo-select queries.
Thanks,
Matt.
|