Chapter 15 Writing SQL Statements in PowerDesigner

FKCOLN

Description

Repeats a statement for each foreign key column in a table

Syntax

.FKCOLN("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

Example

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

message .FKCOLN("'%COLUMN% is a foreign key column'","",",",";")

generates the following trigger script:

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

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

 

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