Variables for Join Indexes (IQ)

PowerDesigner can use variables in the generation and reverse-engineering of IQ join indexes.

Variable

Comment

%JIDX%

Generated code for join index

%JIDXDEFN%

Complete body of join index definition

%REFRLIST%

List of references (for live database connections)

%RFJNLIST%

List of reference joins (for live database connections)

%FACTQUALIFIER%

Qualifier for the fact table

%JIDXFACT%

Fact (base table)

%JIDXCOLN%

List of columns

%JIDXFROM%

From clause

%JIDXWHERE%

Where clause