I'm trying to write a sql statement to update a numeric field in tstmis/actfile, but I'm running into a problem with null
Null values not allowed in column or variable UMNUM
Below is the query
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 )
I think the problem is when I have a value like 123450000 which creates a substring of 0000
Any idea how to get around this?
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.
This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact