The following example shows a stored procedure that initiates a bulk copy transfer statement. The access service executes the transfer statement against Informix, which receives it as an RPC.
create procedure replauth as begin execute servername. . .transfer “to ‘servername2 userid password’;”, “with replace into authors;”, “select * from authors;” end
where:
replauth is the name of the stored procedure.
servername specifies the access service to handle the transfer. The three periods following 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.
The RPC can have any number of parameters, since the
RPC or parameters are concatenated and executed as a transfer command.
