DatabaseSelect - 6.3

Talend Data Mapper User Guide

EnrichVersion
6.3
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
Talend Studio

Name

DatabaseSelect

Purpose

Specifies the conditions on a database select.

Description

The DatabaseSelect function may be used only as an I/O expression. Specify it as the I/O expression of the element that contains the data to be read.

Database select is used to define the selection criteria on the rows that are to be processed. You can provide only the "where" portion of the selection criteria, or provider the full contents of the SQL Select statement.

In order to parametrize the select statement, you can access the map execution properties from within the Where String or Query String properties. Do this by specifying the name of the property as ${propertyName}. For example DepartmentCode = ${departmentCode}.

Return Type

N/A (this function may be used only as an I/O expression)

Property

Where String

Enter a SQL condition as specified in a Where clause without the use of the word "Where". Specify only this or the Query String but not both. See notes below about how to parametrize the query.

Property

Query String

Specify the entire HQL (HQL is similar to SQL) query string to be used for the select. This allows all of the parts of the select statement. Specify only this or the Where String but not both. See notes below about how to parametrize the query.