Chapter 15 Writing SQL Statements in PowerDesigner


DEFINE

Description

Defines a variable and initializes its value.

Syntax

.DEFINE "variable" "value"

Argument Description
variable Variable name (without % signs)
value Variable value (may include another variable surrounded by % signs)

Example

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.