Archives of the TeradataForum

Message Posted: Sun, 20 Jun 2004 @ 18:48:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

We have a situation with a trigger defined for each column in a table(s), functioning for purposes of writing audit trail rows to an audit trail table.

When tested as described below, different behaviour is seen:

- Teradata V2R5.0 Windows:

- each trigger fires separately on individual column updates (on a single row), and the audit trail table rows are written

- each trigger fires separately on multiple column updates (on a single row), and the audit trail table rows are written

- Teradata V2R5.1 MP-RAS UNIX:

- each trigger fires separately on individual column updates (on a single row), and the audit trail table rows are written

- a FAILURE (shown below) is found when multiple column updates (on a single row) are run - without the triggers there, such an update apparently completes

          *** Failure 3886 Duplicate name  '%1' in a USING clause.
                        Statement# 1, Info =815

A clue is that we previousy experienced the same error message when a time format value had to be written into character column; solved by using a CAST. This should not still be the error, since all columns (and their triggers) apparently work OK separately. Does anyome hve any ideas to help out. I can send the table and trigger definitions if necessary

Thanks

Simon

	<Prev	Next>		<<First	<Prev	Next>	Last>>