how to read 16000 length data using sequential file

pavankatra · Post by **pavankatra** » Wed Apr 28, 2010 2:34 am

Hi,
i have varchar column in a flat file, that has 16000length data.I am unable to read the data from the sequential fie.

so can anyone please tell me how to read that file in the datastage.

Thanks in advance

Thanks
Pavan Kumar

ETLJOB · Post by **ETLJOB** » Wed Apr 28, 2010 2:54 am

Try "LongVarChar"

pavankatra · Post by **pavankatra** » Wed Apr 28, 2010 3:08 am

ETLJOB wrote:Try "LongVarChar"

THANKS FOR YOUR REPLY.

But it is not working.

Thanks
Pavan Kumar

ray.wurlod · Post by **ray.wurlod** » Wed Apr 28, 2010 4:32 am

Without the actual error message we can not help.

"not working" is merely a synonym for "unemployed" - it is not useful for diagnostic purposes.

pavankatra · Post by **pavankatra** » Wed Apr 28, 2010 9:31 am

ray.wurlod wrote:Without the actual error message we can not help.

"not working" is merely a synonym for "unemployed" - it is not useful for diagnostic purposes. ...

Thanks for u r reply.

actually i got import error.Now it is resolved.

Thanks for your help.

Thanks
Pavan Kuamr

ray.wurlod · Post by **ray.wurlod** » Wed Apr 28, 2010 4:56 pm

Standard practice here is, when marking a thread as Resolved, to make a post indicating how it was resolved. This helps future searchers.

Also, we strive for a professional standard of written English, among other things to help those whose first language is not English. DSXchange is not a mobile telephone; there is no requirement to use SMS-style or idiosyncratic abbreviations. The second person personal pronoun in English is spelled "you", not "u"; the present tense of the verb "to be" is spelled "are", not "r".