Re: Passing variable to SQL script

[Anthony Willard]

I do not believe there is a way to pass in parameters to a SQL script.

I controlled this by how I created the SQL script itself. First, I created a master script that contained the SQL I wanted to execute with the variable parts clearly identified (like ##WHERE_CLAUSE##), then would run a sed script to manipulate the resultant script, making whatever substitutions were needed, to a temporary script, then executed that temporary script against the database.

It's not perfect, but it solved my problem.