<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face="Courier New"><SPAN
class=603261414-29112005>Alice,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Courier New"><SPAN
class=603261414-29112005></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Courier New"><SPAN
class=603261414-29112005>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.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Courier New"><SPAN
class=603261414-29112005></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Courier New"><SPAN
class=603261414-29112005>HTH<BR></SPAN></FONT><FONT face="Courier New"><SPAN
class=603261414-29112005><FONT 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></DIV>
<DIV dir=ltr align=left> </SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<BR></DIV>
<DIV></DIV><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></BODY></HTML>