Transfer Rows from Source to Target Table Using merge

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.