Try putting quotations "" around select statement. Like this -commadel "select 'upd node', node_name as "node_name ",'clo=""' from nodes where lastacc_time <=current_timestamp - 32 days" > house.txt
I believe what's happening is that from command line still sees >redirectional1.txt as a part of select statement. Sung Y. Lee "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 05/10/2006 08:01:47 AM: > 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. > _____________________________________________________________
