Dynamic SQL

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.