[Download-List] Double Quotes in LITERAL command

Linda Miller lcmiller at aurora.edu
Fri Mar 10 09:16:15 EST 2006


Here's the paragraph code:

022: * <<Enter Create Date/Time as yyyymmddhhmm>>   <-- prompt the user 
for the date
025: SELECT STUDENTS WITH STU.TERMS = '<<Enter Desired Term>>'
026: SELECT STUDENTS WITH STU.START.TERM = '<<Enter Desired Term>>' 
SELECT.ONLY  <-- only select new students
034: DOWNLOAD STUDENTS @ID FMT 'L#7' @ID FMT 'L#7' LITERAL '10' LITERAL 
'  ' A05.STU.MEAL.PLAN FMT 'L#2' STU.LAST.NAME FMT 'L#20' STU.FIRST.NAME 
FMT 'L#20' FORMAT FIXED FILE _HOLD_ A05.CBORD.STUDENTS OVERWRITING \  
<-- format fixed and L# formats to force fields the the required lengths
035: HEADING LITERAL '!Description: Student Import' \
036: LITERAL '!Source: Datatel' LINE 2 \
037: LITERAL '!BatchID: 0000000001' LINE 3 \
038: LITERAL '!Created: ' LINE 4 LITERAL '<<Enter Create Date/Time as 
yyyymmddhhmm>>' \
039: LITERAL '!RecordCount: ' LINE 5 @SYSTEM.RETURN.CODE \  <-- record 
count (@SYSTEM.RETURN.CODE)
040: LITERAL '!Version: 4.0' LINE 6 \
041: LITERAL '!' LINE 7 \
042: LITERAL '!BeginFormat' LINE 8 \
043: LITERAL '!ODYSSEY_PCS, 1, 7, "IDNUMBER"' LINE 9 \
044: LITERAL '!ODYSSEY_PCS, 8, 9, "CARDNUMBER"' LINE 10 \
045: LITERAL '!ODYSSEY_PCS, 17, 4, "PLAN"' LINE 11 \
046: LITERAL '!ODYSSEY_PCS, 21, 20, "LASTNAME"' LINE 12 \
047: LITERAL '!ODYSSEY_PCS, 41, 20, "FIRSTNAME"' LINE 13 \
048: LITERAL '!EndFormat' LINE 14 \
049: LITERAL '!' LINE 15 \
050: LITERAL '!BeginData' LINE 16 \
051: FOOTING LITERAL '!EndData'
052: DATA <<Enter Desired Term>>  <-- answers the prompt in the 
A05.STU.MEAL.PLAN i-descriptor

The meal plan i-descriptor prompts for a term and calls one of our 
subroutines to get the meal plan for the student for the term.

Twitchell, Wayne wrote:

>So how do you get it to output the fixed format and don't you have to
>tell it number of records?
>(sorry to ask such obvious questions, I use download but our program for
>cboard was written by another programmer who does not use download and I
>am wanting to approach him with this...)
>
>Wayne Twitchell
>Applications Integrator/Developer
>Information Technology Services - Campus Information Systems Team
>Grinnell College
>641-269-4348
>twitchew at grinnell.edu
>
>
>
>
>
>  
>
>>-----Original Message-----
>>From: download-list-bounces at cedarville.edu 
>>[mailto:download-list-bounces at cedarville.edu] On Behalf Of 
>>Linda Miller
>>Sent: Thursday, March 09, 2006 3:04 PM
>>To: Cedarville DOWNLOAD Users
>>Subject: Re: [Download-List] Double Quotes in LITERAL command
>>
>>We do a Cbord download also.  Here's my code for the headers:
>>
>>035: HEADING LITERAL '!Description: Student Import' \
>>036: LITERAL '!Source: Datatel' LINE 2 \
>>037: LITERAL '!BatchID: 0000000001' LINE 3 \
>>038: LITERAL '!Created: ' LINE 4 LITERAL '<<Enter Create 
>>Date/Time as yyyymmddhh
>>mm>>' \
>>039: LITERAL '!RecordCount: ' LINE 5 @SYSTEM.RETURN.CODE \
>>040: LITERAL '!Version: 4.0' LINE 6 \
>>041: LITERAL '!' LINE 7 \
>>042: LITERAL '!BeginFormat' LINE 8 \
>>043: LITERAL '!ODYSSEY_PCS, 1, 7, "IDNUMBER"' LINE 9 \
>>044: LITERAL '!ODYSSEY_PCS, 8, 9, "CARDNUMBER"' LINE 10 \
>>045: LITERAL '!ODYSSEY_PCS, 17, 4, "PLAN"' LINE 11 \
>>046: LITERAL '!ODYSSEY_PCS, 21, 20, "LASTNAME"' LINE 12 \
>>047: LITERAL '!ODYSSEY_PCS, 41, 20, "FIRSTNAME"' LINE 13 \
>>048: LITERAL '!EndFormat' LINE 14 \
>>049: LITERAL '!' LINE 15 \
>>050: LITERAL '!BeginData' LINE 16 \
>>051: FOOTING LITERAL '!EndData'
>>
>>Tuan Vu wrote:
>>
>>    
>>
>>>Greetings folks!
>>>
>>>Newbie alert! Run!
>>>
>>>How does one get the LITERAL command to insert a double 
>>>      
>>>
>>quotation mark 
>>    
>>
>>>around some text? (since the LITERAL command already uses double 
>>>quotation marks to delineate the character string...)
>>>
>>>I'm doing a download to for a CBORD process in which one of 
>>>      
>>>
>>the fields 
>>    
>>
>>>require double quotation marks around it.
>>>
>>>For example, I need to have a line that reads exactly as below:
>>>
>>>!ODYSSEY_HMS, 1, 9, "IDNUMBER"
>>>
>>>I've gotten everything else to come through correctly, with the 
>>>exception of the double quotation marks.
>>>
>>>Thanks in advance for any advice!
>>>
>>>
>>>Kind regards,
>>>
>>>Tuan Vu
>>>Assistant Director for Housing
>>>Pratt Institute
>>>
>>>V - 718-399-4550
>>>F - 718-399-4552
>>>E - tuanvu at pratt.edu
>>>W - http://www.pratt.edu/reslife
>>>
>>>
>>>
>>>
>>>_______________________________________________
>>>download-list mailing list
>>>download-list at cedarville.edu
>>>http://mail.cedarville.edu/mailman/listinfo/download-list
>>> 
>>>
>>>      
>>>
>>_______________________________________________
>>download-list mailing list
>>download-list at cedarville.edu
>>http://mail.cedarville.edu/mailman/listinfo/download-list
>>
>>    
>>
>
>_______________________________________________
>download-list mailing list
>download-list at cedarville.edu
>http://mail.cedarville.edu/mailman/listinfo/download-list
>  
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20060310/497c7999/attachment.html>


More information about the download-list mailing list