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:
|
|
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"
;