DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
rakesh.puli



Group memberships:
Premium Members

Joined: 22 Mar 2017
Posts: 29

Points: 327

Post Posted: Thu Aug 27, 2020 10:47 am Reply with quote Back to top

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi Everyone,

I am loading data from sql server table to fileset in the first datastage job

and in the second job i am using the first job fileset as source and loading to the target netezza.

while extracting from fileset in the second job, I am getting this error.



Fatal : Field XYZ has import error and no default value : data :{b7 b7}, at offset :13

warning : import unsuccessful at record zero

Exisitng values in this "xyz" field is NULL.

datatype for this "XYZ" column is decimal(10,4) in source sql

datatype for this "XYZ" column in target netezza is numeric(10,4)



can any one plese let me know how it can be solve this

Thanks
Rakesh P
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54595
Location: Sydney, Australia
Points: 296053

Post Posted: Thu Oct 08, 2020 10:56 am Reply with quote Back to top

Try using a Data Set rather than a File Set. A Data Set preserves the underlying data type, whereas a File Set translates the data into human-readable format. Also make sure that the data types ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
Display posts from previous:

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours