SQL error = -668 ISAM error = -127

Hello everyone, I receive this error if I call my in ESQL-C written program from any SPL-procedure with the command "system(/path_to_my_program/ my_program)". The program works fine if I call it from command line. IDS can find all notify libraries to run this program because the LD_LIBRARY_PATH is set correctly. I have test and change my_program into any OS-command for example "ls" . It is works correctly. In the next test I have written my_program with only main function and without calls of database etc. Thus it don't work on the database but it is compiled with INFORMIX-ESQLC libraries. It is don't work! My question: is it not allowed to call any ESQLC-program from SPL procedure ??? Why ? My enviroment: IDS 9.40 Suse Linux 8.2

On Jun 27, 12:17 pm, slawek_k <slawek.korde...@t-online.de> wrote: > Hello everyone, > > I receive this error if I call my in ESQL-C written program from any > SPL-procedure with the command "system(/path_to_my_program/ > my_program)". > The program works fine if I call it from command line. > IDS can find all notify libraries to run this program because the > LD_LIBRARY_PATH is set correctly. > I have test and change my_program into any OS-command for example > "ls" . It is works correctly. > > In the next test I have written my_program with only main function and > without calls of database etc. Thus it don't work on the database but > it is compiled with INFORMIX-ESQLC libraries. It is don't work! > > My question: > is it not allowed to call any ESQLC-program from SPL procedure ??? > Why ? > > My enviroment: > IDS 9.40 > Suse Linux 8.2 Your ESQL / C program has no environemnt to run in when called direclt from SPL You need a script that sets the environment - PATH, Informixserver, informixdir , library path etc and then runs the program call the script from your SPL procedure