If the file is from a Wintel machine, then ll_name should be specified
"SOMETHING.BLAH", because the file names are in all upper case.
If it is from a unix-flavored machine, then use mixed case.
Signed,
Been there, Been burned.
-----Original Message-----
From: Cook, Dwight E [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 2:25 PM
To: [EMAIL PROTECTED]
Subject: Re: Search for file
select * from adsm.backups where ll_name="something.blah"
filespace_name is the filespace name under unix or the drive id under
win.....
the HL_NAME is the directory path (stuff left over after the filespace_name
but not including the actual file name)
and the LL_NAME is the end file name...
hope this helps
later,
Dwight
ps if you are looking for an archive, just switch to table adsm.archives
-----Original Message-----
From: Jane Doe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 1:08 PM
To: [EMAIL PROTECTED]
Subject: Search for file
Does anybody have a sql script written to search for a specific file through
the ODBC interface or the admin command line? I need to be able to search
for a file on a node without knowing the folder it resides in.
Thanks
Jane
_______________________________________________________
Send a cool gift with your E-Card
http://www.bluemountain.com/giftcenter/
