Host Variable (HostVar) Functions
There are three HostVar functions available:
These functions are described below.
name: name of the host variable used in the SELECT or WHERE clauses of a data source.
value: a literal value that is substituted for this host variable.
Followed by an ExecuteSQLStatement action that performs this query:
INSERT INTO PERSON(person_id,name) VALUES (:ID, :NAME)
Furthermore, if the placeholders are used in Output Expressions or the Where Clause definition of a data source, then for each query made on this data source, appropriate setHostVar() function calls must be included.
If the same host variable and value is required in multiple actions or events, use the setGenericHostVar() function instead. The host variables and its values are valid and included in every PageEngine call until removed with the removeGenericHostVars() function, or until you navigate to another page.