Read Column more than 255 Characters

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
bbobpop1
Participant
Posts: 29
Joined: Sun Jul 20, 2008 9:55 am

Read Column more than 255 Characters

Post by bbobpop1 »

Hi

I have a requirement in which, I need to read a column with has 100,000 characters. The source is a sequential file (.csv). Total Rows between 10 to 200.

Can I read the column in a sequential file as VARCHAR (100000)? If yes, what is the maximum length i can specify to read the column?

Thanks
Bob
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Longvarchar.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply