Purpose
Builds a delimited list of values. You can use the LIST statement when you construct SQL queries with multiple items like those found in some WHERE or HAVING clauses.
Syntax
.--------------------------. V | >>-%LIST--"-----+--------------------+--+---"----variable name-->< +-string-------------+ +-variable reference-+ '-function call------'
Values
Context
The LIST statement can be found in these contexts:
Restrictions
The LIST statement can contain these elements:
Examples
Example 1: A list of variables
%DEFINE{ DATABASE="custcity" %LIST " OR " conditions conditions="cond1='Sao Paolo'" conditions="cond2='Seattle'" conditions="cond3='Shanghai'" whereClause=conditions ? "WHERE $(conditions)" : "" %}
For more information on using LIST statements with variables, see List Variables.