Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Informix > Problem running...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 14092 of 15119
Post > Topic >>

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
 




 5 Posts in Topic:
Problem running a 4GL program with an stored procedure
"roger.camargo@[EMAI  2008-05-21 15:12:45 
Re: Problem running a 4GL program with an stored procedure
"Paul Watson (Oninit  2008-05-21 23:41:48 
Re: Problem running a 4GL program with an stored procedure
scottishpoet <dryburgh  2008-05-23 03:44:42 
Re: Problem running a 4GL program with an stored procedure
"roger.camargo@[EMAI  2008-05-23 06:32:53 
Re: Problem running a 4GL program with an stored procedure
"roger.camargo@[EMAI  2008-05-23 06:44:40 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:45:22 CST 2008.