Adaptive Server 15.7 introduces a merge command, which allows you to transfer rows from a source table into a target table
See the Reference Manual: Commands.