Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Madrid
    Posts
    14

    Question Unanswered: execute script shell in stored procedure.

    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.

  2. #2
    Join Date
    Jul 2009
    Posts
    37
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •