<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 97.0pt 1.0in 97.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>I tried that, re-compiled, re-catalogued, and got
different error messages:<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>Program
"DLPROCESS": Line 306, Variable "X.BUILDING.DATA.VALUE"
previously undefined. Zero used.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>Program
"DLPROCESS": Line 308, Variable previously undefined. Zero
length string used.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>Program
"DLPROCESS": Line 308, Variable "X.BUILDING.DATA.SUBVALUE"
previously undefined. Zero used.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>Program
"DLPROCESS": Line 327, Variable previously undefined. Zero
length string used.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>Program
"DLPROCESS": Line 327, Variable "X.BUILDING.DATA.SUBVALUE"
previously undefined. Zero used.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>Program
"DLPROCESS": Line 330, Variable "X.BUILDING.DATA.VALUE"
previously undefined. Zero used.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>Good luck with the surgery.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><st1:PersonName w:st="on"><font size=2 color=navy
face=Arial><span style='font-size:11.0pt'>Dale Young</span></font></st1:PersonName><o:p></o:p></p>
<p class=MsoPlainText><st1:Street w:st="on"><st1:address w:st="on"><font
size=2 color=navy face=Arial><span style='font-size:11.0pt'>9225 Priority Way
West</span></font></st1:address></st1:Street> Dr.<o:p></o:p></p>
<p class=MsoPlainText><st1:address w:st="on"><st1:Street w:st="on"><font
size=2 color=navy face=Arial><span style='font-size:11.0pt'>Suite</span></font></st1:Street>
390</st1:address><o:p></o:p></p>
<p class=MsoPlainText><st1:place w:st="on"><st1:City w:st="on"><font size=2
color=navy face=Arial><span style='font-size:11.0pt'>Indianapolis</span></font></st1:City>,
<st1:State w:st="on">IN</st1:State> <st1:PostalCode w:st="on">46240</st1:PostalCode></st1:place><o:p></o:p></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>(317) 569-7493 | Fax (317) 569-7481<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>-----Original Message-----<br>
From: download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu] On Behalf Of <st1:PersonName
w:st="on">David L. Rotman</st1:PersonName><br>
Sent: Monday, February 15, 2010 3:19 PM<br>
To: download-list@cedarville.edu<br>
Subject: Re: [Download-List] DOWNLOAD using BY.EXP with two WHEN clauses</span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>I have done some additional research on this problem
and believe <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>that I have identified a related bug in producing
output<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>using BY.EXP (for comma-quote output and xml
output). I would<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>like to work on this for a few days before releasing a
patched<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>version. (This work will likely be delayed
pending some minor<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>surgery and recovery.)<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>In the meantime, you might try this
modification: In the routine<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>DLPROCESS (DOWNLOAD.PROCESS on Unidata)<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>, at line 168 you should find:<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>0168:
GOSUB BUILD.COMMA.QUOTE.DATA.VALUE<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>Try changing that line to <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>0168:
GOSUB BUILD.COMMA.QUOTE.DATA.SUBVALUE<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>You will need to recompile (and perhaps recatalog) the
program.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>Let me know how the change works.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>Dave Rotman<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>Associate Vice President for Technology<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>Chief Information Officer<o:p></o:p></span></font></p>
<p class=MsoPlainText><st1:place w:st="on"><st1:PlaceName w:st="on"><font
size=2 color=navy face=Arial><span style='font-size:11.0pt'>Cedarville</span></font></st1:PlaceName>
<st1:PlaceType w:st="on">University</st1:PlaceType></st1:place><o:p></o:p></p>
<p class=MsoPlainText><st1:Street w:st="on"><st1:address w:st="on"><font
size=2 color=navy face=Arial><span style='font-size:11.0pt'>251 N. Main
Street</span></font></st1:address></st1:Street><o:p></o:p></p>
<p class=MsoPlainText><st1:place w:st="on"><st1:City w:st="on"><font size=2
color=navy face=Arial><span style='font-size:11.0pt'>Cedarville</span></font></st1:City>,
<st1:State w:st="on">OH</st1:State> <st1:PostalCode w:st="on">45314</st1:PostalCode></st1:place><o:p></o:p></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>rotmand@cedarville.edu<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>voice 937-766-7905<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>fax 937-766-8819<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>>>> <st1:PersonName w:st="on">Dale Young</st1:PersonName>
<youngd@auctor.com> 2/11/2010 2:51 PM >>><o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>I have a UniVerse process that has a file with
multi-values with 3 fields associated (field 7 of dictionary contains the same
association for all 3 fields; AP.76, AP.92, and AP.93). I'm trying to use the
BY.EXP with using the WHEN for one field and the WHEN for another field:<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>SELECT AP.FLE BY.EXP AP.76 WHEN AP.76 = '678' AND WHEN
AP.92 GE '09-01-04'<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>DOWNLOAD AP.FLE BY.EXP AP.76 WHEN AP.76 = '678' AND
WHEN AP.92 GE '09-01-04'<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>Of course I'm using the AP.76 and AP.92 fields to
return the data along with some other fields. I keep getting an error message
from DLPROCES:<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>Program "DLPROCESS": Line 236, Variable
"VALUE.CTR" previously undefined. Zero used.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>I do get the right record count, but most of my AP.76
and AP.92 values are null, the ones that are not null do have the 678 with a
date GE 09-01-04.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>I have a bunch of requests for this information using
different values and report criteria, but all using the same select basics. Any
ideas what I'm doing wrong?<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><st1:PersonName w:st="on"><font size=2 color=navy
face=Arial><span style='font-size:11.0pt'>Dale Young</span></font></st1:PersonName><o:p></o:p></p>
<p class=MsoPlainText><st1:Street w:st="on"><st1:address w:st="on"><font
size=2 color=navy face=Arial><span style='font-size:11.0pt'>9225 Priority Way
West</span></font></st1:address></st1:Street> Dr.<o:p></o:p></p>
<p class=MsoPlainText><st1:address w:st="on"><st1:Street w:st="on"><font
size=2 color=navy face=Arial><span style='font-size:11.0pt'>Suite</span></font></st1:Street>
390</st1:address><o:p></o:p></p>
<p class=MsoPlainText><st1:place w:st="on"><st1:City w:st="on"><font size=2
color=navy face=Arial><span style='font-size:11.0pt'>Indianapolis</span></font></st1:City>,
<st1:State w:st="on">IN</st1:State> <st1:PostalCode w:st="on">46240</st1:PostalCode></st1:place><o:p></o:p></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>(317) 569-7493 | Fax (317) 569-7481<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>_______________________________________________<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>download-list mailing list<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>download-list@cedarville.edu<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'>http://mail.cedarville.edu/mailman/listinfo/download-list<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 color=navy face=Arial><span
style='font-size:11.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>