Note 1773479 - SYB: Displaying multiple triggers per object

Summary

Symptom

The function module DB_GET_TRIGGERS returns multiple identical values.

Other terms

DDIC, Sybase Adaptive Server Enterprise, ASE

Reason and Prerequisites

This issue happens when a trigger is created on a database that is used for multiple events. For example one trigger for both insert and delete events.
The program logic implemented in the data dictinary for Sybase ASE contains an error causing this behaviour.

Solution

The correction of this issue is available with
SAP_BASIS 7.02 SPS12
SAP_BASIS 7.30 SPS08
SAP_BASIS 7.31 SPS05
For an early correction implement the correction instructions attached to this SAP Note using transaction SNOTE.

Header Data

Release Status:	Released for Customer
Released on:	09.10.2012  12:21:20
Master Language:	English
Priority:	Correction with medium priority
Category:	Program error
Primary Component:	BC-DB-SYB Sybase ASE Database Platform