RE: Select mytable name from mytable?

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> for the insert you *should* be able to do something along the lines of
> mystatement = 'INSERT INTO MYLIB/MYFILE (SELECT A.*, ''' + MYFILENAME +
> ''' FROM ' + %TRIM(MYNEWLIB) + '/' %TRIM(MYNEWFILE) + ' A UNION ALL
> SELECT
> B.*, ''' +
>     MYOTHERFILENAME + ''' FROM ' + %TRIM(MYOTHERLIB) + '/' +
> %TRIM(MYOTHERFILE) + ' B )';
>
> exec sql execute immediate :mystatement;

Yes.  So I create myfile.  Then I do this insert, a million times.  Then I
rename the file to mynewname.  Then I select mytable from mynewname.  Why
does the output show "myfile" when the file is clearly named "mynewname?"
What am I doing wrong?

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"If you become a star, you don't change, everyone else does."
        -- Kirk Douglas