I use a sequential stage to read a DB2 exported file .
one record only has two columns one is id (int),the other is name(char(60))
but sometime there will be a " in the second column, after exported,there will be double " in the file,one is the escape code.
so in this time how can i read the file?
if i set the column length 60,sometime it will be too short
if i set the column length longer or use type varchar,the stage will read double " in the column .
how to handle the escape code in sequential file stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: