Transfer RPC

The client application can create a stored procedure within Adaptive Server that invokes the access service library transfer function.

The access service library receives the transfer command as an RPC event with these arguments:

Name of the RPC – “transfer”
Argument 1 – The secondary connection information ({to | from} “server userid pw”)
Argument 2 – Either the bulk copy target command or the destination-template sourceselectstatement.
Argument 3 – Either the bulk copy sourceselectstatement or the destination-template sourceselectstatement.

Example 1: 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 (“...”) after 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.