[Download-List] Error

[David L. Rotman]

I agree with Kim that the EVAL is probably generating the buffer error.
 
Here are a couple of suggestions that should help:
 
* Instead of using EVAL for constants, use LIT (literal).
=== LIT "1" instead of EVAL "1"
 
* Using Download version 7.40, set COMPIILE.EVAL=TRUE in the VOC record
DOWNLOAD.CONFIG.
 
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.
 
Using LIT avoids both the ITYPE and EXECUTE overhead.
 
 
 
Dave Rotman
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819
 


>>> On 9/1/2010 at 12:13 PM, in message <4C7E7BA2.4020404 at dacc.edu>,
Kim Colwell <kcolwell at dacc.edu> wrote:

Veronica O'Berry wrote: 





Any idea  of what’s causing this error:
 
 ****In /datatel/live/collive/CTLG/DOWNLOAD.LOAD at line 127 out of
BUF_TYPE space.
 
DOWNLOAD STUDENT.ACAD.CRED SECONDARY.FILE PERSON KEY STC.PERSON.ID
PERSON->
FIRST.NAME PERSON->LAST.NAME PERSON->XA16.WA.USERID
PERSON->XA16.INT.EMAIL EVAL
"p at ssw0rd" PERSON->PERSONAL.PHONE.NUMBER PERSON->PERSONAL.PHONE.NUMBER
PERSON->X
A16.ADDR.LINE1 PERSON->CITY PERSON->STATE PERSON->ZIP EVAL "USA" EVAL
"" EVAL "S
TC.SEC.NAME:'-2010FA'" EVAL "1" EVAL "1"  FORMAT TAB FILE _HOLD_ 
MYLABSPLUS.TXT
 OVERWRITING       



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.).


Kim Colwell

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