Database Toolbox

isnullcolumn

Detect if last record read in resultset was NULL

Syntax

• a = isnullcolumn(rset)
  

Description

a = isnullcolumn(rset) returns 1 if the last record read in the resultset rset, was NULL, and returns 0 otherwise.

Examples

Example 1--Result Is Not NULL

Type

• curs = fetch(curs,1);
  rset = resultset(curs);
  isnullcolumn(rset)
  

MATLAB returns

• ans =
       0
  

indicating that the last record of data retrieved was not NULL. To verify this, type

• curs.Data
  

MATLAB returns

• ans = 
      [1400]
  

Example 2--Result Is NULL

• curs = fetch(curs,1);
  rset = resultset(curs);
  isnullcolumn(rset)
  

MATLAB returns

• ans =
       1
  

indicating that the last record of data retrieved was NULL. To verify this, type

• curs.Data
  

MATLAB returns

• ans = 
      [NaN]
  

See Also
get, resultset

isjdbc

isreadonly