All,
Seems that the order you specify tables in an SQL query is important. I'm running TSM
5.1.6.1 on AIX 5.1. I wanted to query volhistory and backupset tables:
tsm: SM040>select VOLUME_NAME, location, backupset_name from BACKUPSETS, VOLHISTORY
where BACKUPSETS.DATE_TIME = VOLHISTORY.DATE_TIME
VOLUME_NAME LOCATION BACKUPSET_NAME
------------------ ------------------ ------------------
A00249 HKGIICOREP1.20030-
805.77813798
tsm: SM040>select VOLUME_NAME, location, backupset_name from volhistory, backupsets
where BACKUPSETS.DATE_TIME = VOLHISTORY.DATE_TIME
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.
tsm: SM040>
The first result is the result I wanted.
Why is the order of tables important? Is this documented somewhere? I'm concerned
that I may not be getting correct data in other queries I run.
Mark
--
Mark Ferraretto
Unix Systems Administrator
Deutsche Bank Hong Kong
w: +852 2203 6362 m: +852 9558 8032 f: +852 2203 6971
[EMAIL PROTECTED]
--
This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorized copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
