Re: Is 4GL calling C safe from within a stored proc?

There's some pretty confusing terminology used here! Firstly: >Subject: Re: Is 4GL calling C safe from within a stored proc? You can't use 4GL in a Stored Procedure at all, let alone to call C! In comp.databases.informix you write: > 4GL programs can call C programs. 4GL can RUN any kind of program. C has nothing to do with it. 4GL can call C functions, but not C programs. > Is this supported in a stored > procedure? The SPL command SYSTEM is equivalent to the 4GL RUN command, but without equivalents to the RETURNING or WITHOUT WAITING clauses. There is of course no way to call a C function from SPL. > If it supported, is it safe and by this I mean, can > failure of the called C program (e.g. writing to a bad pointer) > bring down the server? It is not clearly documented which machine SYSTEM executes the command on, but I am sure (without having tested it) that it runs on the server, so if your command caused a crash it would bring down the server, not the client. graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.