From one of the program, i am trying to query on the SYSIBM.SYSDUMMY1 table to obtain the future date, by adding to 1 month, 3 month , 6 month & 12 month to the date passed.
This program is called from many modules in all the places its working fine and its returning date, but in one program its returning spaces. however, for the same input with sane date format as a standalone its working fine.
Thinking that the variable might be not correctly initialized, i tried passing the date in different ways, but didn't work.
so could you please help me out to sort out this issue, please refer the attachment of the program flow taken while executing code in debugging mode.