CODEWITHSUNDEEP
stored-proceduresinformix
Sean Mshan
Sean Mshan

Reputation: 57

Informix stored procedure

When creating a stored procedure in Informix, it does not throw an error even if the related table does not exist..

I guess the reporting level is pretty high so how can I change it?

Upvotes: 1

Views: 1009

Answers (1)

Jonathan Leffler
Jonathan Leffler

Reputation: 755064

That is the way Informix is designed to work.

If, when you run the procedure, the table still does not exist, then you will get a more or less appropriate runtime error. But the mere fact that a table does not exist at the time the procedure is created is quite deliberately not viewed as an error; the table may be created by the time the procedure is used.

There is no setting that I know of to change this behaviour.

Upvotes: 1

Related Questions