×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
So as far as I can glean from the archives, it should look something
like this ?
<snip>
W_SQLString = 'select count(*) into ? From ' + %trim(w_FileName);
Exec SQL Prepare w_SQLStmnt from :w_SQLString;
Exec SQL Execute w_SQLStmnt using :w_Count;
</snip>
The string in debug reads "select count(*) into ? From MKCUSW".
But now the prepare statement throws a "token not valid".
Am I getting closer ? Will dynamic SQL even work with a "select into" ?
Thanks again...
Greg
|-----Original Message-----
|From: midrange-l-bounces@xxxxxxxxxxxx [
mailto:midrange-l-
|bounces@xxxxxxxxxxxx] On Behalf Of R Bruce Hoffman
|Sent: Monday, July 02, 2007 5:13 PM
|To: Midrange Systems Technical Discussion
|Subject: Re: Dynamic SQL
|
|You don't use host variables in dynamic SQL prepared statements. You
use
|parameter markers.
|
midrange.com
