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



Group memberships:
Premium Members

Joined: 28 Apr 2009
Posts: 729

Points: 6654

Post Posted: Wed Aug 09, 2017 6:16 am Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
All,

I have created some test job to understand the Sequential File's Extended property - Unsigned.

I have designed a simple job as below.

int_test.txt

1234567890123

seq_file_stage --> copy --> seq_file_stage

column: t - integer -- extended = Unsigned

It is same for both the input & output file.

Eventhough I used "Extended" property, This row is not at all read by the seq_file stage and written into output file.

is it not a good example to learn about "Extended -Unsigned" ?

Or is my understanding about "Extended -Unsigned" is not correct?

Inputs are welcome!

_________________
Karthik
karthi_gana



Group memberships:
Premium Members

Joined: 28 Apr 2009
Posts: 729

Points: 6654

Post Posted: Wed Aug 09, 2017 6:27 am Reply with quote    Back to top    

I changed the file content to 2147483648 and tried both Integer and Unsigned Integer. I am able to understand now.

How about Varchar with Extended Unicode ? Can anyone give an example?

_________________
Karthik
Rate this response:  
Not yet rated
UCDI



Group memberships:
Premium Members

Joined: 21 Mar 2016
Posts: 261

Points: 2643

Post Posted: Wed Aug 09, 2017 10:34 am Reply with quote    Back to top    

copy some text from a non USA english speaking web site full of non english chars, and put it into a string with the option on, and off, and see what you get in a peek.
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