ADSM-L

Select statements

2002-06-19 08:34:55
Subject: Select statements
From: "Jolliff, Dale" <xjolliff AT TI DOT COM>
Date: Wed, 19 Jun 2002 07:32:38 -0500
Is this really working as designed?

order by date(backup_start) doesn't work either.

This is TSM 4.2.2.4 on AIX

select date(backup_start), node_name, filespace_name from filespaces -
where backup_start<=timestamp(current_date - 110 days ) -
order by backup_start
ANR2964E The reference 'BACKUP_START' is not a column of the SQL result
table.

                                                            |
         ...................................................V...........
         tart<=timestamp(current_date - 110 days ) order by backup_start

ANS8001I Return code 3.
<Prev in Thread] Current Thread [Next in Thread>