Hi TSM world, I may be missing the obvious here, but TSM is complaining about the format of my select statement before it reaches the redirect, but the statement works absolutely fine from the command line.
Here's the statement: select 'upd node', node_name as "node_name ", 'clo=""' from nodes where lastacc_time <=current_timestamp - 32 days > redirection.txt And the batch file reads: ---- pushd "c:\program files\tivoli\tsm\baclient" "c:\program files\tivoli\tsm\baclient\dsmadmc" -tcpserveraddress=172.17.31.165 -id=tsmops -pa=tsmops -dataonly=y -commadel select 'upd node', node_name as "node_name ", 'clo=""' from nodes where lastacc_time <=current_timestamp - 32 days > redirection1.txt ---- But when I run it from the command line TSM says: ---- C:\Program Files\Tivoli\tsm\baclient>tsmremcloptswin.bat C:\Program Files\Tivoli\tsm\baclient>pushd "c:\program files\tivoli\tsm\baclient " C:\Program Files\Tivoli\tsm\baclient>"c:\program files\tivoli\tsm\baclient\dsmad mc" -tcpserveraddress=172.17.31.165 -id=tsmops -pa=tsmops -dataonly=y -commadel select 'upd node', node_name as "node_name ", 'clo=""' from nodes where lastacc_time - 32 days 0<current_timestamp 1>redirection1.txt The system cannot find the file specified. C:\Program Files\Tivoli\tsm\baclient> ----- I cannot fathom why it converted nodes where lastacc_time <=current_timestamp - 32 days > redirection1.txt to nodes where lastacc_time - 32 days 0<current_timestamp 1>redirection1.txt Any help appreciated, Many Thanks, Matthew TSM Consultant ADMIN ITI Rabobank International 1 Queenhithe, London EC4V 3RL 0044 207 809 3665 _____________________________________________________________ This email (including any attachments to it) is confidential, legally privileged, subject to copyright and is sent for the personal attention of the intended recipient only. If you have received this email in error, please advise us immediately and delete it. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Although we have taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the viruses in this email or attachments. We exclude any liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided in this email or its attachments, unless that information is subsequently confirmed in writing. If this email contains an offer, that should be considered as an invitation to treat. _____________________________________________________________
