Re: Q of UNIX command in procedure

Paul Watson wrote: > > yejun@hotmail.com wrote: > > > > Hey, > > > > Does any one make use UNIX command in store procedure before? And > > does SE 7.X support Store Procedure? > > > > > I need the return value to check if it's success or not. > > When I try to get return value in SP. It give me a syntax error. > > > > ie. let rt1 = system "run_my_program" > > This is not supported. If you need to return things to the calling SPL > the easiest way is to use a table > > > > > I'm appreciated to get reply from you, informix guru. > > > > Rgds > > > > Jun > > > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > > http://www.dejanews.com/ Now offering spam-free web-based newsreading > > -- > Paul Watson # > WF Software Ltd # It said run using Windows 95 > Tel: +44 1436 674629 # or better in the manual > Fax: +44 1436 678693 # so I used Unix > www.wfsoftware.co.uk # SE 7.1+ supports stored procedures. Page 2-44 on SYSTEM in the syntax manual states "Your procedure cannot use a value or values returned by this command." As Paul hinted, your shell script must write a file in UNLOAD format and then the SPL can LOAD it into a table. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.co.uk/