The following code copies all the values from one column of a table and inserts them into another table.

More than one column can be selectively chosen and copied.

INSERT ALL
INTO AGT_PROFILE(fagtcd) VALUES (agentid)
SELECT AGTNO agentid
FROM AGENT