What would be pros and cons for using stored procedures and triggers in Informix 11.5?
Pinned topic stored procs and triggers in Informix 11.5
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-02-22T09:55:10Z at 2012-02-22T09:55:10Z by andreasl
andreasl 100000CHVU398 Posts
Re: stored procs and triggers in Informix 11.52012-02-22T09:55:10ZThis is the accepted answer. This is the accepted answer.Pros:
You can implement lots of business logic within your database, define actions on your data (SPs) and conditions when to execute such actions (triggers), potentially saving you a lot of data movement and application logic. Stored procedures/functions can be defined in SPL (stored procedure language), C or Java, so lots of power at your disposal.
Depends on what you consider a con - I'd say none.
What's your real question?