Re: SQL statement
2005-09-15 10:05:31
Joni,
Try
order by "date"
Leigh
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: 15 September 2005 14:53
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] SQL statement
Hi Everyone!
Does anyone know what I am doing wrong with this sql statement? I am
trying to get the file info. but it all comes down to the date. I just
want to report on the date that the data was archived before 6/3/2005,
but I can't figure out what I am doing wrong. Any suggestions? Thanks!
tsm: TSMPROD>select filespace_name,hl_name,ll_name,date(archive_date) as
"date",
class_name from archives where node_name='CS-NICE-STORAGE'
and arch
ive_date>'06/30/2005' order by date > /tmp/nice2 Output of
command redirected to file '/tmp/nice2'
ANS8001I Return code 3.
ANR2904E Unexpected SQL key word token - 'DATE'.
|
...........................................................V...
='CS-NICE-STORAGE' and archive_date> '06/30/2005' order by date
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
|
|
|