sqadm exec-sql(1)

sqadm exec-sql - Execute SQL scripts

sqadm exec-sql [-1v] [--jdbc-url url] [--jdbc-user user] [--explain] [file…​]

This command executes SQL scripts.

The sqadm exec-sql command shall be executed on a running database.

-1, --single-transaction

Execute all scripts in a single transaction. In auto-commit mode (the default), all SQL statements will be executed and committed as individual transactions.

--explain

Display the execution plan generated by the database planner for SQL statements like SELECT or UPDATE.

This option is primarily used for debugging purpose.

--jdbc-url url

Use alternate database connection, with URL of the form jdbc:subprotocol:subname.

--jdbc-user user

Use alternate database username.

-v, --verbose

Display for each statement the number of selected or modified rows for relevant SQL statements and the execution time in milliseconds, which includes both planning and execution times.

file

SQL scripts to execute.