MVSFORUMS.com

[kris07]

Hi,
We are retrieving teh date field column and the char filed column thru cursor,since in the table the date field is having no value ,so when we are pulling the data to inrec the output value for the char field is coming with spaces eventhough there is an data
date field is date in db2
char field is char(7).
output both are space.
Pls help how to handle while reading thru cursor to inrec.
Thanks,
krish

[kolusu]

Kris07,

I assuming that you are talking about DATE field having NULL values. If that is the case you can use VALUE/COALESCE/IFNULL and populate it with a default value.

ex :

[kris07]

Thanks for ur suggestions!