TCP/IP Datastores - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Apply engine
Copyright
2024
First publish date
2000
Last updated
2024-12-13
Published on
2024-12-13T13:15:51.808737

TCP/IP Datastores act like a direct pipe between systems. They are high performance and simplify communication between heterogeneous platforms like z/OS and UNIX. They can be secured by using Virtual Private Networking (VPN) and are preferred over FTP. The only restriction is that unlike FTP, a process must be ready and waiting for data to come through the pipe. With Connect CDC SQData this is usually accomplished through the use of an Engine Controller SQDaemon on the target system, that can initiate the receiving process before data begins to flow through the pipe.

Example:

Defining a TCP/IP datastore to be used for cross platform operation between a host system and another system, SYSB. The source system contains a sequential flat file source datastore identified by DDName EMPIN that is defined by COBOL copybook (EMPLOYEE). The target datastore is a DB2 LUW (UDB) datastore that will be created using the DB2 Load utility. Use TCP/IP port number 1830 for the communication.
-- Define the input and output file layout --
DESCRIPTION COBOL DD:COBLIB(EMPLOYEE)
          AS EMPLOYEE;
		  
-- Define the Source Datastore --
DATASTORE DD:EMPIN
          OF BINARY
          AS EMPLOYEE_IN
         DESCRIBED BY EMPLOYEE;
		 
-- Define theTarget Datastore --
DATASTORE TCP://SYSB/1830
          OF DB2LOAD
          AS EMPLOYEE_OUT
          DESCRIBED BY EMPLOYEE;