Thread: shift data with a REDEFINES clause

Question asked by guest visitor Chad

Is there any way to shift data with a REDEFINES clause? ie, I have a pic x(9) with left justified data and I want to redefine it with a pic 9(9) padded with zeros on the left so that it is a proper DB2 integer.

Your plan will nor work.
you can just redefine
numeric data with numeric fields and
alphanumeric data with alphanumeric fields.