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

David L. Rotman rotmand at cedarville.edu
Fri Feb 12 07:23:22 EST 2010


Thanks for posting this.  The program should not be displaying this error.  I'll try to do some research on this over the weekend to find out what is causing the problem.





Dave Rotman
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819
 
>>> Dale Young <youngd at auctor.com> 2/11/2010 2:51 PM >>>
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






More information about the download-list mailing list