Select

An analytics SQL Select statement with 1 placeholder (ie 1 parameter)

select d_week_seq1
       ,round(sun_sales1/sun_sales2,2)
       ,round(mon_sales1/mon_sales2,2)
where
  d_year = ?
group by
  d_week_seq1

Insert

An DML insert statement with 2 placeholders (ie 2 parameters)

INSERT INTO products (name, price) VALUES (?, ?);

Stored Procedure

An stored procedure statement with 2 placeholders (ie 2 parameters)

Example

• with the Postgres call

? = call upper(?)

• for all database systems with jdbc escaping

{ ? = call upper(?) }

Attribute

You can add to a SQL request, the parameters attributes

Example of SQL Request manifest

kind: sql-request
spec:
  data-uri: (script.sql@cd)@database
  data-def:
    parameters:
        # the value (default: null)
      - value: value1
        # The direction: IN (default), OUT, INOUT
        direction: IN
        # the data type (mandatory when the value is null)
        type: varchar
        # the column name if the direction is OUT, INOUT (default: para_N)
        name: para_1
      - ...

where:

• value is the value of a parameter. If omitted, the value is null.
• type is the data type of the value.
  • Mandatory if the value is not set
  • Derived from the Yaml data type of the value if not set
• direction is the direction of the parameter. Default to IN
• name is the column name used in the result data resource when a direction is OUT or INOUT

Direction

The direction of a parameter defines if a value should be:

• passed to the statement
• returned after execution

If one of the parameters has a OUT or INOUT direction, they are returned in a data resource.

Placeholder

The placeholder parameter syntax differs depending on your database.