Re: SPL behaving oddly

when you run it in debug what is the system line saying ? Does the script run from command line malc_p@btinternet.com wrote: > HP-UX 11i, IDS 9.30HC5 > > Afternoon chaps > We have an SPL which is failing to run here - it's a fairly simple one > used to call a shell script when executed, code as follows: > > CREATE FUNCTION "dba".request_proj(env CHAR(5),user CHAR(12), pref INT, > cref INT > ) > > RETURNING INT; > > > > DEFINE path CHAR(50); > > DEFINE error_num INT; > > DEFINE error_val INT; > > > > ON EXCEPTION > > SET error_num,error_val > > END EXCEPTION WITH RESUME > > > LET error_val = 0; > > > LET path = > '/opt/'||TRIM(env)||'/progs/general/interfaces/proj_request/' > ; > > > SYSTEM TRIM(path)||'proj_request.sh ' ||TRIM(env)||' '||user||' > '|| > pref||' '||cref; > > > RETURN error_val; > > > END FUNCTION; > > .... and it's failing with a return code of -2, and the following is > put into the IDS message log: > > 11:26:09 execve() of " -c > /opt/ROBIN/progs/general/interfaces/proj_request/proj_request.sh ROBIN> inetuser 290 1002678" failed errno=2 > > This is palpably rubbish - the -2 error is "No such file or directory" > but the file is there - I've even set the access perms on it and it's > path to 777. > Does anyone know what execve() is doing? > Anyone seen this before? > > Puzzled of West Malling > -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com # sending to informix-list