| What's New |
| Overview |
The SAS Data Quality Server provides procedures and functions that enable you to administer and run jobs and services on DataFlux Integration Servers from DataFlux (a SAS company). The following enhancements were made in SAS 9.2:
The SAS Data Quality Server has added support for grouping of clustering criteria, as well as a new CALL routine and new functions for parsing and version verification.
A new SAS system option, DQOPTIONS, has options to increase data transfer rates and to control whether to terminate SAS execution if errors are encountered.
New procedures, functions, and options have been added to support the DataFlux Integration Server.
The DataFlux Integration Server now supports all the language elements that access DataFlux Integration Servers in the z/OS operating environment.
| SAS Data Quality Server Enhancements |
The DQMATCH procedure was enhanced to enable grouping of the clustering criteria into a series of conditions.
Starting in SAS 9.2 Phase 2, the DQPARSE function is complemented by the DQPARSE CALL routine. The new CALL routine returns a flag that indicates the status of the parse operation (success or failure).
In the third maintenance release for SAS 9.2, the SAS Data Quality Server was enhanced with several new functions:
The DQOPTSURFACE function reveals or hides non-surfaced definitions.
The DQPARSEINPUTLEN function specifies the input length for parsing functions.
The DQPARSERESLIMIT function specifies the resource limit a parsing operation is allowed to consume.
The DQPARSESCORDEPTH function specifies how deeply to search for the best parsing score.
The DQVERQKB function returns the version of the currently loaded Quality Knowledge Base.
The DQVERBF function returns the version of Blue Fusion.
| SAS System Option |
In SAS 9.2 Phase 2, the SAS system option DQOPTIONS was added. DQOPTIONS is available for use in the SAS start-up command and in the SAS configuration file. The value of the option is a series of option-value pairs.
DQSRVPROTOCOL=WIRELINE increases data transfer performance to and from services.
TRANSCODE=IGNORE|WARN tells SAS whether to terminate execution if errors are encountered during the translation of languages and character sets.
| Support for the DataFlux Integration Server |
The following procedures and functions support DataFlux Integration Servers:
PROC DQSRVADM creates job status data sets after querying DataFlux Integration Servers.
PROC DQSRVSVC runs real-time services on DataFlux Integration Servers. The services are created with DataFlux dfPower Architect software.
The DQSRVARCHJOB function runs jobs on DataFlux Integration Servers. The jobs are created with DataFlux dfPower Architect software.
The DQSRVCOPYLOG and DQSRVDELETELOG functions manage log entries on DataFlux Integration Servers.
The DQSRVJOBSTATUS function reads log entries from DataFlux Integration Servers.
The DQSRVKILLJOB function terminates jobs that are running on DataFlux Integration Servers.
The DQSRVPROFJOBFILE function runs profile jobs on individual files on DataFlux Integration Servers. The jobs are created with the DataFlux dfPower Profile software.
The DQSRVPROFJOBREP function runs profile jobs on repositories.
The DQSRVUSER function authenticates users on DataFlux Integration Servers.
MISSINGVARSOK enables the continuation of processing when an input data set is missing one or more variables.
TRIM removes blank spaces from the ends of input data sets that are processed by real-time services executed on DataFlux Integration Servers.
MACROS enable a series of name-value pairs to be passed to a service as macros.
NOPRINT suppresses writing the SERVICEINFO information to an output data set.
SERVICEINFO lists the input and output columns used by a given service.
| Support for the z/OS Operating Environment |
In SAS 9.2 Phase 2 all of the language elements that access DataFlux Integration Servers are enabled in the z/OS operating environment.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.