Hello Friends,
I have written a sql query to bring the output in unix.
The query is :
select tabname,tabschema,colname from syscat.columns where typename='date' and colname like '%date%'"

I am trying to place this output in excel sheet and there are some 1500 rows I have ,all of which are unsorted.

Can anybody suggest or tune the query so that the output is in an organised manner?

select tabschema, tabname, colname
from syscat.columns
where typename= 'DATE' and colname like '%DATE%'
order by tabschema, tabname, colno

I assume you used caps for the literals instead of the lc in your post.

Thanks Marcus

But when I export this data into an excel sheet I see lot of spaces.I have like
1500+ rows and I am trying to have the data like a table in excel sheet.Will the query you suggested give me the desired result?

db2 "export to date_column.txt of del select tabschema, tabname, colname from syscat.columns where typename= 'DATE' and colname like '%DATE%' order by tabschema, tabname, colno"

Then open date_column.txt with Excel (you have to select txt files as input), and select "space" as the delimiter.