Re: SPL behaving oddly


malc_p@xxxxxxxxxxxxxx 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?

It looks like a SHELL problem. What is your default shell?

It almost looks as if it is looking for a file called
"/opt/ROBIN/progs/general/interfaces/proj_request/proj_request.sh ROBIN
inetuser 290 1002678". As if the command and all parameters has somehow
been wrapped in quotes.

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@xxxxxxxxxxxxxxxxxx |//////// /|
| |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.12.2/138 - Release Date: 17/10/2005
sending to informix-list
.

Relevant Pages

  • Re: Getmac reports ERROR Provider type not defined.
    ... If it is failing in your code, check out WSAGetLastError for the error code. ... my shell can't connect to another pc. ... >> Do you use you customer script to work with netsh? ...
    (microsoft.public.windowsxp.embedded)
  • SPL behaving oddly
    ... HP-UX 11i, IDS 9.30HC5 ... We have an SPL which is failing to run here - it's a fairly simple one ... used to call a shell script when executed, ...
    (comp.databases.informix)
  • Re: Veronica Guerin
    ... but failing that Jake would like a word in your shell like. ... "Bog snorkler extraordinaire" ...
    (soc.culture.irish)
  • Re: SPL behaving oddly
    ... > HP-UX 11i, IDS 9.30HC5 ... > We have an SPL which is failing to run here - it's a fairly simple one ... > used to call a shell script when executed, ... > put into the IDS message log: ...
    (comp.databases.informix)
  • Re: Calling exe with parameter doesnt work....
    ... Regardless of whether you "did it especially", the way you're doing it is failing. ... In windows in shell you have to launch mysqldump like ... both works fine from shell, so the problem is not here. ...
    (microsoft.public.dotnet.framework.aspnet)