Chapter 15 Writing SQL Statements in PowerDesigner
Defines a variable and initializes its value.
.DEFINE "variable" "value"
Argument | Description |
---|---|
variable | Variable name (without % signs) |
value | Variable value (may include another variable surrounded by % signs) |
In a trigger for the table AUTHOR, the following macro:
.DEFINE "TRIGGER" "T_%TABLE%" message 'Error: Trigger(%TRIGGER%) of table %TABLE%'
generates the following trigger script:
message 'Error: Trigger(T_AUTHOR) of table AUTHOR';
Copyright (C) 2005. Sybase Inc. All rights reserved. |
![]() |