Re: SYSTEM command cannot be executed..

If the exit() value of your SYSTEM command is NOT NUL . then the engine will flag the INSERT as FAILED. Maybe the diff with "nonlogging mode" is getting a rollback as well. rgds /Arthur ----- Original Message ----- From: "Sadi G'rsoy" <sadi@login.com.tr> To: "IIUG" <informix-list@iiug.org> Sent: Monday, December 08, 2003 4:00 PM Subject: SYSTEM command cannot be executed.. > Hi all, > > Our platform is: Sparc Solaris 8 with IDS 9.40.UC2 > > I get a 668 error when doing the following: > > I have to extract a pdf to text in my database. I have created a trigger > for insert on the pdf data table. It executes a stored procedure. The sp > executes a shell file that sets the required environment paramaters and > executes an .ec binary. The ec binary writes the pdf data to an op.system > file and calls a c binary i downloaded from internet doing the conversion > of the .pdf file to .txt file. The .ec binary then inserts the content of > the .txt file to an informix table (text type). > > The architecture is complex some but it works in the database which is > created in nonlogging mode. But when i create the database in > buffered-logging, when i try to insert the data to the byte column, i get > the error 668. I have to use buffered logging mode to use Excalibur > datablade. > > Best Regards, > Sadi > > > > > > > > sending to informix-list > sending to informix-list