Q

Scope the trigger execution

Scope the trigger execution

Is it possible to have a trigger program that executes only on changes to specified fields in a file? If not, does IBM plan such support in DB2/400 in the future?
Yes, SQL triggers introduced in V5R1 allow you to scope the trigger execution to a specific field or set of fields. SQL Triggers can be defined over both SQL tables & physical files.

IBM currently does not have any plans to add this support for external triggers (i.e., ADDPFTRG command).

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this Search400.com Featured Topic: Database issues resolved


This was first published in October 2003

Dig deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchEnterpriseLinux

SearchDataCenter

Close