<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7651.59">
<TITLE>EVAL & in line Prompt</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Hello Download Users</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">having problems using Download with an EVAL & an in line prompt</FONT><FONT SIZE=2 FACE="Arial"> in the File statement</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">in R18 (which we just converted to</FONT><FONT SIZE=2 FACE="Arial">)</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">IF I remove the<B> <<ENTER TERM>></B> from<B> FILE XH.SDMT.FTP.DIR XM.RWB.STU.ASD<<ENTER TERM>> COMMA.CHAR ^9 OVERWRITING </B></FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Query</FONT> <FONT SIZE=2 FACE="Arial">works fine</FONT> <FONT SIZE=2 FACE="Arial"> - </FONT><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">can we no longer use an in-line prompt in the File statement with an EVAL in Download?</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">(if I remove the EVAL from the Query - then the in-line prompt in the File statement works fine)</FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">thanks</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Dick Brich</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">if I do not remove it get:</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">(</FONT><FONT SIZE=2 FACE="Arial">Query worked in R17</FONT><FONT SIZE=2 FACE="Arial">)</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">GET.LIST XM.RWB.<<ENTER TERM>> </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">DOWNLOAD STUDENTS \ </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> FILE XH.SDMT.FTP.DIR XM.RWB.STU.ASD<<ENTER TERM>> COMMA.CHAR ^9 OVERWRITING \ </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> SECONDARY.FILE APPLICANTS KEY @ID ALIAS APP \ </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> SECONDARY.FILE PERSON KEY @ID ALIAS PERS \ </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> HEADING \ </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> LITERAL "COLLID" \ </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> LITERAL "HS NAME STATE" \ </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> DETAIL \ </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> @ID \ </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> EVAL "IF XH.STU.HIGH.SCHOOL.STATE = '' THEN XH.STU.HS.NAME ELSE XH.STU.HIGH.SCH</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">OOL.STATE:'-':XH.STU.HS.NAME" \ </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> XU.STU.SAT.VERB </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">XM.RWB.TEMP </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">ENTER TERM 2007SU </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">488 records retrieved to list 0. </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">DOWNLOAD version 7.11 </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Creating temporary list DLMBRICHR55772 </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">488 key(s) saved to 1 record(s). </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">488 records retrieved to list 1. </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Overwriting existing select list. </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">488 records retrieved to list 1. </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Using input file STUDENTS </FONT></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Arial">Output to file XH.SDMT.FTP.DIR XM.RWB.STU.ASD </FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Arial">1 record processed. </FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Arial">The following records were not found on STUDENTS. </FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Arial">Possible causes include mistyping keywords, </FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Arial">mistyping record keys, or having an extraneous </FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Arial">continuation character in your DOWNLOAD statement. </FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Arial">"2007SU" not found. </FONT></B></SPAN>
</P>
<BR>
<BR>
<BR>
</BODY>
</HTML>