Creating an ASE Instead of Trigger

Create an Adaptive Server instead of trigger to override the default action of a trigger statement (insert, update, or delete) and perform a user-defined action.

1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the tree for a database, expand the Schemas folder, and then expand the tree for the appropriate schema owner.
2. Expand the Views folder.
3. Right-click the view to which to add the trigger, and select New > Instead of Trigger .
4. Enter the Name.
5. Select Instead of Update, Instead of Insert, or Instead of Delete to indicate the condition under which the trigger invokes when the associated table is modified. Note that you cannot use Instead of Delete with an if update clause.
6. (Optional) Enter a description in the Comments field.
7. Click Next and specify save and execution properties.

   Field	Description
   Generate Script	Generate the script for the object.
   Enter or Select the Parent Folder	Specify an existing project or create a new project in which to save the SQL file.
   File Name	Enter the file name in which to store the SQL code.
   Execute Immediately	Execute the SQL code immediately. If you do not select this option, you must execute the SQL file later to create the object.
   Open in Editor After Creation	Create the object and open it in its associated editor.

8. Click Finish to create the trigger.

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.