The client application can create a stored procedure within Adaptive Server that invokes the access server library transfer function.
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.
create procedure replauth as begin execute servername. . .transfer “to ‘servername2 userid password’;”, “with replace into authors;”, “select * from authors;” end
replauth is the stored procedure.
servername specifies the access service to handle the transfer. The three periods after 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.