You can also concatenate with the '||' operator, like this:

   select filespace_name || hl_name || ll_name from backups ...

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.



Richard Sims <rbs AT BU DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
05/21/2004 04:57
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: Select list of files backed up/archived on tsm?!?






...
>select * from backups where node_name='CHSU050', but that doesn't give me
>the actual name of the file, it just gives high level and low level. ...

FILESPACE_NAME + HL_NAME +  LL_NAME constitute the full path spec of the
file.
The Select is not withholding anything.
You can do like  select concat(HL_NAME, LL_NAME) from backups
to stick those two components together.

   Richard Sims