Zoomed Image

AMSX Scripting Language - Command : executegeneratedsql

Summary

Execute SQL statements produced by the collected TEXT/ENDTEXT SQL query

Description

Runs the collected SQL and expects it to return rows where one column contains SQL statement text. Each row's SQL is concatenated and executed in order. If the collected SQL produces multiple result sets, each is processed separately. Use to implement data-driven SQL generation patterns.

Parameters

ParameterDescription
cmdColumn name in the result set that contains the SQL statement text to execute

Syntax


ExecuteGeneratedSql "Column name in the result set that contains the SQL statement text to execute"

Return to the AMSX Command Reference