[Download-List] RE: download-list digest, Vol 1 #31 - 5 msgs
Eshragh, Mansur
MEshragh at mccneb.edu
Wed Feb 25 12:17:28 EST 2004
Here is my version which works fine ( I have ver.7.1):
SELECT PERSON SAMPLE 5
5 records selected to list 0.
>SAVE.LIST MYSAMPLE
5 key(s) saved to 1 record(s).
:GET.LIST MYSAMPLE
5 records retrieved to list 0.
>DOWNLOAD PERSON NAME ADDRESS \
HEADING EVAL "OCONV(@DATE,'D4/')" LITERAL "NAME" LITERAL "ADDRES"
DOWNLOAD version 7.10
Creating temporary list DLMESHRAGH40196
5 key(s) saved to 1 record(s).
5 records retrieved to list 1.
Overwriting existing select list.
5 records retrieved to list 1.
Using input file PERSON
Output to screen
"02/25/2004","NAME","ADDRES"
"Schamp, Kim A","16917 M Cir"
"Nolan, James J","1335 East First Street"
"COLE, JULIE L","5015 So 163rd Ave"
"Larsen, Nye","856 West Sixth St"
"Mieska, Joann L",""
5 records processed.
Mansur Eshragh
Programmer/Analyst
Metropolitan Community College
MIS Dept.
meshragh at metropo.mccneb.edu
(402) 457-2219
-----Original Message-----
From: download-list-admin at cedarville.edu
[mailto:download-list-admin at cedarville.edu]On Behalf Of
download-list-request at cedarville.edu
Sent: Wednesday, February 25, 2004 11:02 AM
To: download-list at cedarville.edu
Subject: download-list digest, Vol 1 #31 - 5 msgs
Send download-list mailing list submissions to
download-list at cedarville.edu
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.cedarville.edu/mailman/listinfo/download-list
or, via email, send a message with subject or body 'help' to
download-list-request at cedarville.edu
You can reach the person managing the list at
download-list-admin at cedarville.edu
When replying, please edit your Subject line so it is more specific
than "Re: Contents of download-list digest..."
Today's Topics:
1. RE: Header record/date format (Wendy Smoak)
2. RE: Header record/date format (Pat Minatra (DataTel))
3. RE: Header record/date format (David L. Rotman)
4. RE: Header record/date format (Wendy Smoak)
5. RE: Header record/date format (Shawn Waldie)
--__--__--
Message: 1
Date: Tue, 24 Feb 2004 10:41:20 -0700
From: Wendy Smoak <Wendy.Smoak at asu.edu>
Subject: RE: [Download-List] Header record/date format
To: download-list at cedarville.edu
Reply-To: download-list at cedarville.edu
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
--__--__--
Message: 2
Subject: RE: [Download-List] Header record/date format
Date: Tue, 24 Feb 2004 12:08:36 -0600
From: "Pat Minatra (DataTel)" <minatrae at hsutx.edu>
To: <download-list at cedarville.edu>
Reply-To: download-list at cedarville.edu
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
--__--__--
Message: 3
Date: Tue, 24 Feb 2004 13:26:34 -0500
From: "David L. Rotman" <rotmand at cedarville.edu>
To: <download-list at cedarville.edu>
Subject: RE: [Download-List] Header record/date format
Reply-To: download-list at cedarville.edu
The design dilemma is that DOWNLOAD has no way to know how
much space to reserve for the EVAL expression when using FIXED
format.
Here are two ways to get the job done:
SELECT PERSON SAMPLE 5
DOWNLOAD PERSON \
FILE HOLD XWDS.TEST FORMAT FIXED OVERWRITING \
HEADING \
LITERAL "ABC" \
EVAL "OCONV(@DATE,'D4/')" FMT "10L" \
LITERAL "DEF" \
DETAIL PERSON.NAME
SELECT PERSON SAMPLE 5
DOWNLOAD PERSON \
FILE HOLD XWDS.TEST FORMAT FIXED OVERWRITING \
HEADING \
EVAL "'ABC':OCONV(@DATE,'D4/'):'DEF'" \
DETAIL PERSON.NAME
In the second method, the ABC and DEF are enclosed in
single quotes (the entire EVAL expression is enclosed in
double quotes).
Dave Rotman
Director of Computer Services
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819
>>> Wendy.Smoak at asu.edu 2/24/2004 12:41:20 PM >>>
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
--__--__--
Message: 4
Date: Tue, 24 Feb 2004 11:42:58 -0700
From: Wendy Smoak <Wendy.Smoak at asu.edu>
Subject: RE: [Download-List] Header record/date format
To: download-list at cedarville.edu
Reply-To: download-list at cedarville.edu
David L. Rotman wrote:
> EVAL "OCONV(@DATE,'D4/')" FMT "10L" \
Dave, thanks for the quick response! Shawn, the conversion code for
yyyy-mm-dd is: "D4-YMD". Plug that into the OCONV statement and you
should have what you need.
--
Wendy Smoak
Application Systems Analyst, Sr.
ASU IA Information Resources Management
--__--__--
Message: 5
From: Shawn Waldie <waldies at sanjuancollege.edu>
To: "'download-list at cedarville.edu'" <download-list at cedarville.edu>
Subject: RE: [Download-List] Header record/date format
Date: Tue, 24 Feb 2004 13:01:13 -0700
Reply-To: download-list at cedarville.edu
Perfect!
My thanks to Wendy, Dave, and Dick.
Shawn
-----Original Message-----
From: Wendy Smoak [mailto:Wendy.Smoak at asu.edu]
Sent: Tuesday, February 24, 2004 11:43 AM
To: download-list at cedarville.edu
Subject: RE: [Download-List] Header record/date format
David L. Rotman wrote:
> EVAL "OCONV(@DATE,'D4/')" FMT "10L" \
Dave, thanks for the quick response! Shawn, the conversion code for
yyyy-mm-dd is: "D4-YMD". Plug that into the OCONV statement and you should
have what you need.
--__--__--
_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list
End of download-list Digest
More information about the download-list
mailing list