I thought I was complete in my request for help, but I will try to be more complete.
The great response you provided as follows:
If using *MDY for the DatFmt, and ignoring the ODCCEN is acceptable,
then the following expression is fairly succinct [all dates must be in
the 1940-2039 100-year window]:
date(insert(insert(ODCDAT, 5, 0, '/'), 3, 0, '/'))
This SQL stmt works GREAT if the CHGJOB DATFMT(*MDY) is in force.
Unfortunately this SQL stmt fails if someone did CHGJOB DATFMT(*YMD) which often occurs.
My question is: would it be possible to ensure that the above SQL stmt is successful regardless of the current job's DATFMT setting.
Thanks!
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Thursday, April 11, 2013 3:51 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL list *OUTFILE of DSPOBJD by date
On 11 Apr 2013 13:23, rob@xxxxxxxxx wrote:
Yes, you're right. The format in that file stays consistent.
Perhaps he was concerned about what he's comparing it with.
Well like most posts asking for help, they are woefully incomplete
for what are the actual requirements; all too many assumptions must be
made by the reader. At least this was not another intentional
obfuscation for which perhaps there would have been no mention that the
format for QADSPOBJ was being used; instead just a mention of some
MMDDYY character field, possibly not even clarified char vs numeric or
even possibly no type or length having been noted, then from a new
message twenty posts later or even in a new message thread, mostly just
bad guesses and\or questions trying to pry relevant details, to learn
that there was a /century/ indicator column in the database file all along!
So anyhow... I did not recall any reference to a value to which there
would need to be a comparison *in this message thread* so I figured
there was no such need :-) Taking into account a prior message thread,
perhaps with the subject "Query/400 list of objects by date", one might
infer that the eventual goal might include *selection* from that "list"
of *QRYDFN objects in the DSPOBJD output file rather than just
*ordering* the list, whereby there is a particular object with a date of
"March 31" give-or-take several days. But that was a different thread,
oh so long ago ;-)
midrange.com
