databaseUpdateAndLookup
Updates and looks up a value in a database.
The databaseLookupAndUpdate function updates a single value of the specified column that satisfies the specified condition and returns the value according to the SQL statement.
Arguments
- Name of the Talend Data Mapper database connection.
- An UPDATE 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 |
---|---|
databaseUpdateAndLookup("h2", "UPDATE countries SET country = upperCase(country) WHERE country = ?", "FR") | FRANCE |