[Download-List] Using a TOTAL and EVAL together in Download
Alice Moore
moorea at wabash.edu
Tue Nov 29 08:57:03 EST 2005
Hello-
Can someone help me convert the following Uniquery statement into
DOWNLOAD? The results are correct in Uniquery but not in DOWNLOAD as my
examples show:
SELECT TC.2005 WITH TC.STUDENT.ID EQ '0078041' '0208170' BY TC.STUDENT.ID
>LIST TC.2005 BREAK.ON TC.STUDENT.ID TOTAL W04.ACCEPTED.AMT TOTAL
W04.TC.UTILIZE
D.ESSS ID.SUP DET.SUP SELECT.ONLY TOTAL EVAL "(W04.ACCEPTED.AMT -
W04.TC.UTILIZE
D.ESSS)" FMT "10R"
(W04.ACCEP
TED.AMT -
W04.TC.UTI
Total LIZED.ESSS
TC.STUDENT Package... ESSS...... ).........
0078041 31718.00 6500.00 25218.00
0208170 27189.00 0.00 27189.00
========== ========== ==========
TOTAL 58907.00 6500.00 52407.00
16 records listed
The above EVAL works just fine in Uniquery, but I really need to do this in
DOWNLOAD. Here are my results when I try using DOWNLOAD:
SELECT TC.2005 WITH TC.STUDENT.ID EQ '0078041' '0208170' BY TC.STUDENT.ID
>DOWNLOAD TC.2005 FORMAT FIXED FILE USER.HOLD NEWBRK.CSV OVERWRITING
BREAK.ON TC.
STUDENT.ID TOTAL W04.ACCEPTED.AMT TOTAL W04.TC.UTILIZED.ESSS TOTAL EVAL"
(W04.ACCEPTED.AMT - W04.TC.UTILIZED.ESSS)" DET.SUP
Top of "NEWBRK.CSV" in "USER.HOLD", 3 lines, 110 characters.
001: 0078041 31718.00 6500.00500000
002: 0208170 27189.00 0.00300000
If I add a CONV "MD2" after my EVAL statement, here is the results:
AE USER.HOLD NEWBRK.CSV
Top of "NEWBRK.CSV" in "USER.HOLD", 3 lines, 110 characters.
001: 0078041 31718.00 6500.005000.0
002: 0208170 27189.00 0.003000.0
Suggestions Please!!!
Alice
Alice Moore
Information Technology Services
Manager of Administrative Systems Services
Wabash College
765-361-6303
moorea at wabash.edu
"GOD PUT ME ON EARTH TO ACCOMPLISH A CERTAIN NUMBER OF THINGS,
RIGHT NOW I AM SO FAR BEHIND, I WILL NEVER DIE!"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20051129/7054fec9/attachment.html>
More information about the download-list
mailing list