<html>
<font size=3>The tip Eric gave helped the formatting, but not the
total. See Below:<br><br>
</font><tt>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<br>
TC.STUDENT.ID TOTAL W04.ACCEPTED.AMT TOTAL W04.TC.UTILIZED.ESSS DET.SUP
TOTAL EV<br>
AL" (W04.ACCEPTED.AMT - W04.TC.UTILIZED.ESSS)" CONV
"MD2" FMT "10R"<br>
:<br>
AE USER.HOLD NEWBRK.CSV<br>
Top of "NEWBRK.CSV" in "USER.HOLD", 3 lines, 122
characters.<br>
001: 0078041 31718.00
6500.00
<font face="Andale Mono" size=3 color="#FF0000">5000.00<br>
</font>002: 0208170
27189.00 0.00
<font face="Andale Mono" size=3 color="#FF0000">3000.00<br>
</font>Bottom.<br><br>
<br>
</tt><font size=3>At 09:15 AM 11/29/2005 -0500, you wrote:<br>
</font><blockquote type=cite class=cite cite><font face="Courier New, Courier" size=3>Alice,</font><br>
<br>
<font face="Courier New, Courier" size=3>I think you need a FMT
"10R" in addition to the CONV "MD2" to make the
output from DownLoad look like the output put UniQuery.</font><br>
<br>
<font face="Courier New, Courier" size=3>HTH<br>
</font><font face="Courier New, Courier" size=2>Eric Spitzner, CDP
(eric.spitzner@quinnipiac.edu)<br>
Senior Programmer/Analyst<br>
Quinnipiac University; Hamden, Connecticut<br>
Sun E450; Solaris 2.8; UniData 5.1.36<br>
Colleague 17.0.14 and Benefactor 5.1
</font><font face="Courier New, Courier" size=3><br>
</font><br><br>
<hr>
<br>
<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>
</tt><font size=3>_______________________________________________<br>
download-list mailing list<br>
download-list@cedarville.edu<br>
<a href="http://mail.cedarville.edu/mailman/listinfo/download-list" eudora="autourl">http://mail.cedarville.edu/mailman/listinfo/download-list</a></blockquote>
<x-sigsep><p></x-sigsep>
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>
</font></html>