hi all ! there is a need to now all archived files from a special node, so i tried the following:
select LL_NAME,count(*) from archives where NODE_NAME='cob03' group by LL_NAME ...it worked fine. but now i want this output in a file (linux), so i typed select LL_NAME,count(*) from archives where NODE_NAME='cob03' group by LL_NAME > /path/filename the result is ANR8038E ...unable to open file '/path/filename' for redirection i wondered, and tried select LL_NAME,count(*) from archives where NODE_NAME='cob03' group by LL_NAME > /filename the result seems to be allright, but the file 'filename' is not on the system - 'find' couldn't find it anywhere can anyone tell me, what the solution is ?? any idea is welcome thank you very much! regards, Dierk
