<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Here's the paragraph code:<br>
<br>
022: * <<Enter Create Date/Time as yyyymmddhhmm>> <font
color="#ff0000"><-- prompt the user for the date<br>
<font color="#000000">025: SELECT STUDENTS WITH STU.TERMS =
'<<Enter Desired Term>>'<br>
026: SELECT STUDENTS WITH STU.START.TERM = '<<Enter Desired
Term>>' SELECT.ONLY <font color="#ff0000"><-- only select
new students</font></font><br>
</font>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 \ <font color="#ff0000"><-- format fixed and L#
formats to force fields the the required lengths</font><br>
035: HEADING LITERAL '!Description: Student Import' \<br>
036: LITERAL '!Source: Datatel' LINE 2 \<br>
037: LITERAL '!BatchID: 0000000001' LINE 3 \<br>
038: LITERAL '!Created: ' LINE 4 LITERAL '<<Enter Create
Date/Time as yyyymmddhhmm>>' \<br>
039: LITERAL '!RecordCount: ' LINE 5 @SYSTEM.RETURN.CODE \ <font
color="#ff0000"><-- record count (@SYSTEM.RETURN.CODE)</font><br>
040: LITERAL '!Version: 4.0' LINE 6 \<br>
041: LITERAL '!' LINE 7 \<br>
042: LITERAL '!BeginFormat' LINE 8 \<br>
043: LITERAL '!ODYSSEY_PCS, 1, 7, "IDNUMBER"' LINE 9 \<br>
044: LITERAL '!ODYSSEY_PCS, 8, 9, "CARDNUMBER"' LINE 10 \<br>
045: LITERAL '!ODYSSEY_PCS, 17, 4, "PLAN"' LINE 11 \<br>
046: LITERAL '!ODYSSEY_PCS, 21, 20, "LASTNAME"' LINE 12 \<br>
047: LITERAL '!ODYSSEY_PCS, 41, 20, "FIRSTNAME"' LINE 13 \<br>
048: LITERAL '!EndFormat' LINE 14 \<br>
049: LITERAL '!' LINE 15 \<br>
050: LITERAL '!BeginData' LINE 16 \<br>
051: FOOTING LITERAL '!EndData'<br>
052: DATA <<Enter Desired Term>> <font color="#ff0000"><--
answers the prompt in the A05.STU.MEAL.PLAN i-descriptor<br>
<br>
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.<br>
</font><br>
Twitchell, Wayne wrote:
<blockquote
cite="mid6BF0342C79156F449E3F6C6B68EEF89AF70A6E@email.grinnell.edu"
type="cite">
<pre wrap="">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
<a class="moz-txt-link-abbreviated" href="mailto:twitchew@grinnell.edu">twitchew@grinnell.edu</a>
</pre>
<blockquote type="cite">
<pre wrap="">-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:download-list-bounces@cedarville.edu">download-list-bounces@cedarville.edu</a>
[<a class="moz-txt-link-freetext" href="mailto:download-list-bounces@cedarville.edu">mailto:download-list-bounces@cedarville.edu</a>] 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:
</pre>
<blockquote type="cite">
<pre wrap="">Greetings folks!
Newbie alert! Run!
How does one get the LITERAL command to insert a double
</pre>
</blockquote>
<pre wrap="">quotation mark
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap="">the fields
</pre>
<blockquote type="cite">
<pre wrap="">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 - <a class="moz-txt-link-abbreviated" href="mailto:tuanvu@pratt.edu">tuanvu@pratt.edu</a>
W - <a class="moz-txt-link-freetext" href="http://www.pratt.edu/reslife">http://www.pratt.edu/reslife</a>
_______________________________________________
download-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a>
<a class="moz-txt-link-freetext" href="http://mail.cedarville.edu/mailman/listinfo/download-list">http://mail.cedarville.edu/mailman/listinfo/download-list</a>
</pre>
</blockquote>
<pre wrap="">_______________________________________________
download-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a>
<a class="moz-txt-link-freetext" href="http://mail.cedarville.edu/mailman/listinfo/download-list">http://mail.cedarville.edu/mailman/listinfo/download-list</a>
</pre>
</blockquote>
<pre wrap=""><!---->
_______________________________________________
download-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a>
<a class="moz-txt-link-freetext" href="http://mail.cedarville.edu/mailman/listinfo/download-list">http://mail.cedarville.edu/mailman/listinfo/download-list</a>
</pre>
</blockquote>
</body>
</html>