[Download-List] Header record/date format

[Pat Minatra (DataTel)]

Same result here with 7.01.

-------------------------
"Life is but a twinkle in the eye of eternity"
"The shortest distance between a problem and a solution is the distance
between your knees and the floor"
"sorrow looks back - worry looks around - faith looks up"
Regards,
Pat H. Minatra - N5GJR
(325) 670-5804 voice
(325) 670-1570 fax
Hardin*Simmons University  
www.hsutx.edu
PO BOX 16040
Abilene, TX  79698


-----Original Message-----
From: download-list-admin at cedarville.edu
[mailto:download-list-admin at cedarville.edu] On Behalf Of Wendy Smoak
Sent: Tuesday, February 24, 2004 11:41 AM
To: download-list at cedarville.edu
Subject: RE: [Download-List] Header record/date format


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 


_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list