Re: Executing system in stored procedures on remote servers

Ravi Pinto wrote: >I execute a program from server A which invokes a stored >procedure. This stored procedure in turn executes a system >call. And that is where problem strikes. >The db error is -668 and isam error is -2. What kind of system call are you performing? Error -2 is a "no such file or directory" error. I suspect you haven't tested the system call directly from the command prompt. Check to make sure your files and directories on the production server are the same (obviously, they're not) as your test system. Additionally, review the file permissions on all files affected by the system call. -mka Michael Ackerbauer SP System Test

In article <77lc7s$do9$1@news.xmission.com>, ackerbau@us.ibm.com wrote: Hi Michael, > > Ravi Pinto wrote: > >I execute a program from server A which invokes a stored > >procedure. This stored procedure in turn executes a system > >call. And that is where problem strikes. > > >The db error is -668 and isam error is -2. > > What kind of system call are you performing? Error -2 is a "no such file > or directory" error. The System call is supposed to be doing an rsh to server A. However, it is not working even with /bin/ls. > > I suspect you haven't tested the system call directly from the command > prompt. Check to make sure your files and directories on the production > server are the same (obviously, they're not) as your test system. > Been there, done that. > Additionally, review the file permissions on all files affected by the > system call. > Any other pointers ??? Some Informix bug w.r.t AIX ??? > -mka > > Michael Ackerbauer > SP System Test > Thanks, Ravi... > -- Ravi Pinto, Bombay, India. Usenet address : mailto:ravipinto@my-dejanews.com -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own