Subject Embedded SQL and NULLs
Author sboydlns
I was wondering if there was some way to handle columns with NULL values without using indicator variables. If I were to initialize all host variables to some sensible value, like zero for numeric fields and an empty string for character fields, would those values be preserved by the FETCH. That is, would NULL columns returned by the FETCH leave the affected host variables unchanged?