IMXFER Procedure

PROC IMXFER Statement

Transfers an in-memory table.

Syntax
Optional Arguments

Syntax

PROC IMXFER <options>;

Optional Arguments

HOSTONLY

specifies to transfer the tables through the root nodes on the two clusters. With this option, the data are collected by the exporting root node before sending them to the importing root node. The importing root node then distributes the data to its worker nodes before passing the data to the importing server instance.

Specify this option if you know in advance that the worker nodes of the server instances do not have network communication with each other. (Even if you do not specify this option when this network topology exists, the procedure detects the lack of communication, and routes the data this way automatically.) Specify the option so that time is not lost trying to establish network connections between the clusters.
Alias NOWORKER

IMMEDIATE

specifies that the procedure executes one statement at a time rather than accumulating statements in RUN blocks.

Alias SINGLESTEP

LASRERROR

specifies that the procedure terminate when an error message is received from one of the servers.

If you do not specify this option, the IMXFER procedure attempts to continue interactive processing of programming statements. For example, if you receive an error that a table with the same name already exists in the importing server instance, you might prefer to change the name and continue rather than end the procedure.

NOPRINT

This option suppresses the generation of ODS tables and other printed output in the IMXFER procedure.

NOTIMINGMSG

When an action completes successfully, the IMXFER procedure generates a SAS log message that contains the execution time of the request. Specify this option to suppress the message.

Alias NOTIME

TIMEOUT=n

specifies the time in seconds that the worker nodes of the exporting server waits for network connections. When this interval of time has passed, the data transfer occurs through the root nodes only.

Alias CONNTIME=
Default 30 seconds
Copyright © SAS Institute Inc. All rights reserved.