Thank you very much for your help guys, I found that the login is valid on the new system but that you have to cache the login to the AS400...

Thanks for your reply Andy. I have started using the NOT EXISTS construction to achieve the result set I require and it will work. The problem is that...