Yes, you can just replace update with insert.
I forgot to show you something else which makes exec very handy - it is already designed to handle parameter markers.
– Insert statement sending SQL directly through to CONNX SQL Engine and using parameter markers
exec (‘insert into employees (personnel_id, first_name, name) values (?,?,?)’, ‘123456’, ‘JOEY’, ‘VENTURA’) at adawin
– Exec with select and parameter markers
exec (‘select * from employees where personnel_id = ?’, ‘123456’) at adawin
– openquery with select
select * from openquery(adawin, ‘select * from employees where personnel_id = ‘‘123456’’’)
Thanks
lm