Viewing or Modifying View Trigger Properties

View or change trigger properties on a view, including the comment and the underlying SQL statement of the trigger.

Prerequisites

Database Version	View Trigger Privileges
SAP Sybase IQ 15.3 and 15.4	View trigger properties only – none. Modify trigger comment or properties – you must have one of: DBA authority RESOURCE authority and you own the underlying view of the trigger
SAP Sybase IQ 16.0	View any trigger property page – none. Modify a trigger comment – you must have one of: CREATE ANY TRIGGER system privilege ALTER ANY TRIGGER system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege COMMENT ANY OBJECT system privilege Note: ALTER permission on the view is not required to modify a comment. Modify any other trigger property – you must have one of: ALTER ANY OBJECT system privilege ALTER ANY TRIGGER system privilege, along with one of: ALTER ANY VIEW system privilege You own the underlying view of the trigger

Database Version

View Trigger Privileges

SAP Sybase IQ 15.3 and 15.4

View trigger properties only – none.

Modify trigger comment or properties – you must have one of:

SAP Sybase IQ 16.0

View any trigger property page – none.

Modify a trigger comment – you must have one of:

Note: ALTER permission on the view is not required to modify a comment.

Modify any other trigger property – you must have one of:

ALTER ANY OBJECT system privilege
ALTER ANY TRIGGER system privilege, along with one of:
- ALTER ANY VIEW system privilege
- You own the underlying view of the trigger

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Schema Objects > Views, and then select Views.
Select a view from the right pane on which to create the trigger and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > Properties.
The Views Properties view appears.
In the left pane, select Triggers.
In the right pane, select a trigger and click Edit.
The Trigger Properties view appears.

View or modify the properties.

Any modifications to the properties are saved when either Apply or OK is clicked
If you do not have privileges to modify properties, SAP Control Center displays the properties view in read–only mode.

Area	Description
General	Name – (Read–only) The name of the trigger. Dialect – (Read–only) Indicates the dialect of the trigger. Events – (Read–only) Indicates the event which causes the trigger to fire. Valid events are: Insert Delete Update Tining – (Read–only) Indicates when the trigger fires. Valid times are: Instead of the event Level – (Read–only) Defines whether the trigger fires at a row or statement level. Comment – An optional text comment on the trigger.
SQL	The SQL statement to be executed when the trigger fires.

Area

Description

General

Name – (Read–only) The name of the trigger.

Dialect – (Read–only) Indicates the dialect of the trigger.

Events – (Read–only) Indicates the event which causes the trigger to fire. Valid events are:

Tining – (Read–only) Indicates when the trigger fires. Valid times are:

Level – (Read–only) Defines whether the trigger fires at a row or statement level.

Comment – An optional text comment on the trigger.

SQL

The SQL statement to be executed when the trigger fires.

Click OK or Apply to close the Trigger properties view.

Note: Unlike other wizards launched from the properties view, changes to triggers take effect immediately. You do not need to click OK or Apply in the properties view to upload the change to the database.