Re: Escaping and quoting ?????

[NetWallah]

Your statement

@Output = qx { /nz/kit/bin/nzsql -d histdb  -c "$SQL1" };

causes the shell to re-interpolate the contents of $SQL, because you use double quotes.

You could either pass single quotes to the shell, or add another "\\" before each dollar sign in the contents of $SQL. I'd suggest:

@Output = qx { /nz/kit/bin/nzsql -d histdb  -c '$SQL1' };

[pgduke65]

Thanks for the clarification on the problem. I had forgotten to change the quotes from doubles to singles for the -c argument. It worked like a charm. Thank you all for the help. Perl Monks are awesome!