Re: OPNQRYF & SQLCBL Problem

[boothm@xxxxxxx]

In <0056650003949765000002L552*@MHS>, on 04/05/99 
   at 05:32 PM, VENU YAMAJALA  <venu_yamajala@goodyear.com> said:


>Some arithmetic formula with VDATE to make it CCVDATE temporarily and
>then compare this CCVDATE.

Would something along the lines of MAPFLD(CCVDATE &MAPF *DEC) work, 

where &MAPF is defined as  ( *CHAR 256) 

and CHGVAR &MAPF VALUE("((VDATE *LE 400101) + 1000000) + VDATE + 19000000" )

I'm not near a machine so I can't test this, but what I am trying to do is 
create a mapped field definition of "If VDATE is less or equal to Jan 1st, 
1940, then z-add 1,000,000 to the field CCVDATE; then add VDATE, and then add 
19,000,000".



-- 
-----------------------------------------------------------
boothm@ibm.net
Booth Martin
-----------------------------------------------------------

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---