null indicators?

bzuborski · #1 (**permalink**) 02-13-03, 19:37

hi,

I have a stored procedure which selects from the database
table into local variables. Is there a way to set some indicator
local variables during select to mark if particular field fetched
from database is NULL, without having to do it by
IF-THEN-ELSE logic? (like in Oracle)

thx,
bran

bzuborski · #2 (**permalink**) 02-13-03, 22:14

Also, if indicator variables can be used, can the local variable be
set automatically to some default value when the indicator variable is < 0?

eherber · #3 (**permalink**) 02-14-03, 03:16

No, indicator variables are not supported in stored
procedures, only in esql/c.

But you might use the nvl() function like this:

select nvl(<colname>, '<substitute_value'>)
from <table_name>

This allows you to substitute null values directly in
the select statement.

Internet Services

Web Development

Digital Marketing

Consumer Tech