Re: can triggers call c routine

On Jun 23, 9:54pm, stevie@gate.net wrote: > Subject: Re: can triggers call c routine > > kimmel@oahu.sedd.trw.com (Mike Kimmel) writes: > > We are thinking of upgrading to Online 6.0 or 7.0 > > Can triggers call a C routine or system call? > > or just a stored procedure. > > Thanks, Mike > > > > > >>>> > Unfortunately, they can only call stored procedures! > > stevie@gate.net > >-- End of excerpt from stevie@gate.net This isn't entirely true though for many times, when calling a C function would solve a lot of problems, it might as well be. You can call other stored procedures. You can't call a c routine but you can launch a separate program with the SYSTEM statement. The program can call whatever you want and do anything but (there is always a but) SPL can only directly accept the exit code from the program launched. It is of course possible to handle data communication betwen the SP and the program via tables in the database. This option is only really usefull when you have a reasonable amount for the program to do. Otherwise the process launch and communications cost outweigh the costs of having to do this code before you call the SPL. Cheers - Jim -- ----------------------------------------------------------------------------- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ----------------------------------------------------------------------------- My opinions are my own. They may vary with time but they remain mine!