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.
- 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.
- 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:
-
-
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.
Copyright © SAS Institute Inc. All rights reserved.