The null indicator for the decimal columns of the table is not getting set though those column contains the value as NULL.
I had fired an sql in SPUFI by adding where clause as column name is null and it shows the result.
But in the program when I displyaed the value for the field and it is coming as 000 (zeroes).
and thats why null indicator is not getting set but not able to understand from where it is getting zeros??
Not able to identify what is the issue?
Looking forward to get some replies...
Thanks in anticipation.
Note : Verfied the sql, data type, nullable column and which is fine. Just to let u all know I am using it in multirow fetch cursor.