Create file mapping - 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 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 "( );