Re: Dynamic SQL

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

Yes, you do not use a select into... you use a select, and you need to 
use the SQLDA for the description of the variable and the extraction of 
the returned value.

Fleming, Greg (ED) wrote:
> To partially answer my own question, that can't possibly make any sense.
>
>  
> It is trying to substitute the value of :w_Count in the prepare
> statement, which isn't what I want. W_Count is the output variable I
> want to receive the count in.  I'm beginning to conclude that it is in
> fact not possible to use dyanamic SQL with a "select into" statement. 
>
> Please correct me if that is not true.  
>
> Since there are only four possible values for my file name, I have
> resorted to a select:
>
> Select:
>          When p_File = 'MKCUSW';
>            Exec SQL Select count(*) into :w_Count From MKCUSW;
>          When p_File = 'MKPRODW';
>            Exec SQL Select count(*) into :w_Count From MKPRODW;
>          When p_File = 'MKOHLW';
>            Exec SQL Select count(*) into :w_Count From MKOHLW;
>          When p_File = 'MKPROMOW';
>            Exec SQL Select count(*) into :w_Count From MKPROMOW;
> EndSL;      
>
> If there's a niftier way to do this, do tell. 
>
> Thanks
>
> Greg
> |
> |<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" ?
> |
>
>