databaseLookup
Looks up a value in a database.
The databaseLookup function returns a single value of the specified column that satisfies the specified condition according to the SQL statement.
Arguments
- Name of the Talend Data Mapper database connection.
- A SELECT SQL statement that could be parameterized.
- If you use a parameterized SELECT SQL statement, enter additional expressions that correspond to the parameterized ? character.
Examples
| Expression | Result |
|---|---|
| databaseLookup("h2","SELECT country FROM countries WHERE country_code = ?", "FR") | France |