DBI_CALL -- directly call a subquery.

%DBI_CALL{...}% directly calls a subquery and pass over optional named parameters simulating %DBI_SUBQUERY% call.

Parameters

Parameter	Description	Default	Required
"subquery"	Subquery to call.	none	required

Optional parameters are transfered to the subquery as if they are columns of a database record. Consider the following example:

%DBI_CALL{"example" uid="12"}%

%DBI_QUERY{"db_identifier" subquery="example"}%
SELECT
    name
  FROM
    Users
  WHERE
    id = %uid%
.header
....
%DBI_QUERY%

Read more in Variable Expansion section.

Related

• DBI_CODE -- storing a script for %DBI_DO%
• DBI_DO -- do complex processing with Perl code.
• DBI_QUERY -- make simple requests to a database.