<html xmlns:v="urn:schemas-microsoft-com:vml" 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"
xmlns:ns5="http://schemas.microsoft.com/office/2004/12/omml">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><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>
<!--a:link
{mso-style-priority:99;}
span.MSOHYPERLINK
{mso-style-priority:99;}
a:visited
{mso-style-priority:99;}
span.MSOHYPERLINKFOLLOWED
{mso-style-priority:99;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* 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;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:navy;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle18
{mso-style-type:personal;
font-family:Calibri;
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal;
font-family:Arial;
color:navy;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle20
{mso-style-type:personal;
font-family:Calibri;
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in .5in 1.0in .5in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>Eric,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>I understand what you’re saying, I’m just
saying that if you scroll down you can see that I was already doing the select:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>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=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>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=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>Even if I try it with just the one WHEN
statement as:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>SELECT AP.FLE BY.EXP AP.76 WHEN AP.76 = ‘678’<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>DOWNLOAD AP.FLE BY.EXP AP.76 WHEN AP.76 = ‘678’<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>I still get an error message of:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy;background:yellow'>Program
"DLPROCESS": Line 236, Variable "VALUE.CTR" previously
undefined. Zero used.</span></font><font size=2 color=navy face=Arial><span
style='font-size:11.0pt;font-family:Arial;color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>The data comes out with a bunch of null
values as before. I read the documentation for using the BY.EXP and WHEN clause
and I have it just as the documentation says to do it. I am using the 7.30
version which is the most current. I’m wondering if I’m not getting the data I’m
looking for because of the error message that is displayed for each and every
record???<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><st1:PersonName w:st="on"><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Dale
Young</span></font></st1:PersonName><font color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:Street w:st="on"><st1:address w:st="on"><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>9225 Priority Way West</span></font></st1:address></st1:Street><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'> Dr.</span></font><font color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:address w:st="on"><st1:Street w:st="on"><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>Suite</span></font></st1:Street><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> 390</span></font></st1:address><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>Indianapolis</span></font></st1:City><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>, <st1:State
w:st="on">IN</st1:State> <st1:PostalCode w:st="on">46240</st1:PostalCode></span></font></st1:place><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>(317) 569-7493 | Fax (317)
569-7481</span></font><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu] <b><span style='font-weight:bold'>On
Behalf Of </span></b>Spitzner, Eric<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, February 11, 2010
4:01 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">Cedarville
DOWNLOAD Users</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [Download-List]
DOWNLOAD using BY.EXP with two WHEN clauses</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Dale,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Since you say all
three fields are part of the same association it doesn’t matter. I.e., your
criteria </span></font><font size=2 color=navy face=Arial><span
style='font-size:11.0pt;font-family:Arial;color:navy'>WHEN AP.76 = ‘678’ AND
WHEN AP.92 GE ’09-01-04’ </span></font><font size=2 color="#1f497d"
face=Calibri><span style='font-size:11.0pt;font-family:Calibri;color:#1F497D'> implies
that whichever value of AP.76 has a value of ‘678’ you want the corresponding
value of AP.92 to equal ’09-01-04’ and when you get to DownLoad you want that
value of all the associated fields.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Eric Spitzner, CDP
(eric.spitzner@quinnipiac.edu)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Senior
Programmer/Analyst<o:p></o:p></span></font></p>
<p class=MsoNormal><st1:PlaceName w:st="on"><font size=2 color="#1f497d"
face=Calibri><span style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Quinnipiac</span></font></st1:PlaceName><font
size=2 color="#1f497d" face=Calibri><span style='font-size:11.0pt;font-family:
Calibri;color:#1F497D'> <st1:PlaceType w:st="on">University</st1:PlaceType>; <st1:place
w:st="on"><st1:City w:st="on">Hamden</st1:City>, <st1:State w:st="on">Connecticut</st1:State></st1:place><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Sun V490; Solaris
10; UniData 7.1.0<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Colleague 18 and
Benefactor 5.1<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu] <b><span style='font-weight:bold'>On
Behalf Of </span></b><st1:PersonName w:st="on">Dale Young</st1:PersonName><br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, February 11, 2010
3:08 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">Cedarville
DOWNLOAD Users</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [Download-List]
DOWNLOAD using BY.EXP with two WHEN clauses<o:p></o:p></span></font></p>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>Thanks, but I am selecting AP.76 BY.EXP or
are you meaning to also do the AP.92?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><st1:PersonName w:st="on"><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Dale
Young</span></font></st1:PersonName><font color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:Street w:st="on"><st1:address w:st="on"><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>9225 Priority Way West</span></font></st1:address></st1:Street><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'> Dr.</span></font><font color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:address w:st="on"><st1:Street w:st="on"><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>Suite</span></font></st1:Street><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> 390</span></font></st1:address><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>Indianapolis</span></font></st1:City><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>, <st1:State
w:st="on">IN</st1:State> <st1:PostalCode w:st="on">46240</st1:PostalCode></span></font></st1:place><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>(317) 569-7493 | Fax (317)
569-7481</span></font><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu] <b><span style='font-weight:bold'>On
Behalf Of </span></b>Spitzner, Eric<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, February 11, 2010
2:59 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">Cedarville
DOWNLOAD Users</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [Download-List]
DOWNLOAD using BY.EXP with two WHEN clauses</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Dale,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>I think you want to
use BY.EXP in your SELECT as well as your DOWNLOAD statement. The former will
create a SavedList with not only the record key of AP.FLE but the subscript to
the selected value/s of AP.76. DOWNLOAD understands BY.EXP to mean the list its
reading was created by an exploding selection; it doesn’t itself explode
anything, just recognizes that the explosion occurred.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>HTH<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Eric Spitzner, CDP
(eric.spitzner@quinnipiac.edu)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Senior
Programmer/Analyst<o:p></o:p></span></font></p>
<p class=MsoNormal><st1:PlaceName w:st="on"><font size=2 color="#1f497d"
face=Calibri><span style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Quinnipiac</span></font></st1:PlaceName><font
size=2 color="#1f497d" face=Calibri><span style='font-size:11.0pt;font-family:
Calibri;color:#1F497D'> <st1:PlaceType w:st="on">University</st1:PlaceType>; <st1:place
w:st="on"><st1:City w:st="on">Hamden</st1:City>, <st1:State w:st="on">Connecticut</st1:State></st1:place><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Sun V490; Solaris
10; UniData 7.1.0<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Colleague 18 and
Benefactor 5.1<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu] <b><span style='font-weight:bold'>On
Behalf Of </span></b><st1:PersonName w:st="on">Dale Young</st1:PersonName><br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, February 11, 2010
2:52 PM<br>
<b><span style='font-weight:bold'>To:</span></b> download-list@cedarville.edu<br>
<b><span style='font-weight:bold'>Subject:</span></b> [Download-List] DOWNLOAD
using BY.EXP with two WHEN clauses<o:p></o:p></span></font></p>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>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=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>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=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>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=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>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=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>Program "DLPROCESS": Line 236,
Variable "VALUE.CTR" previously undefined. Zero used.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>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=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'>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=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><st1:PersonName w:st="on"><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Dale
Young</span></font></st1:PersonName><font color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:Street w:st="on"><st1:address w:st="on"><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>9225 Priority Way West</span></font></st1:address></st1:Street><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'> Dr.</span></font><font color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:address w:st="on"><st1:Street w:st="on"><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>Suite</span></font></st1:Street><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> 390</span></font></st1:address><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>Indianapolis</span></font></st1:City><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>, <st1:State
w:st="on">IN</st1:State> <st1:PostalCode w:st="on">46240</st1:PostalCode></span></font></st1:place><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>(317) 569-7493 | Fax (317)
569-7481</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>