---
url: /process-functions/datasource-update.md
description: Note that this has been deprecated in favour of datasource.client
---

# datasource.update 

:::info
Note that this has been deprecated in favour of [datasource.client](/process-functions/datasource-client)
:::

Executes SQL against a datasource

This function is used to execute a SQL statement against a registered JDBC datasource.

```js
datasource.update(datastoreName, query);
```

#### Parameters

* `datastoreName` - The name of a registered datasource.
* `sql` - Either a INSERT, UPDATE, CREATE or DELETE SQL function.
* `arguments` - Optional, A list of parameterized values to insert in place of question marks in the sql statement.

#### Example

```js
let success = datasource.update(
    "Internal Datastore", 
    "INSERT INTO department_codes (department_id, department_name) VALUES (?, ?);",
    [
        '001', 
        'Head Office'
    ]
);
```

The function will return a boolean `true` or `false` depending on if the statement executed without issue.