How to pad the field to the left with EARL Decode.
search cancel

How to pad the field to the left with EARL Decode.

book

Article ID: 232612

calendar_today

Updated On:

Products

TLMS Tape Management

Issue/Introduction

Using the EARL DECODE to convert scratch status to a YES or NO. Looking for the new field to be pad from the left.

Environment

Release : 14.0

Component :

Resolution

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'

Before:

'NO '

After:

' NO'