We have a feeder system that updates the PERSACTION table nightly. One issue we have is that some e-mails come in that are longer than 30 characters long and after the PA100 is run the HR user needs to enter the correct e-mail address on HR11.
Would it be okay to adjust the sive limit of the NEW_VALUE_1-36 fields to be 60? If so, would I need to run a blddbdict or recompile?
I realise anythin I do would also be changed back when we upgrade.
I concur, increasing the size of NEW-VALUE is a bad idea. Splitting into user fields wouldn't work well either because they are only 13 chars long. If it is a COBOL program that creates the PERSACTION, you may just have to update the table directly, or you could trigger a processflow to update HR11, workunit variables can be up to 250 characters long.