stores_demo -  functions -  ifx_trigger_action

Description

none

Function properties

name	value
name	ifx_trigger_action
created
type	SQL scalar function

Parameters

none

Usage

set @myvar = ifx_trigger_action

Code

create dba procedure informix.ifx_trigger_action(trigid int, when CHAR(10))
    returns informix.lvarchar; 
    define cleanwhen    char(10);
    define intwhen        int;

    let cleanwhen = trim (BOTH FROM when);
    if (cleanwhen = 'BEFORE' or cleanwhen = 'before') then
        let intwhen = 1;
    elif (cleanwhen = 'ROW' or cleanwhen = 'row') then
        let intwhen = 2;
    elif (cleanwhen = 'AFTER' or cleanwhen = 'after') then
        let intwhen = 3;
    else
        return NULL;
    end if;
    
    return (informix.trigger_action(trigid, intwhen));
end procedure;