[Download-List] Need help with Multi-valued download

[Spitzner, Eric]

Rob,

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.

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.

HTH
Eric Spitzner, CDP (eric.spitzner at quinnipiac.edu)
Senior Programmer/Analyst
Quinnipiac University; Hamden, Connecticut
Sun V490; Solaris 10; UniData 7.1.0
Colleague 18 and Benefactor 5.1



From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Rob Spence
Sent: Monday, October 11, 2010 11:10 AM
To: download-list at cedarville.edu
Subject: [Download-List] Need help with Multi-valued download

Hello,

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?
DOWNLOAD STUDENT.ACAD.CRED \
@ID \
STC.STATUS NUM.VALUES ALL MV.ORIENTATION VERTICAL \
STC.STATUS.DATE NUM.VALUES ALL MV.ORIENTATION VERTICAL \
XLLCC.STC.STATUS.TIME.NOCNV NUM.VALUES ALL MV.ORIENTATION VERTICAL \
STC.STATUS.TIME NUM.VALUES ALL MV.ORIENTATION VERTICAL \
FORMAT COMMA FILE L30.FILEEX.DIR FILE.TXT OVERWRITING NO.PAGE NO.DISPLAY.COUNT
Sample Output:
"123456","W"
,"N"
,"D"
,"N","07/01/10"
,,"06/02/10"
,,"05/18/10"
,,"05/17/10",29082
,,,46819
,,,46883
,,,34583,"08:04AM"
,,,,"01:00PM"
,,,,"01:01PM"
,,,,"09:36AM"

Desired output:

"123456","W","07/01/10",29082,"08:04AM"
"123456","N","06/02/10",46819,"01:00PM"
"123456","D","05/18/10",46883,"01:01PM"
"123456","N","05/17/10",34583,"09:36AM"


Rob Spence
System Engineer
ZogoTech
* toll-free: (888) 221-6372 x 808
* dallas: (214) 774-4780 x 808
* email: rspence at zogotech.com<mailto:rspence at zogotech.com>
www.zogotech.com<http://www.zogotech.com/>

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