I suspect the problem lies in the size of the value returned by %subdt... Your
code implies that the returned value will be held in a numeric (4,0) field, but
I don't think this is necessarily true.....
Eric
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[
mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of
Arthur.Marino@xxxxxxxxxxxxxxxx
Sent: Wednesday, June 20, 2007 11:13 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Complex Eval
I wanted to extract the low order 2 digits of the year value in an *iso
date field. Trying to do the most in the shortest possible instruction, I
entered:
D iso_date s d
eval pr_year = %dec(%subst(%editc(%subdt(iso_date:*y):'X'):3:2):2:0)
iso_date contains '2007-06-16'
pr_year is a 2-byte numeric (whole number) field
After the 'eval', pr_year contained 00, not 07. I figured I'm not
understanding something about the step-by-step nature of complex
statements. My first workaround attempt involved extracting the innermost
evaluation and doing it separately (fscl@yr is 4,0):
eval fscl@yr = %subdt(iso_date:*y)
eval pr_year = %dec(%subst(%editc(fscl@yr:'X'):3:2):2:0)
This worked fine. Anybody (or everybody) know why the first 'eval' didn't
work? Thanks.
Arthur J. Marino
Southern Container Corporation
(631) 297 - 2276
midrange.com
