I have a variable ( like ZZZZZ.ZZ).This will be populated by values in a DB2 column.
I need to validate every character in the above variable and based on values ,I need to move the corresponding values(refer NOTE below) in to the output variable
Ex: If the value is 12345.56 ,the corresponding output variable value wil be MFGYRDVX
Note: There is a table for these values like when 1 it should be M ,for 2 - F,for 3 - G etc.....like that.
Tell me some good logic which will reduce the run time.By normal method i can do but I am in search of that logic, which will reduce the run time.
I think u can use the INSPECT verb for ur requirement. first u need to move the zzzz.zz value to alphanumeric variable and then use the INSPECT verb to replace the digits with the corresponding characters