<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16705" name=GENERATOR>
<STYLE>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2>In the STUDENTS file, I have 'dict items' like this:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2>LIST DICT STUDENTS WITH @ID LIKE O06.STU.TERM.GPA BY TYP BY @ID TYP LOC
CONV NAM<BR>E FORMAT SM ASSOC 15:47:46 Aug 19 2008
1
<BR>@ID............ TYP LOC.......... CONV NAME........... FORMAT SM
ASSOC.....
<BR>
<BR>O06.STU.TERM.GP I SUBR('S.MIO.T MD25 TERM
GPA 7R
S
<BR>A
RANS','STUDEN
<BR>
T.TERMS',STUD
<BR>
ENTS.ID:"*":
<BR>
SUBR('SELINP'
<BR>
,PROMPT.TERM,
<BR>
'Enter
TERM',
<BR>
''):"*UG",
'S
<BR>
TTR.TERM.GPA'
<BR>
,'X') </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2>R18 computed columns don't like SELINP, as far as I
know.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2>For current credits, I use this in the STUDENTS file:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2>LIST DICT STUDENTS WITH @ID LIKE O06.STU.TERM.CRED BY TYP BY @ID TYP LOC
CONV NA<BR>ME FORMAT SM ASSOC 15:49:29 Aug 19 2008
1
<BR>@ID............ TYP LOC.......... CONV NAME........... FORMAT SM
ASSOC.....
<BR>
<BR>O06.STU.TERM.CR I SUBR('S.GET.T MD25 TERM
CRED 5R
S
<BR>ED
ERM.CREDS',ST
,
<BR>
UDENTS.ID,SUB
<BR>
R('SELINP',PR
<BR>
OMPT.TERM,
'E
<BR>
nter
TERM',''
<BR>
),'UG','R') </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2>If you want to look at additional terms, you can do
this:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2>LIST DICT STUDENTS WITH @ID LIKE O06.STU.TERM2.GPA BY TYP BY @ID TYP LOC
CONV NA<BR>ME FORMAT SM ASSOC 15:50:24 Aug 19 2008
1
<BR>@ID............ TYP LOC.......... CONV NAME........... FORMAT SM
ASSOC.....
<BR>
<BR>O06.STU.TERM2.G I SUBR('S.MIO.T MD25 TERM2
GPA 7R
S
<BR>PA
RANS','STUDEN
<BR>
T.TERMS',STUD
<BR>
ENTS.ID:"*":
<BR>
SUBR('SELINP'
<BR>
,PROMPT.TERM2
<BR>
,'Enter
TERM2
<BR>
',''):"*UG",
<BR>
'STTR.TERM.GP
<BR>
A','X')</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=743234719-19082008><FONT face="Courier New"
size=2>LIST DICT STUDENTS WITH @ID LIKE O06.STU.TERM2.CRED BY TYP BY @ID TYP LOC
CONV N<BR>AME FORMAT SM ASSOC 15:50:42 Aug 19 2008
1
<BR>@ID............ TYP LOC.......... CONV NAME........... FORMAT SM
ASSOC.....
<BR>
<BR>O06.STU.TERM2.C I SUBR('S.GET.T MD25 TERM2
CRED 8R
S
<BR>RED
ERM.CREDS',ST
,
<BR>
UDENTS.ID,SUB
<BR>
R('SELINP',PR
<BR>
OMPT.TERM2,
'
<BR>
Enter
TERM2',
<BR>
''),'UG','R') </FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/plain format -->
<P><FONT
size=2>------------------------------------------------------------------------------------------<BR>Sally
Crawford * Systems Analyst<BR>Ocean County College * 1 College Drive, Toms
River, NJ 08753-2239<BR>Tel 732-255-0400 x2156 * Fax
732-255-0501<BR>scrawford@ocean.edu * www.sungardhe.com *
www.ocean.edu<BR><BR>CONFIDENTIALITY: This e-mail (including any attachments)
may contain confidential,<BR>proprietary and privileged information, and
unauthorized disclosure or use is prohibited.<BR>If you received this e-mail in
error, please notify the sender and delete this e-mail<BR>from your
system.</FONT> </P>
<DIV> </DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu] <B>On Behalf Of </B>Jeffery
Summers<BR><B>Sent:</B> Tuesday, August 19, 2008 3:42 PM<BR><B>To:</B>
download-list@cedarville.edu<BR><B>Subject:</B> [Download-List] Using SUBR in
DOWNLOAD<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal>I’d like to simplify an extract I run for athletic
eligibility. Instead of changing terms in 3 or 4 spots I’d prefer to
change them in one place, preferably the DOWNLOAD script.
<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Below is the text from the computed columns currently
used:<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Last Major Term GPA:<o:p></o:p></P>
<P
class=MsoNormal>SUBR("S.CALC.STU.GPA",TRANS("STUDENT.TERMS",CMPM.PERSON.ST.ID:"*2007.2*UG",STTR.STUDENT.ACAD.CRED,"X"),"T")<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Current Active Creds:<o:p></o:p></P>
<P
class=MsoNormal>SUBR("S.UDT.TRANS","STUDENT.TERMS",(CMPM.PERSON.ST.ID:"*2008.1*UG"),"STTR.ACTIVE.CRED")<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>As written they don’t work; I get error messages when it
reaches the part where I build the key. Is something like the above
possible in DOWNLOAD or must I continue to use my computed
columns?<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Thanks,<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Jeffery Summers<o:p></o:p></P>
<P class=MsoNormal>Transylvania University<o:p></o:p></P>
<P class=MsoNormal>Administrative Computing<o:p></o:p></P>
<P class=MsoNormal>300 N. Broadway<o:p></o:p></P>
<P class=MsoNormal>Lexington, KY 40508<o:p></o:p></P>
<P class=MsoNormal><A
href="mailto:jsummers@transy.edu">jsummers@transy.edu</A><o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P>
<HR>
Successfully Scanned by the McAfee SIG 3200 Appliance.
<P></P></DIV></BLOCKQUOTE></BODY></HTML>