Chapter 15 Writing SQL Statements in PowerDesigner

ALLCOL

Description

Repeats a statement for each column in a table

Syntax

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

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

generates the following trigger script:

AU_ID char(12),
AU_LNAME varchar(40),
AU_FNAME varchar(40),
AU_BIOGRAPH long varchar,
AU_ADVANCE numeric(8,2),
AU_ADDRESS varchar(80),
CITY varchar(20),
STATE char(2),
POSTALCODE char(5),
AU_PHONE char(12);

 

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