slandess
Well Known Member
*** This post pertains to DB2/400 SQL queries (i.e., System i - iSeries - AS/400) ***
Do you use IBM's STRSQL or Query Management to produce ad-hoc reports when viewing data in JDE files? If you don't have a Julian calendar at hand, JDE Julian dates can be annoying when running SQL queries against JDE files.
It can be equally annoying to join each date field in your query to the F00365 file to convert it to human-readable form.
I have created a SQL UDF which will turn those dates into an *ISO date to make those ad-hoc SQL queries easier!
See attachment.
Regards,
Do you use IBM's STRSQL or Query Management to produce ad-hoc reports when viewing data in JDE files? If you don't have a Julian calendar at hand, JDE Julian dates can be annoying when running SQL queries against JDE files.
It can be equally annoying to join each date field in your query to the F00365 file to convert it to human-readable form.
I have created a SQL UDF which will turn those dates into an *ISO date to make those ad-hoc SQL queries easier!
See attachment.
Regards,