RE: dynamic sql query and variable substituion

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> Where i can pass templib and tempfile from other program, all the
> tables
> will have these 2 columns
>
> dtemplib          s             10a   inz('QTEMP')
> dtempfile         s             10a   inz('myfile')
> d date1           s               d
> d time1           s               t
>
> MyStatement = 'select     (date(JOTSTP)),    (time(JOTSTP)) '
>   +  'into  :date1 , :time1 from '
>   + %TrimR(templib) + '/' + %TrimR(tempfile)
> + ' ORDER BY JOTSTP  desc fetch first 1 row only  ';
>
> Exec SQL
>   Execute Immediate :MyStatement;
>
> This is not working for me at all

Define "is not working for me."  I strongly suspect that you're getting an
error about returning too many rows, which would make perfect sense to me.

What are the values of SQLCOD and SQLSTATE when it "doesn't work for you?"

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"The income tax has made more liars out of American people than golf has."
        -- Will Rogers