What would be pros and cons for using stored procedures and triggers in Informix 11.5?
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-02-22T09:55:10Z by andreasl
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 100000CHVU369 PostsACCEPTED ANSWER
Re: stored procs and triggers in Informix 11.52012-02-22T09:55:10Z in response to bylkaPros:
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?