System command cannot be executed (-668) (resend)
Hi folks,
I am using IDS 7.23 on solaris 5.6
My stored procedure looks like this :
create procedure sp_test(chrUsr NCHAR(8))DEFINE str_buf varchar(255);
LET str_buf = "'GRANT connect to '" ||chrUsr||"';'";
system 'echo ' || str_buf || ' > /informix/user/user.sql';
system '/informix/user/user.sh';
end procedure
When I am executing this stored procedure from the server, where Informix is
installed,
It is successfully executing the procedure.
But when I am calling this stored procedure from External Application (From
windows machine)
I am getting the following error.
"System command cannot be executed." (Informix error message : -668).
The description says, I have to set some PATH. Which PATH do I need to set,
inorder to execute the stored procedure successfully?
(I think the problem is coming at "system 'echo'" statement.)
Thanks In Advance
anil