INCOLN

Chapter 15 Writing SQL Statements in PowerDesigner

Repeats a statement for each primary key column, foreign key column, alternate key column, or non-modifiable column in a table.

.INCOLN("statement","prefix","suffix","last_suffix")

Argument	Description
statement	Statement to repeat for each column
prefix	Prefix for each new line
suffix	Suffix for each new line
last suffix	Suffix for the last line

In a trigger for the table TITLE, the following macro:

.INCOLN("%COLUMN% %COLTYPE%","",",",";")

generates the following trigger script:

TITLE_ISBN char(12),
PUB_ID char(12);