ADSM-L

Re: Select statements

2002-06-19 11:16:25
Subject: Re: Select statements
From: "Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
Date: Wed, 19 Jun 2002 11:10:47 -0400
Yes, this is standard SQL.  What you have to do is change the ORDER BY
clause to

ORDER BY 1

Date(backup_start) is a generated column result not the backup_start column
anymore.  The way it works is you specify the relative column position in
the order by or group by when you do this.

tsm: TSMPRD00>select date(backup_start), node_name, filespace_name from
filespac
es where backup_start<=timestamp(current_date - 110 days ) order by 1

Unnamed[1]     NODE_NAME              FILESPACE_NAME
----------     ------------------     ------------------
2002-01-28     N10637                 SYSTEM OBJECT
2002-01-28     N10637                 SYSTEM OBJECT
2002-01-28     N10637                 \\n10637\c$

Above is the sample result.

Paul D. Seay, Jr.
Technical Specialist
Naptheon, INC
757-688-8180


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