Zoomed Image

AMSX Scripting Language - Command : sqlbatch

Summary

Execute a SQL statement on the batch processor's dedicated database connection

Description

Runs a SQL statement using the batch job connection (BatchJobConnection) rather than the main connection. Returns the first column of the first row as the result. Use this when the batch processor needs its own isolated connection to avoid interfering with the main transaction.

Parameters

ParameterDescription
cmdSQL statement to execute

Syntax


SqlBatch "SQL statement to execute"

Return to the AMSX Command Reference