---
url: /process-functions/datasource-update.md
description: Runs an INSERT, UPDATE, DELETE or CREATE statement against a datasource.
---

# datasource.update 

Runs an INSERT, UPDATE, DELETE or CREATE statement against a datasource.

::: warning Deprecated
Use [`datasource.client(datasource).execute(statement, params)`](/process-functions/datasourceclient#execute) instead.
:::

```js
datasource.update(datasource, query, parameters)
```

## Parameters

| Parameter | Type | Description |
|---|---|---|
| `datasource` | `string` | The datasource's name. It must be a JDBC datasource. |
| `query` | `string` | The SQL statement. Use `?` placeholders for values. |
| `parameters` | `string[]` | Optional. Values for the `?` placeholders, in order. |

## Returns

`true` when the statement ran, otherwise `false`.

## Examples

```js
const success = datasource.update("Internal Datastore", "DELETE FROM department_codes WHERE department_id = ?;", ["001"]);
```