Extended Unsigned Integer - Real Time Scenario

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
karthi_gana
Premium Member
Premium Member
Posts: 729
Joined: Tue Apr 28, 2009 10:49 pm

Extended Unsigned Integer - Real Time Scenario

Post by karthi_gana »

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
Premium Member
Premium Member
Posts: 729
Joined: Tue Apr 28, 2009 10:49 pm

Re: Extended Unsigned Integer - Real Time Scenario

Post by karthi_gana »

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
UCDI
Premium Member
Premium Member
Posts: 383
Joined: Mon Mar 21, 2016 2:00 pm

Re: Extended Unsigned Integer - Real Time Scenario

Post by UCDI »

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.
Post Reply