MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

Re: SQL stmt to load a commonly used date format



fixed

Ah! So instead of over one decade old, is the OUTFILFMT(*TYPE1) from over two decades ago being used.? ;-)

I withdraw my prior suggestion to use NOW() and VARCHAR_FORMAT for the now more-fully-described purpose\scenario. Use a literal instead; in a [host] variable if not dynamic SQL. The variable value or literal can still be generated from that expression, but should probably not be used to generate the mock row-data described in another thread.

Regards, Chuck

On 19 Oct 2012 15:06, Stone, Joel wrote:
Wishful thinking.

The date I am loading is JODATE on the DSPJRN *OUTFILE format. It is
6 digits on my system (and probably yours also :)

rob@xxxxxxxxx on Friday, October 19, 2012 2:55 PM wrote:

I agree, I thought all 6 character date fields were done away with
over a decade ago.





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact