Problem running a 4GL program with an stored procedure
by "roger.camargo@[EMAIL PROTECTED]
" <roger.camargo@[EMAIL PROTECTED]
>
May 21, 2008 at 03:12 PM
We had a system that used STORED PROCEDURES(Launched via an ODBC
connection) to execute 4GL programs that generate TXT files (data
delimited with "|") that were loaded then into another program.
We have migrated to the new INFORMIX 11.50 and when we try to run the
stored procedures there is an error produced:
Error: The system command cannot be executed or it exited with a non-
zero status. (State:S1000, Native Code: FFFFFD64)
The stored procedure that we create is:
CREATE PROCEDURE test()
SYSTEM 'fglgo /disco2/bexe/sgfreversiones.4gi';
END PROCEDURE;
And we execute it:
EXECUTE PROCEDURE test();
Information on our previous system:
INFORMIX 9.4 running on a Sun SOLARIS
and now:
INFORMIX 11.50 running on Linux RED HAT
Any hints and help would be appreciated
Roger Camargo
Cochabamba - Bolivia