Create file mapping - connect_cdc_mimix_share

Create file mapping - connect_cdc_mimix_share - Latest

Connect CDC System Reference Guide

Product type

Software

Portfolio

Integrate

Product family

Connect

Product

Connect > Connect CDC (MIMIX Share)

Version

Latest

Language

English

Product name

Connect CDC

Title

Connect CDC System Reference Guide

2024

First publish date

2003

Last edition

2024-08-20

Last publish date

2024-08-20T21:40:14.000381

Usage

Creates mappings to one or more FileSystem servers.

Syntax

CREATE FILE MAPPING
   TARGET filename AT [SERVER] targetfilesystem, …
   FROM SOURCE shared-table-name AT [SERVER] source-server-name
   [LOCATION pathname]
   [ROLLOVER {AT hh:mm:ss | EVERY hhh:mm:ss  | SIZE nsize |
      ROWS nrows | REQSTOPS } ]
   [CHARSET {"default" | "utf-8"}]
   [DELIMITER 'delchar']
   [QUOTE_CHAR 'quotechar']
   [NULL_STRING 'nullval']
   [DISTRIBUTION distname, …]
   [GATE_CONDITION 'text of expression-embed single quotes by doubling']
   { target-column-name [DKEY] :
      same as described in CREATE TABLE MAPPING
   }, …   [WRITE_BEFORE_VALUES];

Parameters

Parameter	Description

LOCATION	Specifies the path to location of the target file.
ROLLOVER	Specifies the criteria for the target file to roll over to a new operating system file. Event options are: AT–At a specific point in time: You can set the time in hours:minutes:seconds. This is set in 24-hour time (0 to 23). You cannot specify the day; you can only specify the time during one day. EVERY–After a specific interval in time, expressed in HH:MM:SS, where HH may be any positive integer, and MM and SS are minutes and seconds. The hours may be greater than 24. SIZE–After the file reaches a specific size in characters ROWS–After a file contains some number of rows REQSTOPS–Only when the request stops (default)
CHARSET	Specifies the character set for the target flat file: Default–operating system character set. UTF-8–Use if the source table contains Unicode columns.
DELIMITER	Specifies the column delimiter character. The default is comma. This character must be an ASCII character from 1 to 253. The character itself may be entered. To enter a single quote, use four single quotes ’’’’.
QUOTE_CHAR	Specifies the quote character. The default is a double quote (“). This character must be an ASCII character from 1 to 253. The character itself may be entered.
NULL_STRING	The default is “~”. Connect CDC differentiates between null and empty strings. Connect CDC identifies an empty string as no character.
DISTRIBUTION	Specifies the name of the Distribution that is to include the request and table mapping for the flat file.
GATE_CONDITION	Include the text of the expression. Embed any single quotes by doubling.
WRITE_BEFORE_VALUES	Before and After values for all columns will be written to the File Server when an update statement is captured.

Example

-- RSL File Mapping (ricks.dbo.parts@sqlserver to ricks.dbo.partsMODIFIED@fsnew) definition.
 
create file mapping
   target "ricks.dbo.partsmodified" at server fsnew
   from source ricks.dbo.parts at server sqlserver
   location "c:\src\omnienterprise\debug\targetfiles\filesysnew\sqlserver\"
   charset "utf-8"    delimiter ':'
   quote_char ''''    null_string '<null>'    rollover    at 23:59:09
   city: city, price: price, weight: weight, pno DKEY: pno,
   sv_manip_type: "Row manipulation type "( ), sv_trans_id: "Transaction id
   "( ), sv_trans_row_seq: "Transaction row sequence "( ),
   sv_sending_table: "Sending table name "( ),    sv_sending_dbms:
   "Sending DBMS type "( ), sv_sending_server: "Sending server name "( ),
    sv_trans_timestamp: "Transaction timestamp "( ), sv_trans_username:
   "Transaction username "( );