[Download-List] Header record/date format

[Wendy Smoak]

Shawn Waldie wrote:
> I'm not sure how, but I would like to include @DATE, with a YYYY-MM-DD
> format, in the header record of what will be a fixed-length 
> file.

Something like this might work:
:SELECT PERSON SAMPLE 5
> DOWNLOAD PERSON FILE HOLD XWDS.TEST FORMAT FIXED OVERWRITING HEADING
LITERAL 
"ABC" EVAL "OCONV(@DATE,'D4/')" LITERAL "DEF" DETAIL PERSON.NAME

Actually that produced this:
Top of "XWDS.TEST" in "HOLD", 6 lines, 168 characters.

001: ABCDEF24/2004      

But I expected ABC02/24/2004DEF.  It's as though the EVAL didn't "take
up" any space, and the second literal overwrote the first three
characters of the EVAL.  This may require Dave's intervention... (and
I'm on an old version still, so it may be fixed in the latest one.)

You can use a different format with OCONV to get the YYYY-MM-DD format
that you need.

Can someone with DOWNLOAD 7.1 try my example and let me know if it
works?

-- 
Wendy Smoak
Application Systems Analyst, Sr.
ASU IA Information Resources Management