The order by clause accepts a numerical qualifier, indicating which column to
order by (in this case, the first).

select date(backup_start), node_name, filespace_name from filespaces -
where backup_start<=timestamp(current_date - 110 days ) -
order by 1


Mike.



Quoting "PINNI, BALANAND (SBCSI)" <bp3965 AT SBC DOT COM>:

> Do desc filespaces do u see the structure description or else
> field name might have changed?
>
> Balanand Pinni
> SBC Services Inc.
> Work:314-206-5911
> Pager:1-800-451-6897
> Email ID :bp3965 AT momail.sbc DOT com
> 8004516897 AT mobilecomm DOT net e.mail pager
>
>
>
>
>
> -----Original Message-----
> From: Jolliff, Dale [mailto:xjolliff AT TI DOT COM]
> Sent: Wednesday, June 19, 2002 7:33 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Select statements
>
>
> 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.
>