DSXchange

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!

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?

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.