Target datastores are generally thought of as being a database but they can just as easily be a queue providing input to another application. Because Connect CDC SQData is typically used to capture data that has changed in one environment for replication to another, it is often the best if not only way to identify events that can be used to trigger or feed other processes. Many customers with z/OS environments use IBM MQ for communication of events between both mainframe and distributed environments. While Connect CDC SQData originally published captured data using IBM MQ, that functionality has been deprecated in favor of our CDCStore/CDCzLog publishing framework. IBM MQ is supported as a Target datastore for APPLY Engines running on all platforms.
Example 1:
Define two (2) output IBM MQs, one that is to contain records described by COBOL copybook referenced by DDNAME OUTFORM and the other, to contain XML formatted data with the XML DTD definition referenced by DDNAME OUTXML.
-- Datastore Descriptions --
DESCRIPTION COBOL DD:INFORM AS INPUT_FORMAT;
DESCRIPTION COBOL DD:OUTFORM AS OUTPUT_FORMAT;
DESCRIPTION XMLDTD DD:OUTXML AS OUTPUT_XML_FORMAT;
-- Define the Output Datastores --
DATASTORE MQS://CSQ1/QUEUE_OUT
OF BINARY
AS OUT_QUEUE
DESCRIBED BY OUTPUT_FORMAT;
DATASTORE MQS://CSQ1/QUE_OUTXML
OF XML
AS OUT_XML_QUEUE
DESCRIBED BY OUTPUT_XML_FORMAT;
-- Read the input datastore and write the data to the two (2) output datastores
PROCESS INTO OUT_QUEUE, OUT_QUEUE_XML
SELECT *
FROM CDCIN;