Hi Kent,
Thanks for that; one of my biggest nightmares is coming across "date" fields that are not stored as dates.
Sadly one of the biggest culprits is IBM! The output files from several OS commands provide date information; typically in MMDDYY format, which does not lend itself to sorting / where clause processing without some manipulation.
I did raise an RFE with IBM to get these changed but all I got was a , rather glib, reply from development about just the one sample case I provided rather than actually reading the requirement that it was required for ALL system command output table formats.
See
http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=141153 for further information. I have just marked this for reconsideration by IBM in the hope that development will notice their earlier oversight. ------------------------------
Keith Pryke
------------------------------
Original Message:
Sent: Mon August 23, 2021 10:27 AM
From: Kent Milligan
Subject: Latest Db2 for i Blog Update
Discussion of how to speed up your date processing on IBM i:
https://db2ibmi.blogspot.com/2021/08/speed-dating-your-legacy-dates.html
------------------------------
Kent Milligan
------------------------------