Issue with complex select statement not giving me usable output

[stuartc]

Ok here's the deal,

I have a request to list out all files that were deleted from a given server after a given date. I figured I could get this done by getting files that had a deactivate_date within the given time and use the output to cross check against the server in question. I structured my select as follows:

select HL_NAME,LL_NAME from backups where filespace_name='\\p2k4\j$' and (deactivate_date between '2005-01-10 00:00' and '''005-01-14 00:00') and type='FILE'



The problem is nothing is ever returned to the web page or it gets some but dies before it is done. I tried using a perl script so I could redirect output but I run into other types of problems here such as shell issues passing that select into the dsmadmc command.



Does anyone have any tricks that might help me on this?

 

[MikeyD]

Run the select statement via the TSM command line on either Windows and UNIX and output to a file.



You also tab delimit it this way and you will not get the webpage timeout, you're query will generate a lot of data.



ex: dsmadmc -tab -id=example -pass=example