I am trying to retrieve data from unix file through Sequential File Stage, the layout of file is like following
1....2 ......3 ........165......200....257
-------------------------------------------
1; 235; 9090;.... 0000;
2; 353; 8849;.... 3666;... .... ....7780;
3; 536; 4672;.... 5745;... 8383;
it has about 257 columns with ; delimited, my problem is that only those records with data in all 257 fields will show up, which means in above example record 1 and 3 won't be retrieved, even I set each column nullable in table definition. The server is Linux redhat.
Please give any adv how to retrieve the entile data set
Thanks a lot
Retrieve from Unix file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Pre-process the file so that each line has 256 ";" characters. You could even do this in DataStage; read the line as a single VarChar field, add the appropriate number of semi-colons then re-parse using Column Import stage.
Code: Select all
InField : Str(";",256-Count(InField,";"))
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: