Re: SQL stmt to load a commonly used date format

[CRPence <CRPbottle@xxxxxxxxx>]

  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.