Sequential FIle Problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Sat Feb 28, 2004 12:11 pm
Sequential FIle Problem
Hi
I am using .RCV sequential file as source , while running the / viewing the data I am getting error like " nls_read_delimited() - row 1, column XXXX_Column, required column missing ' .
The job is abortiing .
I need some help to resolving thi issue .
thanks in advance
hari
I am using .RCV sequential file as source , while running the / viewing the data I am getting error like " nls_read_delimited() - row 1, column XXXX_Column, required column missing ' .
The job is abortiing .
I need some help to resolving thi issue .
thanks in advance
hari
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This error can also occur if the file is fixed-width format and you either neglect to check the Fixed Width check box on the format tab or get the display widths (= column widths) wrong in the Columns grid.
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.
Re: Sequential FIle Problem
Hello there,
I think the problem is with number of columns defined in the Sequential file Stage. Perhaps the number of columns defined in the Stage is less than the required columns. This may occur when you accidentally remove some columns from the stage.
I would suggest you to delete all the columns from the stage and reload the columns.
I think the problem is with number of columns defined in the Sequential file Stage. Perhaps the number of columns defined in the Stage is less than the required columns. This may occur when you accidentally remove some columns from the stage.
I would suggest you to delete all the columns from the stage and reload the columns.
Sequential FIle Problem
I differ with you amsh76. When you click "View data" and you get the above mentioned error it means that there are fewer columns defined in the stage than expected to display the data. Am I right?amsh76 wrote:Hi Yaminids,
Its the other way round. The number of columns in the file is less that columns defined in stage.
Just look at that record and you should get the answer to your question.
Nope, sorry.
'Required column missing' means that a column required by the stage is not present in the file being read. I.E. you've declared six columns in the stage and it only found five in the file - and the sixth one is still marked as 'required' (the default) on the Columns tab.
'Required column missing' means that a column required by the stage is not present in the file being read. I.E. you've declared six columns in the stage and it only found five in the file - and the sixth one is still marked as 'required' (the default) on the Columns tab.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 38
- Joined: Sat Feb 28, 2004 12:11 pm
Sainath.Srinivasan wrote:It says that the required column is missing. So the data has missing columns and not excess columns.
HI
The data has all columns , in first row only fist column is filled , the remaining columns are empty , for other rows every thingi s perfect .Still I am facing the same issue .
-
- Participant
- Posts: 38
- Joined: Sat Feb 28, 2004 12:11 pm
Can you tell us how many columns you have defined in your stage and how many commas you have in each line in the text file? If you have 5 columns defined each line should have 4 commas used as separators. You can, but only for testing purposes, go into the column definitions for this sequential file and specify "incomplete column" for the last column to make it retain & warn and see what you get as an output.mtechnocrat wrote: The data has all columns , in first row only fist column is filled , the remaining columns are empty , for other rows every thingi s perfect .Still I am facing the same issue .
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom