Create or modify a distribution - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

Usage

Creates or modifies a distribution, an instruction for data movement between 2 servers.

Syntax
CREATE DISTRIBUTION name [PROCESS processname AT SERVER servername]Or   ALTER DISTRIBUTION name TO
{ {ADD | REMOVE} ALL MAPPINGS |
[ {ADD | REMOVE} MAPPING server.fulltablename TO
 { server.fulltablename | FILE filename AT [SERVER] servername }]} …
   [DESCRIPTION 'descriptive text']
;
Parameters

Parameter

Description

CREATE

Establish a new distribution.

ALTER

Modify a previously established distribution. The choices are:

  • Add/remove all mappings

  • Add/removed a specific mapping using table names.

DESCRIPTION

User-defined text.

Examples
-- RSL DISTRIBUTION flatfile definition
 
CREATE DISTRIBUTION FLATFILE
   ADD MAPPING
qatestA.qatest.dbo.JOR_DATATYPES_1 TO FILE "qatest.dbo.JOR_DATATYPES_1" AT SERVER FlatFile_win
   ADD MAPPING
qatestA.qatest.dbo.JOR_DATATYPES_2 TO FILE "qatest.dbo.JOR_DATATYPES_2" AT SERVER FlatFile_win
;
-- RSL DISTRIBUTION AS400 definition.
CREATE DISTRIBUTION "Distribution_1"
PROCESS "PATILS/QSQJRN" AT SERVER "10.22.27.34"
   ADD MAPPING "10.22.27.34".PATILS."AS400_unicodetbl" to "172.31.186.149"."spsource".dbo."AS400_unicodetbl"
;