Re: Problem solved, Re: Sorting DSPOBJD outfile by ascending date

I agree that if IBM would have even stored the date as YYMMDD it would
have made it easier to put an index on the table either process the index,
or get faster searches and sorts because of the index.

But I am reasonably sure that you could have done something like
idate(odccen concat substr(odcdat,5,2) concat substr(odcdat,1,4) : 'CYMD')
and put that in
select ... from dspobjd
order by idate(...) desc

Providing you installed the idate functions on your systems. Or rewrote
your own and put those functions into your library.


Rob Berendt