ADSM-L

Complete a SQL statement

2003-07-22 15:35:07
Subject: Complete a SQL statement
From: Fred Johanson <fred AT MIDWAY.UCHICAGO DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 22 Jul 2003 14:34:47 -0500
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??

<Prev in Thread] Current Thread [Next in Thread>