error while loading oracle table

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
DSRajesh
Premium Member
Premium Member
Posts: 297
Joined: Mon Feb 05, 2007 10:37 pm

error while loading oracle table

Post by DSRajesh »

Hi All,

I am getting while loading data from dataset to oracle table.

Invalid field type in call to getInputFieldAsString() for field '2' in input dataset '0'.


But while i look manually at source data in dataset ,the data looks like correct as per the metadata.

Can any one please help what would be the cause for this issue.
RD
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

First off, remember that counting is zero based, so field 2 is actually the third field. What is the value in the third field and what is its data type as recorded (a) in your metadata and (b) in the Data Set? Note that the error is from getInputFieldAsString() function.
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