[Download-List] DOWNLOAD using BY.EXP with two WHEN clauses

Dale Young youngd at auctor.com
Thu Feb 11 15:07:51 EST 2010


Thanks, but I am selecting AP.76 BY.EXP or are you meaning to also do the AP.92?

Dale Young
9225 Priority Way West Dr.
Suite 390
Indianapolis, IN 46240
(317) 569-7493  |  Fax (317) 569-7481
________________________________
From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Spitzner, Eric
Sent: Thursday, February 11, 2010 2:59 PM
To: Cedarville DOWNLOAD Users
Subject: Re: [Download-List] DOWNLOAD using BY.EXP with two WHEN clauses

Dale,

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.

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 Dale Young
Sent: Thursday, February 11, 2010 2:52 PM
To: download-list at cedarville.edu
Subject: [Download-List] DOWNLOAD using BY.EXP with two WHEN clauses

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:

SELECT AP.FLE BY.EXP AP.76 WHEN AP.76 = '678' AND WHEN AP.92 GE '09-01-04'
DOWNLOAD AP.FLE BY.EXP AP.76 WHEN AP.76 = '678' AND WHEN AP.92 GE '09-01-04'

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:

Program "DLPROCESS": Line 236, Variable "VALUE.CTR" previously undefined.  Zero used.

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.

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?


Dale Young
9225 Priority Way West Dr.
Suite 390
Indianapolis, IN 46240
(317) 569-7493  |  Fax (317) 569-7481

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


More information about the download-list mailing list