Topic
  • 1 reply
  • Latest Post - ‏2012-02-22T09:55:10Z by andreasl
bylka
bylka
1 Post

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

    Re: stored procs and triggers in Informix 11.5

    ‏2012-02-22T09:55:10Z  
    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