Run SQL command

Previous Next

Logs on to "Application" in "Database account" and executes a SQL statement specified as "SQL command".

NOTE: This action has nothing to do with the SQL Command tool as it is available in the various USoft tools. That tool has a much wider applicability. The sole purpose of the "Run SQL command" Delivery Manager action is to execute a data manipulation statement as part of a Delivery Manager task.

If "Metadata" = 'Y', logs on to the USoft Definer, as opposed to the User Application.

Parameters

Name

Type

Optional?

Application

Application

No

Database account

Database account

No

SQL command

SQL command

No

Metadata Y/N

Option flag

No

 

 

collapseRules
collapseRunning from flat files or repository
collapseSource variables in the "SQL Command" parameter value