Version 11.70 - Where should look if I am having problems with triggers via a stored procedure?

Question

RH

Research and Development Manager

Version 11.70 - Where should look if I am having problems with triggers via a stored procedure?

Asked over 5 years ago

Add, update and delete triggers are added to insert a record into a specific table. The first thing the stored procedure checks if if the key is not found in the table then a records is is written to to a table. For some reason the record is not inserted. This could be a Stored Procedure issue but I feel it is trigger related.

Relational Databases Software

Comment

2 comments

2

Looks like you’re not logged in.

Users need to be logged in to answer questions

Log In

Alexey A. · Answer 1 · 2019-11-15T14:55:10-06:00

AA

Alexey A.

IT Manager

0

Answered over 5 years ago

can you post your SP and triggers code?

delete edit

Looks like you’re not logged in.

Users need to be logged in to write comments

Log In

Reply

Eric V. · Answer 2 · 2019-10-02T01:14:41-05:00

EV

Eric V.

Everything you want to know about digitally transforming your ERP and live happy

0

Answered over 5 years ago

Hi Rhonda, First of all you should clearly and at least look at upgrading to version 14.10 xC2, because 11.70 maintenance will stop by March 30th 2020. On the other hand, I would SET TRACE ON in the Stored procedure and check what the procedure does, jointly with setting sqltrace on on the engine and see what sql statements are executed exactly. At least start with that.

Version 11.70 - Where should look if I am having problems with triggers via a stored procedure?

About IBM Informix