[Download-List] Using a TOTAL and EVAL together in Download

[Spitzner, Eric]

Alice,
 
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.
 
HTH
Eric Spitzner, CDP (eric.spitzner at quinnipiac.edu)
Senior Programmer/Analyst
Quinnipiac University; Hamden, Connecticut
Sun E450; Solaris 2.8; UniData 5.1.36
Colleague 17.0.14 and Benefactor 5.1 
 

________________________________


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/48be37d7/attachment.html>