Hello,

Somebody can tell me how to execute un script shell with parameters in stored procedure of informix-SE.

this my exemple which don't accept v_accode:

CREATE procedure unl_insert (v_accode char(10))

SYSTEM
"./unl_insert_ecg.ksh v_accode";

END procedure

The script is :unl_insert_ecg.ksh
parameter is variable of informix SPL --> v_accode


thanks in advance.

wahi.

Well, it's not entirely clear what you want, but....

I think you're looking for the concatenate operator || which will join one string to another.

SYSTEM "./unl_insert_ecg.ksh" || v_accode;

Though you should really include exception handling around it, and possibly define your return values.