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...

Hello,
What would be pros and cons for using stored procedures and triggers in Informix 11.5?
Thanks

Hi,
...

Thanks!
That's it :)

The error "The table properties do not support capture: it is a temporary table, a view, or otherwise not logged" is returned in the case
...

If I'm getting you right, the 'referencing' and the 'with trigger references' clauses, both in trigger and in procedure/function definition, are what you want.
...

I need to pass a table row to procedure from for each trigger.
Could I create an instance of row type based on a table that contains all data from current row and pass it as a parameter?
If yes then how?

Thanks a lot.

Thanks, I could alter the table utilizing cdc_set_fullrowlogging() function.

However After I update the table, Infoshpere CDC subscription does not update the target table when source is updated.

I get -83706 error The table properties do not support capture: it is a temporary table, a view,...

Basically the error -19816 is returned when you try to alter a table which is participating in ER (i.e. has a replicate defined on it) or is being captured by CDC.
So basically before the alter you need to stop the capturing application. If it's written according to the IBM...

Hi all,

I am using informix clientsdk.3.70.UC4DE , c++ api to connect to REMOTE database. I am puzzled about passing parameters to ITDBInfo constructor.

According to documentation signature is

ITDBInfo(const ITString &db, const ITString &user = ITString(), const ITString &system = ITString(),
const ITString &passwd =...