winsql - Informix error when calling a procedure -
recently had informix database server cloned. created new stored procedure called sp_foo. when run below sql execute procedure execute procedure sp_foo(); i below error when call stored procedure. error: system command cannot executed or exited non-zero status. (state:s1000, native code: fffffd64) i'm little baffled why error. informix not give me additional data find causing problem. ps: i'm new informix , i'm using winsql/informix odbc run sql. when ran sql in original server there no errors. hard give definitive answer little go on, looks permissions or environment problem. system() call inside sp attempting execute operating system command, , either unable find it, or failing. the fact sp works when run on server suggests me either: when executed via odbc running under different user account different privileges, or the command being executed system() call relying on environment variables exist when invoke script on server, not in place ...