DMSRVDATASVC Procedure

PROC DMSRVDATASVC Statement

The DMSRVDATASVC procedure runs a DataFlux Data Management Studio real-time service on a DataFlux Data Management Server.

Syntax

Actions

BLOCKSIZE= rows-per-message
specifies the number of rows of source data that are transmitted to the DataFlux Data Management Server, in multiple messages. If this option is not specified, then the entire data set is transmitted in a single message. Transmitting large data sets in a single message can restrict resources on the DataFlux Data Management Server. The server processes each message separately. Output is delivered as usual in a single message.
The DataFlux Data Management Studio program needs to be written to accommodate multiple messages.
Restriction:Services that require the entire data set, such as those that calculate averages or frequencies, cannot use the BLOCKSIZE= option.
DATA= data-set-name
identifies name of the input data set.
Default:If the DATA= option is not specified, the input data set _LAST_ is used.
HOST= host-machine
identifies the name of the machine hosting the DataFlux Data Management Server. If the HOST= option is not specified, localhost is used by default.
Default:localhost
PARMLIST= parameter-list
takes a quoted string as its value. The contents of the string is a series of name-value pairs. These pairs are passed to the service. If the service uses a parmlist with a name that matches a name in the parmlist list, the name is assigned the corresponding parmlist value.
Both the parmlist name and parmlist value in each pair must appear within single quotation marks. An equal sign must separate the parmlist name and the parmlist value. A comma separates each name-value pair from the next name-value pair in the PARMLIST= option list.
MISSINGVARSOK
indicates that the DataFlux real-time service is to be allowed to continue to run when one or more variables (or table columns) are missing from the input data set. When the MISSINGVARSOK option is set, any data that is missing from the input data set is assumed to be non-critical, or required by the DataFlux real-time service.
Default:MISSINGVARSOK is not set by default.
NOPRINT
if the SERVICEINFO option is specified, suppresses writing the SERVICEINFO information to the SAS log.
OUT= output-data-set
identifies the name of the output data set. DataFlux Data Management Studio services always create new data sets or overwrite existing data sets.
Default:If the OUT= option is not specified, the input data set _LAST_ is used.
PASSWORD= password
authenticates the user according to the registry in the DataFlux Data Management Server. The password can be plain text or encoded in SAS.
Note:If security has not been configured on the server, the PASSWORD= option is ignored.
PORT= port-number
identifies the port number through which the host communicates with the DataFlux Data Management Server. If this option is not specified, or if the value is zero or a negative number, the default port number 21036 is used.
Default:21036
SERVICE= service-name
identifies the service on the DataFlux Data Management Server.
SERVICEINFO
writes the input and output columns used by the given service to the data set specified by the OUT= option.
The data set has four columns:
  • Name is the column name.
  • Type is the type of data in column -character(C) or numeric(N).
  • Length is the length of column data.
  • Class is the input, output, or macro.
Default:The service information is also written to the SAS log.
Restriction:If SERVICEINFO is specified, the service is not run. Any options related to the execution of the service, such as the BLOCKSIZE= option, are ignored.
TIMEOUT= message-processing-limit
specifies a time in seconds after which the procedure terminates if the localhost has not received a response from the DataFlux Data Management Server. If data is delivered to the server in multiple messages using the BLOCKSIZE= option, the TIMEOUT= value is applied to each message.
Tip:A value of zero or a negative number enables the procedure to run without a time limit.
TRIM
removes any blank spaces from the end of the input values.
Default:TRIM is not set by default.
USERID=user-name
identifies the user according to the registry in the DataFlux Data Management Server.
Note:If security has not been configured on the server, the USERID= option is ignored.