Topic
IC4NOTICE: 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.
1 reply Latest Post - ‏2012-02-22T09:55:10Z by andreasl
bylka
bylka
1 Post
ACCEPTED ANSWER

Pinned topic stored procs and triggers in Informix 11.5

‏2012-02-21T20:02:16Z |
Hello,
What would be pros and cons for using stored procedures and triggers in Informix 11.5?
Thanks
Updated on 2012-02-22T09:55:10Z at 2012-02-22T09:55:10Z by andreasl
  • andreasl
    andreasl
    369 Posts
    ACCEPTED ANSWER

    Re: stored procs and triggers in Informix 11.5

    ‏2012-02-22T09:55:10Z  in response to bylka
    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.

    Cons:
    Depends on what you consider a con - I'd say none.

    What's your real question?

    Andreas