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