RE: can I have a sql that (lists)compares *USRPRF objects between 2 systems?

IBM really despises cross system joins and anything cross system like that. All ideas to remedy that are rejected.

You have to do this in 2 steps:
create table qtemp.remote_bs as (
select * from gdihq.qsys2.user_info)
with data;

select s.authorization_name, s.previous_signon, g.authorization_name, g.previous_signon
from qsys2.user_info s
full outer join remote_bs g
on s.authorization_name = g.authorization_name;

Rob Berendt