You may want to reconsider this code snippet:
create table khalke.test_xxx_d209file_T&count as
select *
from lob.test_xxx_d209file&count
That is creating the same file count times (and may cause some timing issues)
I suspect that you meant
create table khalke.test_xxx_d209file_T&i as
select *
from lob.test_xxx_d209file&i
to use the i counter to change table names.
Run your code with OPTIONS MPRINT;
before calling the macro. The log will likely provide better information as to where the problem is occuring.
... View more