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

[Sharon Evans]

Why don't you create two sentences:

SELECT AP.FLE BY.EXP AP.76 WHEN AP.76 = '678'

SELECT AP.FLE BY.EXP AP.92 WHEN AP.92 = '09-01-04'

DOWNLOAD AP.FLE BY.EXP AP.76 AP.92

 

HTH,

Sharon

 

Sharon A. Evans (919)760-8790

Meredith College

Diversity is indispensable to life itself.  It is a great teacher.

 

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/50eb7dfb/attachment.html>