The DQSRVSVC Procedure

PROC DQSRVSVC Statement

PROC DQSRVSVC <option(s)>;

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 is transmitted in a single message. Transmitting large data sets in a single message can restrict resources on the DataFlux Integration Server. The server processes each message separately. Output is delivered as usual in a single message.

The DataFlux dfPower Architect service 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 Integration Server. If the HOST= option is not specified, localhost is used by default.

Default:

localhost

MACROS=macro-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 macro with a name that matches a name in the macro list, the name is assigned the corresponding macro value.

Both the macro name and macro value in each pair must appear within single quotation marks. An equal sign must separate the macro name and the macro value. A comma separates each name-value pair from the next name-value pair in the MACROS= option list.

See:	Macros= Option

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 dfPower Architect 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 Integration Server. The password can be plain text or SAS encoded.

Note:	If security has not been configured on the server, the PASSWORD= option is ignored.
See:	DataFlux Integration Server Passwords

PORT=port-number

identifies the port number through which the localhost communicates with the DataFlux Integration 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 Integration 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 BLOCKSIZE= option are ignored.

TIMEOUT

specifies a time in seconds after which the procedure terminates if the localhost has not received a response from the DataFlux Integration 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 data set.

Default:

TRIM is not set by default.

USERID

identifies the user according to the registry in the DataFlux Integration Server.

Note:

If security has not been configured on the server, the USERID= option is ignored.

Top of Page