RE: Sorting DSPOBJD outfile by ascending date

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

DANG IT!  I'm going to take a break after this!

I meant QUSLOBJ, not QUSROBJD.

You could also do this type of thing in SQL:

Create Table qtemp/sortOutfile as (
    select A.*, right(odcdat,2)||left(odcdat,4) as odcdat_yymmdd
              , right(odudat,2)||left(odudat,4) as odudat_yymmdd 
    from myOutfile A            
    order by right(odcdat,2), odcdat
    ) WITH DATA

(keeping in mind that I cannot test this at present.)

Good night.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
It's great to be smart 'cuz then you know stuff. 

(or  so I've heard!  - DEL)



> I believe you will find that they are CMMDDYY fields.
>
> I **believe** you will also find that if you change your job's date
> format
> (CHGJOB DATFMT()), you will get output more suited to sorting.  I have
> not
> tested this lately, however, and cannot right now.
>
> Having said that, you may find the APIs (QUSROBJD in this case) better
> suited to this sort of thing.  But it depends upon your level of
> API-guruness.  :)
>
> Regards,
> Dennis Lovelady
> http://www.linkedin.com/in/dennislovelady
> --
> Patience - a minor form of despair disguised as a virtue.
>         -- Ambrose Bierce
>
>
>
> > Some time ago, Vern turned me on to using DSPOBJD to an outfile, to
> > generate a list of objects with their datestamps.
> >
> > Only problem is that the important datestamps (creation and change)
> are
> > simple character fields in MMDDYY format, which makes any sorts on
> > those
> > fields meaningless.
> >
> > Anybody know of an easy way to deal with this?