GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

GoldenGate FORMATASCII

edited Dec 30, 2018 4:02AM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered

Hello professionals:

I read Oracle document:  https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters065.htm#GWURF497  , and there is an example Example 3,

Example 3  

FORMATASCII, NOHDRFIELDS, OP, TS, NONAMES, NOQUOTE produces the following:

I,CUSTOMER,2011-01-21:14:09:46.421335,Eric,San Fran,550,

V,CUSTOMER,2011-01-21:14:09:46.421335,Eric,,100,

But when I tried it by myself using FORMATASCII, NOHDRFIELDS, OP, TS, NONAMES, NOQUOTE ,I only can get:

2011-01-21:14:09:46.421335,Eric,San Fran,550,

2011-01-21:14:09:46.421335,Eric,,100,

is there something wrong there? how can I get these output in my file:

I,CUSTOMER,2011-01-21:14:09:46.421335,Eric,San Fran,550,

V,CUSTOMER,2011-01-21:14:09:46.421335,Eric,,100,

Here is my params for extract:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center