Re: Problems with null value in SP on 7.3
Alexander V.Didytch wrote:
> <snip>
> create procedure if_null(what int)
> returning int;>
> if what is null
> then return 0;
> else return what;
>
> end if;
> end procedure;
>
> And now lets call it:
>
> execute procedure if_null(null)>
> In 7.2x its returns 0,
> in 7.3 it tells the following error:
> SQL Error (-696) variable (what ) has undefined value
>
<snip>
Hi - Alexander,
I don't know about any (N)ew (T)rouble bugs in 7.30, but in Unix IDS 7.2x
and 7.30 gives following results from dbaccess :
execute procedure if_null(1);
(expression)
1
execute procedure if_null(null);
(expression)
0
--
Have a nice day
Felix K. Mathews
mailto:fmathews@systems.dhl.com
file:////QUASAR/ifmx_app/web/ibs/ibs_61_db/ibs61_db.htm ( IBS 6.1.0 Schema )
file:////QUASAR/ifmx_app/web/ibs/ibs_60_db/ibs60_db.htm ( IBS 6.0.0 Schema )