# Example

If you want to create five tables (tab1, tab2, tab3, tab4, and tab5), you could create a transformation similar to this one:

![Execute SQL Script Example](/files/w5yWSd0kKcnn8ccfVwp8)

The SQL script to execute might look like this:

```sql
CREATE TABLE tab?
(
a INTEGER
);
```

The field name to specify as the parameter is then the "count" sequence defined in the second step.

**Note:** The execution of the transformation will halt when a statement in the script fails.

As an extra option, you can return the total number of inserts (`INSERT INTO` statements), updates (`UPDATE` table), deletes (`DELETE FROM` table) and reads (`SELECT` statements) by specifying the field names in the lower right of the dialog box.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pentaho.com/pdia-data-integration/10.2-data-integration/pdi-transformation-steps-reference-overview/execute-sql-script-cp/example.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.