Stored procedure problems.

Message is sent with MIME. Attachments are base64 encoded --TFS-with-MIME-and-DIME Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable Hi, =20 We're currently in the middle of a porting exercise from Sybase to=20 Informix, and have a large number (3500+) of stored procedures that=20 need converting=2E Informix doesn't appear to do much checking when y= ou=20 load a procedure, e=2Eg=2E Sybase uses the function power(), whereas=20 Informix has pow()=2E Incorrect SP's load with these functions, but=20 error at runtime=2E Is there some checking we can do when loading the= se=20 SP's so that they error on loading rather than execution? =20 Ta Davin ********************************************************************** DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu= k=20 This message and any attachments to it is intended only for the=20 individual or company to which it is addressed and may contain=20 information which is privileged, confidential or prohibited from=20 disclosure or unauthorised use=2E If the recipient of this=20 transmission is not the intended recipient, or the employee or agent=20 responsible for delivering such materials to the intended recipient,=20 you are hereby notified that any use, any form of reproduction,=20 dissemination, copying, disclosure, modification, distribution and/or=20 publication of this e-mail message or its attachments other than by=20 its intended recipient is strictly prohibited by the sender=2E =20 If you have received it in error, please notify us immediately by=20 telephone on the number above and destroy the message and all copies=20 in your possession=2E ********************************************************************** --TFS-with-MIME-and-DIME Content-Type: text/rtf; name="MSGCC.RTF" Content-transfer-encoding: base64 e1xydGYxXGFuc2kgXGRlZmYwXGRlZmxhbmcxMDI0e1xmb250dGJse1xmMFxm cm9tYW4gVG1zIFJtbjt9e1xmMVxmcm9tYW4gU3ltYm9sO317XGYyXGZzd2lz cyBIZWx2O319DQp7XGNvbG9ydGJsO1xyZWQwXGdyZWVuMFxibHVlMTI3O1xy ZWQwXGdyZWVuMTI3XGJsdWUwO1xyZWQwXGdyZWVuMTI3XGJsdWUxMjc7XHJl ZDEyN1xncmVlbjBcYmx1ZTA7DQpccmVkMTI3XGdyZWVuMFxibHVlMTI3O1xy ZWQxMjdcZ3JlZW4xMjdcYmx1ZTA7XHJlZDEyN1xncmVlbjEyN1xibHVlMTI3 OztccmVkMFxncmVlbjBcYmx1ZTI1NTsNClxyZWQwXGdyZWVuMjU1XGJsdWUw O1xyZWQwXGdyZWVuMjU1XGJsdWUyNTU7XHJlZDI1NVxncmVlbjBcYmx1ZTA7 XHJlZDI1NVxncmVlbjBcYmx1ZTI1NTsNClxyZWQyNTVcZ3JlZW4yNTVcYmx1 ZTA7XHJlZDI1NVxncmVlbjI1NVxibHVlMjU1O31ccGFwZXJ3MTIyNDBccGFw ZXJoMTU4NDBcbWFyZ2wxODAwXG1hcmdyMTgwMFxtYXJndDE0NDBcbWFyZ2Ix NDQwDQpcZ3V0dGVyMCBcZGVmZm9ybWF0XHNlY3RkIFxwYXJkXHBsYWluIHtc cGxhaW4gXGYwIFxjYjcgXGNmMCBcY2IxIFxjZjE0ICAgICAgXGNiMSBcY2Yx NCBIaSxcClxjYjEgXGNmMTQgICAgICBcClxjYjEgXGNmMTQgICAgICBcY2Ix IFxjZjE0IFdlJ3JlIGN1cnJlbnRseSBpbiB0aGUgbWlkZGxlIG9mIGEgcG9y dGluZyBleGVyY2lzZSBmcm9tIFN5YmFzZSB0byBcClxjYjEgXGNmMTQgICAg ICBcY2IxIFxjZjE0IEluZm9ybWl4LCBhbmQgaGF2ZSBhIGxhcmdlIG51bWJl ciAoMzUwMCspIG9mIHN0b3JlZCBwcm9jZWR1cmVzIHRoYXQgXApcY2IxIFxj ZjE0ICAgICAgXGNiMSBcY2YxNCBuZWVkIGNvbnZlcnRpbmcuICBJbmZvcm1p eCBkb2Vzbid0IGFwcGVhciB0byBkbyBtdWNoIGNoZWNraW5nIHdoZW4geW91 IFwKXGNiMSBcY2YxNCAgICAgIFxjYjEgXGNmMTQgbG9hZCBhIHByb2NlZHVy ZSwgZS5nLiBTeWJhc2UgdXNlcyB0aGUgZnVuY3Rpb24gcG93ZXIoKSwgd2hl cmVhcyBcClxjYjEgXGNmMTQgICAgICBcY2IxIFxjZjE0IEluZm9ybWl4IGhh cyBwb3coKS4gIEluY29ycmVjdCBTUCdzIGxvYWQgd2l0aCB0aGVzZSBmdW5j dGlvbnMsIGJ1dCBcClxjYjEgXGNmMTQgICAgICBcY2IxIFxjZjE0IGVycm9y IGF0IHJ1bnRpbWUuICBJcyB0aGVyZSBzb21lIGNoZWNraW5nIHdlIGNhbiBk byB3aGVuIGxvYWRpbmcgdGhlc2UgXApcY2IxIFxjZjE0ICAgICAgXGNiMSBc Y2YxNCBTUCdzIHNvIHRoYXQgdGhleSBlcnJvciBvbiBsb2FkaW5nIHJhdGhl ciB0aGFuIGV4ZWN1dGlvbj9cClxjYjEgXGNmMTQgICAgICBcClxjYjEgXGNm MTQgICAgICBcY2IxIFxjZjE0IFRhXApcY2IxIFxjZjE0ICAgICAgXGNiMSBc Y2YxNCBEYXZpblwKXHBhciB9fWQ= --TFS-with-MIME-and-DIME--