In ASE 15.5:

. ASE 1 ASE2
TBL1 LOCAL <--------
1,000 Rows |
. |Join
. |
TBL2 PROXY TBL <----|<-------- TBL2 REMOTE
80,000,000 Rows

Delete TBL1
From TBL1, TBL2
WHERE TBL1.ID = TBL2.ID
and TBL2.VAL = 'XYZ'

I know select would do a relocated join, Will this DML
perfrom Relocated Join as well(given the option is set for
the remote server)?