Chapter 3 DBMS Reference Guide
Parent Table variables are also available.
| Variable name | Comment |
|---|---|
| ORDER | Order number of Trigger (in case DBMS support more than one trigger of one type) |
| TRIGGER | Generated code of trigger |
| TRGTYPE | Trigger type. It contains Keywords "beforeinsert", "afterupdate", ...etc. |
| TRGEVENT | Trigger event. It contains Keywords "insert", "update", "delete" |
| TRGTIME | Trigger time. It contains Keywords NULL, "before", "after" |
| REFNO | Reference order number in List of references of Table |
| ERRNO | Error number for standard error |
| ERRMSG | Error message for standard error |
| MSGTAB | Name of Table containing user-defined error messages |
| MSGNO | Name of Column containing Error numbers in User-defined error table |
| MSGTXT | Name of Column containing Error messages in User-defined error table |
| SCRIPT | SQL script of trigger or procedure. |
| TRGBODY | Trigger body (only for Oracle ODBC reverse engineering) |
| TRGDESC | Trigger description (only for Oracle ODBC reverse engineering) |
| TRGDEFN | Trigger definition |
| Copyright (C) 2006. Sybase Inc. All rights reserved. |
| |