netezza passing variables
<p>hi am trying to pass values for my variable in sql using a run_nzodbc script,</p>

<p>run_nzodbc /development/df2/dfr/sql/adhoc/sriram/gen.sql -v <strong>condition =PROD.USC_CODE IN (12000,12001)</strong>>/development/df2/data01/sriram/df2_astrazeneca_seroquel_mthly_01160044DPT.log 2>/development/df2/data01/sriram/df2_astrazeneca_seroquel_mthly_01160044DPT.err &amp;</p>

<p>gen.sql</p>

<p>create table xxx
as</p>

<p>(
select * from abc as a
where 
a.string =:condition
);</p>

<p>instead of condition i have to replace a string which contains space in between which is passed as variable while running the query.
but when the value is passed it gets truncated after an instance of space occurs,
i have tried passing the value enclosed in single and double quotes.
please let me know is there a way to pass string values with space in between as a vriable</p>