Thank you, I found it.


At 02:50 PM 7/22/2003 -0500, you wrote:

Fred

the number of parens is not balanced.  You're missing a right paren
somewhere.






Fred Johanson <fred AT MIDWAY.UCHICAGO DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
07/22/03 02:34 PM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Complete a SQL statement


I have a domain admin who'd like to find obsolete filespaces.  This is his
SQL script:

select
filespaces.node_name,filespaces.filespace_name,filespaces.backup_end
from -
  filespaces where (($1 < -
  days(current_timestamp) - days(backup_end) or -
  backup_end is null) and filespaces.node_name in (select nodes.node_name
from nodes where domain_name=upper('$2'))

And this is the result:

tsm: TSM>run sincelast_fs 30 csm
ANR2909E The SQL statement is incomplete; additional tokens are required.
ANR1463E RUN: Command script SINCELAST_FS completed in error.
ANS8001I Return code 4.

What is missing??