Re: Dynamic SQL

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

You don't use host variables in dynamic SQL prepared statements. You use 
parameter markers.

Fleming, Greg (ED) wrote:
> I'm trying to prepare a dynamic SQL statement, and the "prepare"
> statement is giving me an error "host variable not defined or not
> usable".
>
> Here's the statement:
>
> <snip>
>
> w_SQLString = 'Select Count(*) into :w_Count From MKCUSW';
>
> Exec SQL Prepare w_SQLStmnt from :w_SQLString;   
>
> Exec SQL Execute w_SQLStmnt;                  
>
> </snip>
>
> Ultimately, I'm planning to substitute a variable for the file name in
> when I populate my string,  but since it wasn't working I simplified it
> to this version, and it still doesn't work.
>
> I know my :w_count variable is defined OK, because if I make it static
> SQL, this statement works:
>
> <snip>
>
> Exec SQL Select Count(*) into :w_Count from MKCUSW;
>
> </snip>
>
> Can I not use host variables in dynamic SQL ? 
>
>  
>
> Thanks
>
>  
>
> Greg Fleming
>
> Senior Programmer/Analyst
>
> Everglades Direct, Inc.
>
>  
>
>