Thanks Satya, this looks like it worked perfectly.
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of satya tiruveedhi
Sent: Thursday, October 08, 2015 11:14 AM
To: midrange-l <midrange-l@xxxxxxxxxxxx>
Subject: Re: update field based on substring of numeric field
update tstmis/actfile a
set umnum = (select substring(digits(umnum),6,4) from tstmis/shactfile b where a.umact = b.umact and b.umnum > 0 and a.umnum = 0 ) where exists (select 1 from tstmis/shactfile b where a.umact = b.umact and b.umnum > 0 and a.umnum = 0 )
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l
NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.