The following example outlines how a stored procedure shows a bulk copy transfer statement to be received as an RPC.
create procedure replauth as
begin
execute servername. . .transfer
“to ‘servername2 userid password’;”, “with replace into authors;”, “select * from authors;”
end
where:
servername specifies the access service to handle the transfer. In addition:
The double quotes (“...”) following the servername are required.
The access service library recognizes anything other than “transfer” in the next position as the name of an ODBC stored procedure.
servername2 specifies the secondary database for the transfer command.
