I can think of two possibilites:
1) The user details provided don't have access to those schemas.
2) The code which is being generated is not correct, maybe spaces or something like that.
Now 1 can be checked easily byt doing a simple proc sql select * from connection to oracle ... just select from something you hard code in for a run.
Number 2 however is not something we could chek from what is provided. You need to look at what code is generated from this macro, take some of the log where macro is de-referenced. Then run look at this and see if it is correct and points to an existing area.
Using macro variables you can find things like spaces creep in, for example:
(&BAName,&snaplb l,&dsbln)
If BAName has a trailing blank and snaplbl is abc, then you might see:
DEF abc
which may not be valid if you want:
DEFabc
... View more
