668: System command cannot be executed

Hi, When i am trying to execute the following query i am getting 668 error. update sch_app_slot set charge_entered = "Y" where appointment_key = 6801796 Getting error 668: System command cannot be executed. 2: No such file or directory Can any one help or assist in getting the above problem resolved Thanks and Regards Srini

You probably have an update trigger on that table/column. That trigger calls a stored procedure in SPL. That stored procedure has a SYSTEM() call inside. So: - dbschema -d your_database -t sch_app_slot - look at the update triggers. There should be an EXECUTE PROCEDURE your_proc - dbschema -d your_database -f your_proc Note that's possible that you have an update trigger that does some DML on another table and the procedure may be associated with one of that table's trigger. Regards On Wed, Jan 18, 2012 at 7:19 AM, SRINIVASAN JAGADEESH < srinuj.hemant@gmail.com> wrote: > Hi, > > When i am trying to execute the following query i am getting 668 error. > > update sch_app_slot set charge_entered = "Y" where appointment_key => 6801796 > > Getting error 668: System command cannot be executed. 2: No such file or > directory > > Can any one help or assist in getting the above problem resolved > > Thanks and Regards > Srini > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --20cf303b42d3c57fd904b6cb097a

It looks like you have an update trigger on that table which is running a stored procedure that wants to execute a script. The script is not in the engine's path. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jan 18, 2012 at 2:19 AM, SRINIVASAN JAGADEESH < srinuj.hemant@gmail.com> wrote: > Hi, > > When i am trying to execute the following query i am getting 668 error. > > update sch_app_slot set charge_entered = "Y" where appointment_key => 6801796 > > Getting error 668: System command cannot be executed. 2: No such file or > directory > > Can any one help or assist in getting the above problem resolved > > Thanks and Regards > Srini > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae9340863f0104504b6cbd34a