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

Syntax

PROC DMSRVDATASVC

<DATA=input-data-set>
<BLOCKSIZE=rows-per-message>
<HOST=host-name>
<PARMLIST=parameter-list>
<MISSINGVARSOK>
<NOPRINT>
<OUT=output-data-set>
<PASSWORD=password-on-server>
<PORT=port-number>
<SERVICE=service-name>
<SERVICEINFO>
<TIMEOUT=message-processing-limit>
<TRIM>
<USERID=user-name-on-server>;

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 host of the DataFlux Data Management Server. The host name can be a variable or a literal string. The literal string or the value of the variable is the URL of the server in single quotation marks.

When DataFlux Data Management Server is secured with SSL, the URL must use https instead of http (for example, https://myhost.unx.com).

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.