When the remote server supports only DB2-ANSI

The query to the remote server will be sent in ANSI if all tables in the from clause participate in an ANSI join.

select * from T1 left join T2 on
T1.a = T2.a, T3
select * from T1 Left Join T2 on
T1.a = T2.a Left Join T3 on
T3.a = T2.a