<html>
<tt>Hello-<br><br>
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:<br><br>
SELECT TC.2005 WITH TC.STUDENT.ID EQ '0078041' '0208170' BY
TC.STUDENT.ID<br>
>LIST TC.2005 BREAK.ON TC.STUDENT.ID TOTAL W04.ACCEPTED.AMT
TOTAL W04.TC.UTILIZE<br>
D.ESSS ID.SUP DET.SUP SELECT.ONLY TOTAL EVAL "(W04.ACCEPTED.AMT -
W04.TC.UTILIZE<br>
D.ESSS)" FMT "10R"<br>
(W04.ACCEP<br>
TED.AMT -<br>
W04.TC.UTI<br>
Total
LIZED.ESSS<br>
TC.STUDENT Package... ESSS...... ).........<br><br>
0078041 31718.00
6500.00 25218.00<br>
0208170
27189.00 0.00
27189.00<br>
==========
========== ==========<br>
TOTAL
58907.00 6500.00 52407.00<br>
16 records listed<br><br>
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:<br><br>
SELECT TC.2005 WITH TC.STUDENT.ID EQ '0078041' '0208170' BY
TC.STUDENT.ID<br>
>DOWNLOAD TC.2005 FORMAT FIXED FILE USER.HOLD NEWBRK.CSV OVERWRITING
BREAK.ON TC.<br>
STUDENT.ID TOTAL W04.ACCEPTED.AMT TOTAL W04.TC.UTILIZED.ESSS TOTAL
EVAL"<br>
(W04.ACCEPTED.AMT - W04.TC.UTILIZED.ESSS)" DET.SUP <br><br>
Top of "NEWBRK.CSV" in "USER.HOLD", 3 lines, 110
characters.<br>
001: 0078041 31718.00
6500.00500000<br>
002: 0208170
27189.00 0.00300000<br><br>
If I add a CONV "MD2" after my EVAL statement, here is the
results:<br>
AE USER.HOLD NEWBRK.CSV<br>
Top of "NEWBRK.CSV" in "USER.HOLD", 3 lines, 110
characters.<br>
001: 0078041 31718.00
6500.005000.0<br>
002: 0208170
27189.00 0.003000.0<br><br>
Suggestions Please!!!<br><br>
Alice<br><br>
<br>
Alice Moore<br>
Information Technology Services<br>
Manager of Administrative Systems Services<br>
Wabash College<br>
765-361-6303<br>
moorea@wabash.edu<br><br>
"GOD PUT ME ON EARTH TO ACCOMPLISH A CERTAIN NUMBER OF THINGS,<br>
RIGHT NOW I AM SO FAR BEHIND, I WILL NEVER DIE!"<br>
</html>