Working with Data Models › Macro Toolbox › Entity Macros › %ParamDecl()

%ParamDecl()

Lists all attributes of the table followed by their datatypes.

Syntax

%ParamDecl(<old prefix>,<new prefix>)

Syntax Example

%ParamDecl(,new)

Expansion

new_master_number INTEGER,

new_movie_copy_number INTEGER,

new_general_condition VARCHAR(10)

Full Syntax

%ParamDecl(<old prefix>,<new prefix>,<separator>, <attribute/type separator>)

Full Syntax Example

%ParamDecl(,new,", ",IN)

Expansion

new_master_number IN INTEGER,

new_movie_copy_number IN INTEGER,

new_general_condition IN VARCHAR(10)

Usage

Classified as an Entity macro that you can use for Trigger Override or Stored Procedures in the Table Trigger Editor (Triggers dialog).