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