34 Sybase to DB2 Conversion Guide
When a trigger is created, Sybase makes no permission checks on objects
that are referenced by the trigger, such as table or views. Therefore, triggers
can be successfully created even though the user does not have permissions
to access objects that are being referenced in them. When triggers are
created through IBM DB2 SSacSA, all permissions are verified at trigger
create time.
Any set option that is set within the trigger must be manually restored to its
previous value prior to return from the trigger with the exception of set
rowcount.
The queries involved in a trigger created through IBM DB2 SSacSA do not
support set rowcount unless the use of set rowcount appears within the
trigger body itself