Reading large strings

Neelima_B · Post by **Neelima_B** » Mon Feb 15, 2010 4:09 am

Hi,

Is it possible to read a string of length - 47489897 in data stage. Currently I need this. I am using DRS stage to read the data.

Please help me regarding this.

Thanks in advance,
Neelima.

chulett · Post by **chulett** » Mon Feb 15, 2010 8:43 am

That would be a CLOB field which is technically not supported. However, that doesn't necessarily mean it won't work. What have you tried? Perhaps an unbounded LongVarchar would do the trick.

Ankur_KapoorUK · Post by **Ankur_KapoorUK** » Mon Feb 15, 2010 8:51 am

Try unbounded LongVarchar as suggested by craig, it should work...

chulett · Post by **chulett** » Mon Feb 15, 2010 8:56 am

Depends on the database and the stage used but the DRS stage seems to work 'more better' for stuff like this from what I've seen.

dsuser_cai · Post by **dsuser_cai** » Mon Feb 15, 2010 1:40 pm

Did you try LongVarBinary?