databaseLookupAndUpdate
Looks up and updates a value in a database.
The databaseLookupAndUpdate function returns a single value of the specified column that satisfies the specified condition and updates the value 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 |
|---|---|
| databaseLookupAndUpdate("h2", "SELECT country FROM countries WHERE country = ?", "FR", "france") | France |