× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. October 2012

Re: SQL stmt to load a commonly used date format

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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.