Printing the column mappings added to a publication (printusercolmapping) v7

Suggest edits

For SMR only: The printusercolmapping command prints column data type mapping between the publication and subscription database.

Synopsis

-printusercolmapping <pubname> -repsvrfile <pubsvrfile> [-subname <subname>] [-details]

Parameters

pubname

The name of the publication whose column mappings are displaying.

pubsvrfile

The file containing the publication server login information.

subname

The name of the subscription whose column mappings are displaying. Providing the name allows for the column mappings to be filtered according to the subscription name.

details

Provides additional details about implicit column mappings and internal mapping representation of the column mapping. Implicit column mappings are'nt provided by the user. They are added by default depending on source and target database and their versions. For example, JSON is'nt supported on Oracle database versions 21 and earlier. Memory mapping is referred to as internal mapping in Replication Server.

Examples

The following is an example where -details isn't included:

$ java -jar edb-repcli.jar -printusercolmapping emp_pub -repsvrfile ~/pubsvrfile.prop
          
Printing user column mapping details...

Publication name:Subscription name:User expressions
emp_pub:emp_sub:uuidasprimarykey.id=char;public.mapjson.details=varchar2(4000);.*no=numeric;mapjson1..*=clob

The following is an example where -details is included:

java -jar edb-repcli.jar -printusercolmapping emp_pub -repsvrfile ~/pubsvrfile.prop  -details

Printing user column mapping details...

Publication name:Subscription name:User expressions
emp_pub:emp_sub:uuidasprimarykey.id=char;public.mapjson.details=varchar2(4000);.*no=numeric;mapjson1..*=clob

Printing implicit column mapping details (Not provided by user)...

Publication name:Subscription name:Database incompatible datatype-->Database compatible datatype
emp_pub:emp_sub1:json-->varchar
Note: Please provide custom column mapping with -customcolmap argument to override implicit mapping.

Printing internal column mapping representation...

Publication name:Subscription name:Table name:Column name:Source datatype-->Target datatype
emp_pub:emp_sub:public.test123:deptbuildno:integer-->number
emp_pub:emp_sub:public.test123:deptno:numeric-->number
emp_pub:emp_sub1:public.mapjson1:details:json-->varchar
emp_pub:emp_sub1:public.mapjson:details:json-->varchar
Note

User provided column data type mappings override implicit column data type mappings when they are present in the same column.

← Prev

Printing a subscription list (printsublist)

Next →

Enabling filters on a subscription or non-MDN node (enablefilter)