Re: 8i - Calling SQL + from Shell Script Question

Hi,

just an idea that works on OS/390 Host:

declare
<your block>
....
end;
/

whenever sqlerror exit failure 8

declare

   i integer;
begin

   if :my_exit = 22 then

      i := 1 / 0;
   end if;
end;
/

whenever sqlerror exit 4

declare

   i integer;
begin

   if :my_exit = 27 then

      i := 1 / 0;
   end if;
end;
/

whenever sqlerror continue

exit;

hth
Kay Received on Tue Jun 19 2001 - 01:57:19 CDT