SAS(R) Data Quality Server 9.2: Reference

Product	Release
SAS Enterprise BI Server	4.2
SAS Data Quality Server	9.2
SAS Enterprise Data Integration Server
SAS BI Server
SAS Data Integration Studio	4.2
DataFlux dfPower Studio
DataFlux Enterprise Integration Server

The DQSRVSVC Procedure

DQSRVSVC Procedure Syntax

Restriction:

Cannot be used in the OpenVMS operating environment.

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

The DQSRVSVC procedure offers the following options:

SERVICE=service-name

identifies the service on the DataFlux Integration Server.

HOST=host-name

identifies the host of the Integration Server. If this option is not specified, the local host is used by default.

PORT=port-number

identifies the port through which the local host communicates with the Integration Server. If this option is not specified, or if the value is 0 or a negative number, the default port number is used. The default port number is 21036.

TIMEOUT=response-limit

specifies a time in seconds after which the procedure terminates if the local host has not received a response from the Integration Server. If data is delivered to the server in multiple messages using the BLOCKSIZE option, the TIMEOUT value is applied to each message. A value of zero or a negative number enables the procedure to run without a time limit.

DATA=input-data-set

identifies the location of the input data set. If this option is not specified, then the input data set name is assumed to be _LAST_.

OUT=output-data-set

identifies the storage location of the output data set. If this option is not specified, the default output data set name is _DATA_. dfPower Architect services always create new data sets or overwrite existing data sets.

BLOCKSIZE=rows-per-message

specifies the number of rows of source data that are transmitted to the DataFlux Integration Server in multiple messages. If this option is not specified, then the entire data set will be transmitted in a single message. Transmitting large data sets in a single message can restrict resources on the Integration Server. The server processes each message separately. The dfPower Architect service program needs to be written to accommodate multiple messages. Output is delivered as usual in a single message.

Note:

Services that require the entire data set, such as those that calculate averages or frequencies, cannot use the BLOCKSIZE option. [cautionend]

USERID=user-name-on-server

identifies the user according to the registry in the Integration Server. This option is required only if security has been configured on the Integration Server. If security has not been configured on the server, then this option is ignored.

PASSWORD=password-on-server

authenticates the user according to the registry in the Integration Server. This option is required only if security has been configured on the Integration Server. The password can be plain text or SAS-encoded, as described in Passwords for Integration Servers. If security has not been configured on the server, then the PASSWORD= option is ignored.

TRIM

removes any blank spaces from the end of the input data set. This option is not set by default.

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. This option is not set by default. When it is set, any data that is missing from the input data set is assumed to not be critical or required by the DataFlux real-time service.

Top of Page