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

Alice Moore moorea at wabash.edu
Tue Nov 29 09:57:42 EST 2005


The tip Eric gave helped the formatting, but not the total.  See Below:

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 DET.SUP 
TOTAL EV
AL" (W04.ACCEPTED.AMT - W04.TC.UTILIZED.ESSS)"   CONV "MD2" FMT "10R"
:
AE USER.HOLD NEWBRK.CSV
Top of "NEWBRK.CSV" in "USER.HOLD", 3 lines, 122 characters.
001:    0078041  31718.00   6500.00   5000.00
002:    0208170  27189.00      0.00   3000.00
Bottom.


At 09:15 AM 11/29/2005 -0500, you wrote:
>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!"
>_______________________________________________
>download-list mailing list
>download-list at cedarville.edu
>http://mail.cedarville.edu/mailman/listinfo/download-list

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


More information about the download-list mailing list