Using the EARL DECODE to convert scratch status to a YES or NO. Looking for the new field to be pad from the left.
Release : 14.0
The current DECODE statement is:
DECODE SCRATCH_IND INTO T_SRC 'N' = 'NO ' 'Y' = 'YES'
Change the 'N' statement to a blank in front of the NO verb:
DECODE SCRATCH_IND INTO T_SRC 'N' = ' NO' 'Y' = 'YES'