Validation and execution

The RunSQL macro runs the SQL command on the specified data source after successful validation and execution of the macro.

These are the conditions for macro execution:

  • If there are processes running that block the execution of the SQL command, the macro retries to execute until the Time out period is expired.
  • If the Time out period expires before the SQL command execution, the macro execution stops, and the reason for the failure is reported to the log.
Note: The RunSQL command only affects the data external to SCP. Therefore, the execution of the macro has no restriction.