A message
queue is a guaranteed message delivery mechanism for handling data
sharing in a user-defined format. Several widely used messaging technologies
are currently available. The format of the message content can be
completely user defined, or it can be a format that has been commonly
accepted for a particular industry segment. The message queues in
SAS Data Integration Studio support all of the following data transfer
types:
Support Data Transfer Types
|
|
|
|
|
Transmits text of a maximum length
of 32767 characters or a macro variable for transfer to the message
queue.
|
|
|
Transmits records from a table
(from a SAS data set, a DBMS table, or an XML table). In order to
successfully handle tables, the structure of the table must be included
on the receiving end so that input data values can be correctly formatted
to accurately reconstitute the data. A queue is mapped to the data
set or table. Each message that is sent to the queue corresponds to
a database record.
|
|
|
Transmits files, provided that
the receiver understands the file format.
|
Unlike
other SAS Data Integration Studio jobs, message queue jobs can handle
both structured data, such as tables, and unstructured data, such
as texts. However, you can create a memory overrun if you transmit
a very large table or file in a WebSphere message queue. For more
information, see the topic on "Very Large Tables or Files In WebSphere
Message Queues Can Cause Memory Overruns" in the "Usage Notes" topic
in SAS Data Integration Studio Help.
The Microsoft
Queue Writer transformation does not transform missing numeric values
to some other value. If missing values are encountered, then an error
occurs. For more information about this error and specific recommendations
for avoiding it, see the topic on "Microsoft Queue Writer Transformation
Does Not Transform Missing Numeric Values" in the "Usage Notes" topic
in SAS Data Integration Studio Help.