DSXchange

Posted: **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.

Posted: **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.

Posted: **Mon Feb 15, 2010 8:51 am**

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

Posted: **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.

Posted: **Mon Feb 15, 2010 1:40 pm**

Did you try LongVarBinary?

DSXchange

Reading large strings

Reading large strings