truncate table ASSET_TRANSFER_INTERFACE copy to mmscde/paic1234@hdfmsprd insert ASSET_TRANSFER_INTERFACE using select * From ASSET_TRANSFER_INTERFACE copy to mmscde/paic1234@hdfmsprd insert mms2_actions using select * From mms2_actions cop
truncate table ASSET_TRANSFER_INTERFACE
copy to mmscde/paic1234@hdfmsprd insert ASSET_TRANSFER_INTERFACE using select * From ASSET_TRANSFER_INTERFACE
copy to mmscde/paic1234@hdfmsprd insert mms2_actions using select * From mms2_actions
copy to mmscde/paic1234@hdfmsprd insert mms2_actions_eoa using select * From mms2_actions_eoa
copy to mmsdata/paic1234@hdfmsprd create mms_material_info_bak using select m.* From mms_material_info m, mms2_actions a where a.material_id = m.material_id
insert into mms_material_info
select b.*, '', '', ''
from mms_material_info_bak b
where not exists (select 1 from mms_material_info m where m.material_id = b.material_id)
COPY {FROM database | TO database | FROM database TO database} {APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, ...)]
USING query
