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 AT VM.MARIST DOT 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.
> _____________________________________________________________