IBM i Global

 View Only
  • 1.  Latest Db2 for i Blog Update

    Posted Mon August 23, 2021 10:27 AM
    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
    ------------------------------


  • 2.  RE: Latest Db2 for i Blog Update

    Posted Tue August 24, 2021 03:50 AM
    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
    ------------------------------



  • 3.  RE: Latest Db2 for i Blog Update

    Posted Wed August 25, 2021 10:16 AM
    I don't work  in development, so I can't comment on your RFE.

    I will point out that the Date Lookup table approach covered in my blog entry does make it easy to work around this IBM i limitation by simply joining the system-created output file to a Date dimension table

    ------------------------------
    Kent Milligan
    IBM Systems Lab Services
    ------------------------------



  • 4.  RE: Latest Db2 for i Blog Update

    Posted Wed September 22, 2021 03:58 PM
    Hi Keith,

    I may be wrong, but I think the format of the date (6 char) is based on the DatFmt of your job. If the job changes to DatFmt(*YMD), you will get a more reasonable date to sort on. 

    HTH,
    Steve

    ------------------------------
    Steve Anderson
    ------------------------------



  • 5.  RE: Latest Db2 for i Blog Update

    IBM Champion
    Posted Thu September 23, 2021 08:46 AM
    Interesting and well written article! It was enlightening to discover why older date data had been stored in such interesting ways (I thought it may have been a developer's personal quirk and distrust in date data types).

    Thank you for sharing this awesome information.


    ------------------------------
    Jasmine Kaczmarek
    ------------------------------