Re: How to check SQLCODE in trigger

lenygold via DBMonster.com wrote:
> I TRIED ONLY SP AND ALSO AN ERROR:
> 
> CALL execute_immediate('select * FROM FAMILY',out_sqlcode);
> 
>  CALL execute_immediate('select * FROM FAMILY',out_sqlcode)
> SQL0206N  "OUT_SQLCODE" is not valid in the context where it is used.  
> SQLSTATE=42703 
> sqlcode: -206
Of course out_sqlcode is not defined.

in your trigger this presumably looks like this:

CREATE TRIGGER ....
  BEGIN ATOMIC
    DECLARE out_sqlcode INTEGER;
    CALL execute_immediate('....', out_sqlcode);
  END
@[EMAIL PROTECTED]
 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab