[Download-List] Using SUBR in DOWNLOAD

[Sally Crawford]

In the STUDENTS file, I have 'dict items' like this:
LIST DICT STUDENTS WITH @ID LIKE O06.STU.TERM.GPA BY TYP BY @ID TYP LOC
CONV NAM
E FORMAT SM ASSOC 15:47:46 Aug 19 2008 1

@ID............ TYP LOC.......... CONV NAME........... FORMAT SM
ASSOC.....     
 

O06.STU.TERM.GP I   SUBR('S.MIO.T MD25 TERM GPA        7R     S

A                   RANS','STUDEN

                    T.TERMS',STUD

                    ENTS.ID:"*":

                    SUBR('SELINP'

                    ,PROMPT.TERM,

                    'Enter TERM',

                    ''):"*UG", 'S

                    TTR.TERM.GPA'

                    ,'X') 
 
R18 computed columns don't like SELINP, as far as I know.
 
For current credits, I use this in the STUDENTS file:
 
LIST DICT STUDENTS WITH @ID LIKE O06.STU.TERM.CRED BY TYP BY @ID TYP LOC
CONV NA
ME FORMAT SM ASSOC 15:49:29 Aug 19 2008 1

@ID............ TYP LOC.......... CONV NAME........... FORMAT SM
ASSOC.....     
 

O06.STU.TERM.CR I   SUBR('S.GET.T MD25 TERM CRED       5R     S

ED                  ERM.CREDS',ST ,

                    UDENTS.ID,SUB

                    R('SELINP',PR

                    OMPT.TERM, 'E

                    nter TERM',''

                    ),'UG','R') 
 
If you want to look at additional terms, you can do this:
 
LIST DICT STUDENTS WITH @ID LIKE O06.STU.TERM2.GPA BY TYP BY @ID TYP LOC
CONV NA
ME FORMAT SM ASSOC 15:50:24 Aug 19 2008 1

@ID............ TYP LOC.......... CONV NAME........... FORMAT SM
ASSOC.....     
 

O06.STU.TERM2.G I   SUBR('S.MIO.T MD25 TERM2 GPA       7R     S

PA                  RANS','STUDEN

                    T.TERMS',STUD

                    ENTS.ID:"*":

                    SUBR('SELINP'

                    ,PROMPT.TERM2

                    ,'Enter TERM2

                    ',''):"*UG",

                    'STTR.TERM.GP

                    A','X')
 
LIST DICT STUDENTS WITH @ID LIKE O06.STU.TERM2.CRED BY TYP BY @ID TYP
LOC CONV N
AME FORMAT SM ASSOC 15:50:42 Aug 19 2008 1

@ID............ TYP LOC.......... CONV NAME........... FORMAT SM
ASSOC.....     
 

O06.STU.TERM2.C I   SUBR('S.GET.T MD25 TERM2 CRED      8R     S

RED                 ERM.CREDS',ST ,

                    UDENTS.ID,SUB

                    R('SELINP',PR

                    OMPT.TERM2, '

                    Enter TERM2',

                    ''),'UG','R')  
 

------------------------------------------------------------------------
------------------
Sally Crawford * Systems Analyst
Ocean County College * 1 College Drive, Toms River, NJ 08753-2239
Tel 732-255-0400 x2156 * Fax 732-255-0501
scrawford at ocean.edu * www.sungardhe.com * www.ocean.edu

CONFIDENTIALITY: This e-mail (including any attachments) may contain
confidential,
proprietary and privileged information, and unauthorized disclosure or
use is prohibited.
If you received this e-mail in error, please notify the sender and
delete this e-mail
from your system. 

 


________________________________

	From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Jeffery
Summers
	Sent: Tuesday, August 19, 2008 3:42 PM
	To: download-list at cedarville.edu
	Subject: [Download-List] Using SUBR in DOWNLOAD
	
	

	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.  

	 

	Below is the text from the computed columns currently used:

	 

	Last Major Term GPA:

	
SUBR("S.CALC.STU.GPA",TRANS("STUDENT.TERMS",CMPM.PERSON.ST.ID:"*2007.2*U
G",STTR.STUDENT.ACAD.CRED,"X"),"T")

	 

	Current Active Creds:

	
SUBR("S.UDT.TRANS","STUDENT.TERMS",(CMPM.PERSON.ST.ID:"*2008.1*UG"),"STT
R.ACTIVE.CRED")

	 

	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?

	 

	Thanks,

	 

	Jeffery Summers

	Transylvania University

	Administrative Computing

	300 N. Broadway

	Lexington, KY 40508

	jsummers at transy.edu

	 

	
________________________________

	Successfully Scanned by the McAfee SIG 3200 Appliance. 

	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20080819/12209658/attachment.html>