<HTML><HEAD><TITLE></TITLE>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16625"></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 12pt Arial" bgColor=#ffffff text=#000000>
<DIV>I agree with Kim that the EVAL is probably generating the buffer error.</DIV>
<DIV> </DIV>
<DIV>Here are a couple of suggestions that should help:</DIV>
<DIV> </DIV>
<DIV>* Instead of using EVAL for constants, use LIT (literal).</DIV>
<DIV>=== LIT "1" instead of EVAL "1"</DIV>
<DIV> </DIV>
<DIV>* Using Download version 7.40, set COMPIILE.EVAL=TRUE in the VOC record DOWNLOAD.CONFIG.</DIV>
<DIV> </DIV>
<DIV>With the COMPILE.EVAL=TRUE, each EVAL usage generates a call to ITYPE. Without the COMPILE.EVAL=TRUE, each EVAL usage generates an EXECUTE...CAPTURING statement. So, a process using 8 evals on 500 records could generate 4,000 EXECUTEs.</DIV>
<DIV> </DIV>
<DIV>Using LIT avoids both the ITYPE and EXECUTE overhead.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>
<DIV><FONT face=Arial>Dave Rotman</FONT></DIV>
<DIV><FONT face=Arial>Associate Vice President for Technology<BR>Chief Information Officer</FONT></DIV>
<DIV><FONT face=Arial>Cedarville University<BR>251 N. Main Street<BR>Cedarville, OH 45314<BR>rotmand@cedarville.edu<BR>voice 937-766-7905<BR>fax 937-766-8819</FONT></DIV>
<DIV> </DIV><BR><BR>>>> On 9/1/2010 at 12:13 PM, in message <4C7E7BA2.4020404@dacc.edu>, Kim Colwell <kcolwell@dacc.edu> wrote:<BR></DIV>
<TABLE style="MARGIN: 0px 0px 0px 15px; FONT-SIZE: 1em" border=0 bgColor=#f3f3f3>
<TBODY>
<TR>
<TD>
<DIV style="BORDER-LEFT: #050505 1px solid; PADDING-LEFT: 7px">Veronica O'Berry wrote:
<BLOCKQUOTE cite=mid:AANLkTikraKLWnC79ex_2O_BNXSHGWDP=ozD6DZoC9rNh@mail.gmail.com type="cite">
<DIV class=gmail_quote>
<BLOCKQUOTE style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex" class=gmail_quote>
<DIV>
<DIV>
<DIV>
<BLOCKQUOTE type="cite"><SPAN style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px">
<DIV lang=EN-US vlink="purple" link="blue">
<DIV>
<DIV class=h5>
<DIV>
<DIV style="MARGIN: 0in 0in 0pt; FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt"><SPAN style="FONT-FAMILY: 'Lucida Bright',serif; COLOR: rgb(23,54,93); FONT-SIZE: 12pt">Any idea of what’s causing this error:</SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt; FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt"><SPAN style="FONT-FAMILY: 'Lucida Bright',serif; COLOR: rgb(23,54,93); FONT-SIZE: 12pt"></SPAN> </DIV>
<DIV style="MARGIN: 0in 0in 0pt; FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt"><SPAN style="FONT-FAMILY: 'Lucida Bright',serif; COLOR: rgb(23,54,93); FONT-SIZE: 12pt"> ****In /datatel/live/collive/CTLG/DOWNLOAD.LOAD at line 127 out of BUF_TYPE space.</SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt; FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt"><SPAN style="FONT-FAMILY: 'Lucida Bright',serif; COLOR: rgb(23,54,93); FONT-SIZE: 12pt"></SPAN> </DIV>
<DIV style="MARGIN: 0in 0in 0pt; FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt"><SPAN style="FONT-FAMILY: 'Lucida Bright',serif; COLOR: rgb(23,54,93); FONT-SIZE: 12pt">DOWNLOAD STUDENT.ACAD.CRED SECONDARY.FILE PERSON KEY <A href="http://STC.PERSON.ID" target=_blank moz-do-not-send="true">STC.PERSON.ID</A> PERSON-></SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt; FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt"><SPAN style="FONT-FAMILY: 'Lucida Bright',serif; COLOR: rgb(23,54,93); FONT-SIZE: 12pt"><A href="http://FIRST.NAME" target=_blank moz-do-not-send="true">FIRST.NAME</A> PERSON-><A href="http://LAST.NAME" target=_blank moz-do-not-send="true">LAST.NAME</A> PERSON->XA16.WA.USERID PERSON->XA16.INT.EMAIL EVAL</SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt; FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt"><SPAN style="FONT-FAMILY: 'Lucida Bright',serif; COLOR: rgb(23,54,93); FONT-SIZE: 12pt">"p@ssw0rd" PERSON->PERSONAL.PHONE.NUMBER PERSON->PERSONAL.PHONE.NUMBER PERSON->X</SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt; FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt"><SPAN style="FONT-FAMILY: 'Lucida Bright',serif; COLOR: rgb(23,54,93); FONT-SIZE: 12pt">A16.ADDR.LINE1 PERSON->CITY PERSON->STATE PERSON->ZIP EVAL "USA" EVAL "" EVAL "S</SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt; FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt"><SPAN style="FONT-FAMILY: 'Lucida Bright',serif; COLOR: rgb(23,54,93); FONT-SIZE: 12pt">TC.SEC.NAME:'-2010FA'" EVAL "1" EVAL "1" FORMAT TAB FILE _HOLD_ MYLABSPLUS.TXT</SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt; FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt"><SPAN style="FONT-FAMILY: 'Lucida Bright',serif; COLOR: rgb(23,54,93); FONT-SIZE: 12pt"> OVERWRITING </SPAN></DIV></DIV></DIV></DIV></DIV></SPAN></BLOCKQUOTE></DIV></DIV></DIV></BLOCKQUOTE></DIV></BLOCKQUOTE><BR>We've seen this error before and always been able to trace it back to an EVAL statement. I would suggest temporarily removing the EVAL's & testing; then put 1 at a time back in until it breaks. (I suspect it may be related to using EVAL's and secondary files, but don't have any proof.).<BR><BR><BR>Kim Colwell<BR><BR></DIV></TD></TR></TBODY></TABLE></BODY></HTML>