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.
_____________________________________________________________
|