IBM Support

Restrictions on Triggers with TRGEVENT(*READ)

Troubleshooting


Problem

Read triggers have certain restrictions which do not apply to other triggers. This document describes the differences.

Resolving The Problem

Read triggers have certain restrictions which do not apply to other triggers. This document describes the differences.

1. Read triggers can only be created as external triggers.

2. TRGTIME(*BEFORE) not allowed with TRGEVENT(*READ). Attempting to do so results in message CPD730A.

This last restriction means that the read trigger cannot be used to update a record being read before it is returned to the program doing the read.

Read triggers always get shared read locks. This can cause problems for applications getting update locks.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"}]

Historical Number

446745579

Document Information

Modified date:
18 December 2019

UID

nas8N1014441