MSDB2 returns DBNULL for VARCHAR with length 0

[JohnYingling]

When switching from DB2OLEDB to the MSDB2 managed provider with strongly type datasets, I encountered a "Cannot get value because it is DBNull". The field was defined in the DB2 database as VARCHAR. I included a WHERE field IS NOT NULL in the SQL but the row was still returned, verifying that the field was not NULL and suggesting that it exists and has a length = 0. So MSDB2 fills the datacolumn with DBNULL if the source field is VARCHAR with length = 0.

http://www.moldyoldy.com/VBComparedemo

- free online Compare/Diff of snippets