Connect CDC SQData

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;