Re: korn shell executed using stored procedure....problem :(

Posted in 2006

Art S. Kagel — Wed, 21 Jun 2006 12:07:24 -0400 — source: Usenet: comp.databases.informix

ggk517@gmail.com wrote: > Hi all, > > I have a korn shell script which executed using the "system" command in > a stored procedure. > Everything works fine when I ran the stored procedure inside the > server. However, it behave abnormally when i ran the stored procedure > in a sql editor (connected to the informix server using ODBC > connection). Does anyone have any idea what is the possible cause? > Thanks a lot for your help. > Does the userid running the procedure using ODBC have a login account with shell capabilities not blocked on the server? If not, thats the problem. Art S. Kagel