Re: Executing Esql-C pgm

In article <877459541.17172@dejanews.com>, saabtoo@aol.com says... > Hi: > > I have run into an unusual problem that I could use some help with. We > are executing an Esql-C program on our Sun Sparc 2000 server (OS 2.5.1) > from an informix stored procedure (Online 7.20). This Esql-C program > contains code that issues commands on a remote Sun server using rsh. For > these commands to work we must set the permission on the executable of to > the "setuid" bit (ie "rwsrwxrwx" pgm_name). But when the stored > procedure that calls the esql-c program is run, the system call fails > with -668 sqlcode,-172 isam error. When we set the permission to > "rwxrwxrwx" the esql-c program runs but the "rsh" commands fail. > I would appreciate any advice on this problem. > By the way the reason we run this esql-c program from a stored procedure > is that in production our client applications need to run it, so we call > the stored procedure from the Powerbuilder application. > > Thanks, > Joe > > -------------------==== Posted via Deja News ====----------------------- > http://www.dejanews.com/ Search, Read, Post to Usenet > Since the permission is rwsrwxrwx, check whether the owner of the pgm_name has been granted permission to access stored procedure. leekb@post1.com