Flat files - Connect_CDC - connect_cdc_mimix_share - 5 - 5.8

Connect CDC Advanced User 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 Advanced User Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-27
ft:lastPublication
2023-09-27T18:12:55.651884

You have the ability to use a flat file as the target for data storage purposes. The target is a flat, sequential file, not a random access file. A flat file has no interrelationship between its data records. Data rows are appended one after the other sequentially, similar to a journal.

Writing to a flat file is advantageous in some situations:

  • A flat file can function as an intermediate target or a final target, thus providing a target for either temporary or permanent data storage.

  • A flat file is ideal for storing data or records that are not used frequently.

The following features are currently available in Connect CDC:

  • Only Replication requests are supported.

  • Source tables mapped to target files are unidirectional.

  • One source table may be mapped to only one target file on a File System server.

  • The source table may be mapped to files on different FileSystems.

  • The File System is a flat/sequential file that uses the Comma Separated Value (CSV) format. It is saved with a comma as the delimiter, although the delimiter can be changed. If the delimiter is changed, the file is still saved as a .csv file.

  • Datatypes, except long character, long and short binary types, are written as a string.

  • If a source table contains a mapped column of type Unicode, the target file properties defaults to a UTF-8 character set.

Connect CDC maintains the following guidelines when writing the target file:

  • The double quote character (") quotes each value. This includes the null string representation.

  • Empty strings have two quote characters with no character inside.

  • New line character(s), outside of quoted values delineate a row. The new line character is dependent on the operating system’s default new line character.

  • The first line of a file contains a list of delimited field names.

The table below specifies the datatypes supported for use with flat files.

DB2

Informix

MSS

Oracle

Sybase

IBM i

UDB

Biginta

Bigintb 

Char

Bigint

Char

Bit

Char

Char

Date

Bit

Date

Char

Char For Bit

Date

Datetime

Char

Decimal

Datetime

Date

Decimal

Decimal

Datetime

Double Precision

Decimal

Decimal

Double

Double Precision

Decimal

Float

Double Precision

Double

Float

Float

Double Precision

Integer

Float

Float

Integer

Integer

Float

Nchar

Integer

Graphicc

Numeric

Interval

Integer

Number

Money

Integer

Real

Money

Money

Numeric

Numeric

Numericd

Smallint

Numeric

Nchar

Nvarchar2

Real

Real

Time

Serial

Numeric

Real

Smalldatetime

Smallint

Timestamp

Smallfloat

Nvarchar

Small Int

Smallint

Time

Varchar <2000

Smallint

Real

Timestamp

Smallmoney

Timestamp

 

Varchar

Smalldatetime

Varchar2

Tinyint

Varchar

 

 

Smallint

 

Varchar

Varchar For Bit

 

 

Smallmoney

 

 

Vargraphicc

 

 

Tinyint

 

 

 

 

 

Unique- Identifier

 

 

 

 

 

Varchar

 

 

aSupported on IBM i with a special patch for data capture only

bSupported on Windows, Unix and Linux

cIf defined as Unicode: IBM i-Unicode defined per column

dRRN may not be a target for DB2/400.