RE: Immediate help required on SYSTEM command

It's good advice to have the shell script, this makes it much more flexible -- you can add bells and whistles without having to recode the executable. But it might be as simple as putting a space in your command: SYSTEM 'myexecutable ' || str; -----------------------------------^ > -----Original Message----- > From: Stephen F. Cawley [SMTP:sfcawley@interaccess.com] > Sent: Monday, August 28, 2000 6:08 AM > To: vamsee_2000@my-deja.com > Cc: informix-list@iiug.org > Subject: Re: Immediate help required on SYSTEM command > > As is the case in UNIX cron/at jobs, you should run a shell script which > sets the appropriate environment and then runs your executable. > > SC > > > Hi, I'm trying to call an executable using SYSTEM command in a stored > > procedure. My executable takes a command line argument. I have > > concatenated this command line argument to the executable name and > > calling the SYSTEM command. > > DEFINE str char(20); > > LET str = 'xyz'; > > SYSTEM 'myexecutable' || str; > > but when i execute this procedure, I'm always getting error code 668. > > When I run the executable from command line prompt, it works fine. > > I have double checked that my PATH and other informix related variables > > are set properly. I'm working on Informix 7.3 on AIX unix. > > Need your help in resolving this experts, > > Thanks, > > Vamsee. > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy.