An error is returned by the Database Management System (DBMS) when you use a WHERE clause or WHERE statement to subset a DBMS table


When you use a WHERE clause or WHERE statement to subset a DBMS table, an error might be returned by the DBMS. The actual error received differs depending on the DBMS.

You encounter this issue when you code the WHERE clause or statement similar to the following:

WHERE varname > ''

The query that is passed to the DBMS includes incorrect syntax similar to the following:

WHERE ("VARNAME" > ' ' "VARNAME" IS NULL)

The workaround is to code the WHERE clause or statement similar to the following:

WHERE varname is not null