PROCESS INTO - connect_cdc_sqdata - Latest

Syntax

PROCESS INTO <target_datastore> [, <target_datastore>]
SELECT [UNION];

Keyword and Parameter Descriptions

-- Specify the source/target data structures
DESCRIPTION COBOL  file_name AS SRC_DESCR;
DESCRIPTION COBOL  file_name AS TGT_DESCR;

-- Specify the source datastore
DATASTORE MQS:///CDC_QUEUE_IN
        OF IMSCDC
        AS CDCIN
        DESCRIBED BY SRC_DESCR;
		
-- Specify the target datastore with a key and change op reference
DATASTORE TGT_TABLE
         OF RELATIONAL
         AS TBL_OUT
         DESCRIBED BY TGT_DESCR
         KEY IS COLA
         OPERATION IS V_CHGOP
         FOR CHANGE;

-- Specify Variables
DECLARE V_CHGOP     1 ' ';

-- Specify the Processing
PROCESS INTO TBL_OUT
SELECT
{
   V_CHGOP = CDCOP(CDCIN)
   TBL_OUT.COLA = FIELD1
   TBL_OUT.COLB = FIELD2
}
FROM CDCIN;

Insert data from two segments in an IMS database into a single Oracle table by creating a comma delimited file that will be input to the Oracle Loader utility on a second platform. Note, this is an example of a refresh script that might be used once at initial implementation and then maintained as a backup to a real-time CDC Replication process also implemented using Connect CDC SQData

-- Specify the source/target data structures
DESCRIPTION COBOL  file_name AS SRC_DESCR;
DESCRIPTION COBOL  file_name AS TGT_DESCR;

-- Specify the source datastore --
DATASTORE AUTO_DETAIL
        OF RELATIONAL
        AS TBL_IN
        DESCRIBED BY SRC_DESCR;

-- Specify the target datastore with INSERT op reference --
DATASTORE AUTO_MASTER
         OF RELATIONAL
         AS TBL_OUT
         DESCRIBED BY TGT_DESCR
         FOR INSERT;

-- Specify the Processing
PROCESS INTO AUTO_MASTER
SELECT
{
   SALES_INFO.MAKE       = AUTO_DETAIL.AUTO_MAKE
   SALES_INFO.OWNER       = AUTO_DETAIL.AUTO_OWNER
}
FROM AUTO_DETAIL;

Insert two columns (AUTO_MAKE and AUTO_OWNER) from the source datastore AUTO_DETAIL into Target Source Datastore SALES_INFO.

-- Specify the source/target data structures
DESCRIPTION COBOL  file_name AS SRC_DESCR;
DESCRIPTION COBOL  file_name AS TGT_DESCR;

-- Specify the source datastore
DATASTORE AUTO_DETAIL
        OF RELATIONAL
        AS AUTO_DETAIL
        DESCRIBED BY SRC_DESCR;

-- Specify the target datastore with INSERT op reference
DATASTORE SALES_INFO
         OF RELATIONAL
         AS SALES_INFO
         DESCRIBED BY TGT_DESCR
         FOR INSERT;
		 
-- Specify the Processing
INSERT INTO  SALES_INFO
SELECT
{
   SALES_INFO.MAKE       = AUTO_DETAIL.AUTO_MAKE
   SALES_INFO.OWNER       = AUTO_DETAIL.AUTO_OWNER
}
FROM AUTO_DETAIL;