Common Variables for Objects

%COMMENT%

Comment of Object or its name (if no comment defined)

%OWNER%

Generated code of User owning Object or its parent. You should not use this variable for queries on objects listed in live database reverse dialog boxes, because their owner is not defined yet

%DBPREFIX%

Database prefix of objects (name of Database + '.' if database defined)

%QUALIFIER%

Whole object qualifier (database prefix + owner prefix)

%OPTIONS%

SQL text defining physical options for Object

%OPTIONSEX%

The parsed SQL text defining physical options of the object

%CONSTNAME%

Constraint name of Object

%CONSTRAINT%

Constraint SQL body of Object. Ex: (A <= 0) AND (A >= 10)

%CONSTDEFN%

Column constraint definition. Ex: constraint C1 checks (A>=0) AND (A<=10)

%RULES%

Concatenation of Server expression of business rules associated with Object

%NAMEISCODE%

True if the object (table, column, index) name and code are identical (AS 400 specific)

%TABLQUALIFIER%

Parent table qualifier (database prefix + owner prefix)

%TABLOWNER%

The generated code of the user owning the parent table