Re: Powerbuilder + Informix

: pfinkel@cbnews.att.com (paul.d.finkel) writes: : >Problem: how to use Powerbuilder as a means of kicking off a UNIX level : >command. We need to have I4GL reports run on the server side so that they : >can be printed directly to UNIX printers. We think this idea might have merit: : >run a stored procedure that runs a 4gl report. Does any one see any problems : >with that? ... : This is how we implented the same sort of need for a large project just : recently. I trust my partner in crime, David Berg, will give you a blow-by-blow : accounting. If he doesn't answer or post here in the next day or so, contact : him (dberg@informix.com) and I'm sure he'll give you exhaustive details when he : has time. : See how good I am at volunteering other Informix employee's time? : ======================================================================= We have successfully done this by inserting a dummy row into a table that then kicks off a trigger that calls a stored procedure which uses the SYSTEM command to run a script. BE CAREFUL! I just spent a week debugging a raw chunk that kept getting marked down. Apparently a Powerbuilder User was using this method of running a unix script but didn't have any environment set up (env. variables). It is still unknown why, either here or at Informix, why this caused a chunk to keep getting marked down.