data string does not match format

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ravireddy25
Participant
Posts: 59
Joined: Wed Dec 31, 2008 5:49 am

data string does not match format

Post by ravireddy25 »

For one column dattype is varchar and data is like 2008-10-20k , after transformer 5 records are rejecting, but from source(seq stage) all records are coming , m getting warning
APT_CombinedOperatorController(1),0: Data string ' ' does not match format '%yyyy-%mm-%dd': an integer was expected to match tag %yyyy.
Ravi
v2kmadhav
Premium Member
Premium Member
Posts: 78
Joined: Fri May 26, 2006 7:31 am
Location: London

Re: data string does not match format

Post by v2kmadhav »

ravireddy25 wrote: 2008-10-20k
Ravi

what is that K for??
did you try looking through your source data to figure out any abnormality?
does it look fine there.
if your row count on the source is lesser than 9999 are you able to view data on the source file through datastage?

cheers
VM
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is the "k" date suffix meant to be part of the data or is it erroneous? You have to process it in either case.

Disable operator combination to learn the actual source of the error.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply