<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.spelle
{mso-style-name:spelle;}
span.grame
{mso-style-name:grame;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</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=WordSection1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Rob,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I think you can get what you want by first executing SELECT
STUDENT.ACAD.CRED … BY.EXP STC.STATUS (because as I recall, STC.STATUS is
the controller of the association), then execute DOWNLOAD including the keyword
BY.EXP ST.STATUS. What will happen is that the SELECT statement will produce an
active list composed of not only the record keys of the selected
STUDENT.ACAD.CRED record, but – separated from the key by value marks
(@VM) – subscripts of the value & subvalue of the selected STC.STATUS
(and all the associated items). You will then omit the NUM.VALUES and
ORIENTATION keywords as DOWNLOAD will see each STUDENT.ACAD.CRED record once
for each value of STC.STATUS.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I see that you include an XLLCC variable. I suppose this is a
custom computed column. You must be sure it is included in the association for
DOWNLOAD to recognize its membership in the association. It may be necessary to
create computed columns for each of the multi-valued data elements in
association with STC.STATUS and a new ASSOCIATION. We (QU) have done that in
the past and it seems to work reasonably well. It’s sort of like a VOC
SYNONYM.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>HTH<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Eric Spitzner, CDP (eric.spitzner@quinnipiac.edu)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Senior Programmer/Analyst<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Quinnipiac University; Hamden, Connecticut<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Sun V490; Solaris 10; UniData 7.1.0<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Colleague 18 and Benefactor 5.1<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu] <b>On Behalf Of </b>Rob Spence<br>
<b>Sent:</b> Monday, October 11, 2010 11:10 AM<br>
<b>To:</b> download-list@cedarville.edu<br>
<b>Subject:</b> [Download-List] Need help with Multi-valued download<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Hello,</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>We
are running the following download and getting the output listed below under
"Sample Output". We were interested in finding out if there are
alternate ways to output this data. It may not be as efficient, but we'd
like to get a single record per multi valued items. Is this possible?</span><o:p></o:p></p>
</div>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>DOWNLOAD STUDENT.ACAD.CRED \<br>
@ID \<br>
STC.STATUS NUM.VALUES ALL MV.ORIENTATION VERTICAL \<br>
STC.STATUS.DATE NUM.VALUES ALL MV.ORIENTATION VERTICAL \<br>
XLLCC.STC.STATUS.TIME.NOCNV NUM.VALUES ALL MV.ORIENTATION VERTICAL \<br>
STC.STATUS.TIME NUM.VALUES ALL MV.ORIENTATION VERTICAL \<br>
FORMAT COMMA FILE L30.FILEEX.<span style='color:navy'>DIR</span> <span
style='color:navy'>FILE</span>.<span style='color:navy'>TXT</span> OVERWRITING
NO.PAGE NO.DISPLAY.COUNT</span><span style='font-family:"Courier New";
color:navy'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:navy'>Sample
Output</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>:</span><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Courier New"'>"<span
style='color:navy'>123456</span>","W"<br>
,"N"<br>
,"D"<br>
,"N","07/01/10"<br>
,,"06/02/10"<br>
,,"05/18/10"<br>
,,"05/17/10",29082<br>
,,,46819<br>
,,,46883<br>
,,,34583,"08:04AM"<br>
,,,,"01:00PM"<br>
,,,,"01:01PM"<br>
,,,,"09:36AM"<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:navy'>Desired
output:<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>"123456","W","07/01/10",29082,"08:04AM"<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>"123456","N","06/02/10",46819,"01:00PM"<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>"123456","D","05/18/10",46883,"01:01PM"<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>"123456","N","05/17/10",34583,"09:36AM"<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><strong><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>Rob
Spence</span></strong><span style='font-size:10.0pt;font-family:"Garamond","serif";
color:gray'><br>
</span><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";
color:black'>System Engineer<br>
<span class=spelle>ZogoTech</span></span><span style='font-size:7.5pt;
font-family:"Verdana","sans-serif";color:gray'> </span><span style='font-size:
7.5pt;font-family:"Verdana","sans-serif";color:black'><br>
</span><b><span style='font-size:8.0pt;font-family:Wingdings;color:olive'>(</span></b><b><span
style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:olive'> </span></b><span
style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray'>toll-free:
</span><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";
color:navy'>(888) 221-6372 x 808 <br>
</span><b><span style='font-size:8.0pt;font-family:Wingdings;color:olive'>(</span></b><b><span
style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:olive'> </span></b><span
class=grame><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";
color:gray'>dallas</span></span><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";
color:gray'>: </span><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";
color:navy'>(214) 774-4780 x 808<br>
</span><b><span style='font-size:8.0pt;font-family:Wingdings;color:olive'>*</span></b><b><span
style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:olive'> </span></b><span
style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray'>email: </span><span
style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:blue'><a
href="mailto:rspence@zogotech.com" title="blocked::mailto:rspence@zogotech.com"><span
style='color:#0066CC'>rspence@zogotech.com</span></a></span><span
style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray'><br>
</span><a href="http://www.zogotech.com/"
title="blocked::http://www.zogotech.com/
http://www.zogotech.com/"><span
style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:navy'>www.zogotech.com</span></a><span
lang=EN-GB style='color:black'><o:p></o:p></span></p>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
</div>
</body>
</html>