DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
swathi.raoetr
Participant



Joined: 09 May 2017
Posts: 13

Points: 102

Post Posted: Thu Jun 15, 2017 6:19 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hello,

I have worked with several ETL tools, and have seen there are different ways to handle text fields. On importing a table definition the datastage has converted a text field into Longvarchar. The process then has to write into a hdfs location via hdfs connector, basically a .dsv file.

Here are some errors I am finding:
The array size must be set to 1 when reading LOBs. This setting when done however gives blank values.

When I set the Longvarchar value to the max 2GB value, it throws the error:
Schema reconciliation detected a mismatch for the field.

I think this may need some admin setting :
reference:

http://www-01.ibm.com/support/docview.wss?uid=swg21614781

Has anyone any better suggestions, solutions?
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