Controls the format of the WHERE clause with regard to null values when you use the DBKEY= data set option.
Valid in: | DATA and PROC steps |
Default: | LIBNAME statement setting |
Supports: | DB2 under UNIX and PC, Greenplum, MySQL, ODBC, Oracle, Teradata |
WHERE ((COLUMN = ?) OR ((COLUMN IS NULL) AND (? IS NULL)))This syntax enables SAS to prepare the statement once and use it for any value (NULL or NOT NULL) in the column. Note that this syntax has the potential to be much less efficient than the shorter form of the WHERE clause (presented below). When you specify DBNULLKEYS=NO or specify a column that is defined as NOT NULL in the DBKEY= option, SAS generates a simple WHERE clause.
WHERE (COLUMN = ?)