Chapter 15 Writing SQL Statements in PowerDesigner


DEFINEIF

Description

Defines a variable and initializes its value if the test value is not null

Syntax

.DEFINEIF "test_value" "variable" "value"

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

Example

For example, to define a variable for a default data type:

%DEFAULT%
.DEFINEIF "%DEFAULT%" "_DEFLT"" "%DEFAULT%"
Add %COLUMN% %DATATYPE% %_DEFLT%

 


Copyright (C) 2005. Sybase Inc. All rights reserved.