how to receive a value returned by a unix command running in a stored procedure?

Hello friends, I have a stored procedure that will trigger a awk program using the system() command. The awk program will return a value after completed. However, I cannot get that return value in the stored procedure. Can someone please hellllppppp me? LET runcmd = ' awk ''{...}'' '; LET prod = system (runcmd); ps: there is no value for prod. Thanks a lot for your help.

ggk517@gmail.com wrote: > I have a stored procedure that will trigger a awk program using the > system() command. The awk program will return a value after completed. > However, I cannot get that return value in the stored procedure. Can > someone please hellllppppp me? > > LET runcmd = ' awk ''{...}'' '; > LET prod = system (runcmd); > > ps: there is no value for prod. Google is your friend. Look at: http://tinyurl.com/o6gb5 It leads to a 3-message discussion from April 2006 about this issue. The third message may in fact be the most relevant to you. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/