Specifying parameter values

A parameter value must be one of the following:

A literal value, for example 'abc' or 123

The NULL literal value

A parameter reference

An expression consisting of literal values, parameter references, and Actuate SQL functions and operators

A parameter value cannot include column references, subqueries, or aggregate functions.

Examples

MyInformationObject uses the parameters p1, p2, and p3. The following query passes the parameter values :p1, -100, and 'abc' to MyInformationObject. :p1 represents the value of parameter p1 provided by the user. -100 and 'abc' are literal values:

WITH ( p1 INTEGER, p2 INTEGER, p3 VARCHAR )

SELECT …

FROM "MyInformationObject.iob" [:p1, -100, 'abc']

MyInformationObject uses the parameter p1. The following query passes the NULL literal value to MyInformationObject:

WITH ( p1 INTEGER )

SELECT …

FROM "MyInformationObject.iob" [NULL]

MyInformationObject uses the parameter p1. The following query passes the NULL literal value, cast as integer data type, to MyInformationObject:

WITH ( p1 INTEGER )

SELECT …

FROM "MyInformationObject.iob" [CAST(NULL AS INTEGER)]

MyInformationObject uses the parameter p1. The following query passes the expression :p1 + 10 to MyInformationObject:

WITH ( p1 INTEGER )

SELECT …

FROM "MyInformationObject.iob" [:p1 + 10]

MyInformationObject uses the parameters p1 and p2. The following query passes the parameter reference :p1 and the expression :p1 || :p2 to MyInformationObject:

WITH ( p1 VARCHAR, p2 VARCHAR )

SELECT …

FROM "MyInformationObject.iob" [:p1, :p1 || :p2]

MyInformationObject uses the parameters p1 and p2. The following query passes two expressions to MyInformationObject:

WITH ( p1 INTEGER, p2 INTEGER )

SELECT …

FROM "MyInformationObject.iob" [:p1 + 10, CASE WHEN :p2 > 100 THEN 100 ELSE 0 END]

Copyright Actuate Corporation 2012