PKCOLN

Chapter 15 Writing SQL Statements in PowerDesigner

Repeats a statement for each primary key column in a table

.PKCOLN("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 TITLEAUTHOR, the following macro:

message .PKCOLN("'%COLUMN% is a primary key column'","",",",";")

generates the following trigger script:

message 'AU_ID is a primary key column',
        'TITLE_ISBN is a primary key column';

Column variable only
For columns, the macro PKCOLN only accepts the variable %COLUMN%.