Home

	Expand Search

WarehouseArchitect - User's Guide

Part 3 WarehouseArchitect Model

Chapter 21: Triggers and Procedures

Chapter 21
Triggers and Procedures

About this chapterThis chapter presents triggers and procedures used to generate database constraints.

What is a trigger?

Using trigger templates

Identifying trigger template types

Creating a trigger template

Modifying a trigger template

Trigger naming conventions

Changing trigger naming conventions

Calling a related procedure in a trigger template

Editing a trigger template

Using template items

Identifying template items

Creating a template item

Modifying a template item

Editing a template item

Using triggers

Creating a trigger

Trigger properties

Indicating trigger order

Modifying a trigger

Previewing a trigger

Editing a trigger

Defining stored procedures and functions

Defining templates for stored procedures and functions

Creating stored procedures and functions

Editing a stored procedure or a function

Using variables in triggers

List of variables in triggers

Formatting variables

Using macros

AKCOLN

ALLCOL

DEFINE

DEFINEIF

ERROR

FKCOLN

FOREACH_CHILD

FOREACH_COLUMN

FOREACH_PARENT

INCOLN

JOIN

NMFCOL

PKCOLN

Generating triggers and procedures

Trigger generation parameters

Script options and referential integrity options for triggers

Generating a trigger creation script

Creating triggers directly in a database

Creating and generating user-defined error messages