Re: Redirecting select statement output from a script

2005-06-03 Thread Jerico Pena
If you write a script to either create the macro and use it every time, or simply have the macro in the directory of dsmadmc then you can get the information you need just as easily. I don't know of a way to script this through TSM but externally you could do it. (I use Perl). It works perfect.

Re: Redirecting select statement output from a script

2005-06-03 Thread Matthew Large
Cheers Andy, I had my suspicions.. Looks like it's back to admin schedules running an external script which logs in - other peoples suggestions of macros are no good - you can't schedule their execution. Regards, Matthew Andrew Raibeck <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager"

Re: Redirecting select statement output from a script

2005-06-02 Thread Andrew Raibeck
I don't think that redirection is supported during the execution of a script, which is why Matthew's original error occurred. Yes, the issues regarding redirection from within the Admin CLI are that it is not easy to distinguish when '>' is for redirection versus "greater than". When redirecting f

Re: Redirecting select statement output from a script

2005-06-02 Thread Richard Sims
Redirection requires spaces around the '>'. Reference: Admin Ref manual, "Redirecting Command Output". On Jun 2, 2005, at 9:28 AM, David le Blanc wrote: Hi Matthew I notice you have a space after the '>'. I remember a discussion on how the '> redirect' gets confused with '> greater than' an

Re: Redirecting select statement output from a script

2005-06-02 Thread Richard Sims
On Jun 2, 2005, at 8:36 AM, Matthew Large wrote: Thanks for that - works a treat. Now, some of the results I expect to be zero, but instead TSM reports 'ANR2034E SELECT: No Match found'. Do you know how I can turn those results into a nice clean zero 0 for my charts. Matthew - The only real

Re: Redirecting select statement output from a script

2005-06-02 Thread David le Blanc
Hi Matthew I notice you have a space after the '>'. I remember a discussion on how the '> redirect' gets confused with '> greater than' and the (rather vague) solution was to interpret the space after the '>' as an indicator that this was a greater than, and not a redirect... hence the illegal

Re: Redirecting select statement output from a script

2005-06-02 Thread Jerico Pena
Hi Matthew, I can't say that I would know how to do that with select statements. I'm not sure if you can use if statements to print 0 if there are no matches found. But, you could script something that would replace the "no matches" with 0. Hope this helps, maybe someone else has a better soluti

Re: Redirecting select statement output from a script

2005-06-02 Thread Matthew Large
Hi Jerico, Thanks for that - works a treat. Now, some of the results I expect to be zero, but instead TSM reports 'ANR2034E SELECT: No Match found'. Do you know how I can turn those results into a nice clean zero 0 for my charts. Many Thanks, Mattheww Jerico Pena <[EMAIL PROTECTED]> Sent by

Re: Redirecting select statement output from a script

2005-06-02 Thread Jerico Pena
Hi, To redirect the output of a select statement to a file, you can write a macro for the select statement and place the redirect symbol and filename to redirect to at the end of the macro. Then just call the macro and it should work fine. ie: macro.mac: Contents of macro.mac should look lik