Concatenate the column's previous and changed values and put it into a string.
Posted on 2006-05-24
I have a data window (PB9) contains 50 columns retrieving from a sp. In that window, suppose user did some changes in some columns. My task is to find out that changes and send it as a string for update sp. The update procedure is a COBOL Procedure. So only thing I need to do is to send it as a string (540) as shown as the below format.
Column_description (String(15))+ previous_value String(10)+changed_value String(10)+;
The total length of the string for one column is(15+10+10+1) = 36
So it should be like
I have to send 15 column values as above format. So the final string length is 15 (columns) * 36 (formatted of each column length) = 540
It should be like
So how can I find out the previous value, changed value and concatenate these values into one string.
Thanks for your advance help.