One row missing
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 1
- Joined: Fri May 09, 2003 9:05 am
- Location: USA
One row missing
One row is missing in every load. If I load 101 rows then only 100 rows are loaded. The other one record is neither in error log/rejected file nor in Final Table. ( Initially thought the first row of the file is treated as header line so its not reading but I have not mentioned anything like that because there is no header line for the file.) What could be the reason. The job is server job.
Re: One row missing
I am just guessing that you might have missed the new line character at the end of last line in the source file.
aruna_peri wrote:One row is missing in every load. If I load 101 rows then only 100 rows are loaded. The other one record is neither in error log/rejected file nor in Final Table. ( Initially thought the first row of the file is treated as header line so its not reading but I have not mentioned anything like that because there is no header line for the file.) What could be the reason. The job is server job.
Re: One row missing
Have to ask - ok, there is no header record in the file, but is the 'First line is column names' option on the 'Format' tab in the Sequential file stage checked? That would consistantly throw away the first record in your file.aruna_peri wrote:Initially thought the first row of the file is treated as header line so its not reading but I have not mentioned anything like that because there is no header line for the file.
Speaking of which, any idea which record is missing? First or last?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If it's the last record that's missing, check that the last record in the file has a line terminator (end-of-line marker).
Open the file with a text editor, and position to end of the file. If this is the end of the final line, add an end-of-line (that is, go into insert mode and press Enter). File the result.
If end-of-file is the line following the last line of data, then something else is the problem. Is "first line is header" checked on the Format tab? In this case, whether or not the first line is, in fact, column headings, line number 1 will not be processed. If the first line is actually data, make sure that this check box is cleared.
Finally, check that your job run limit is not set to 100.![Embarassed :oops:](./images/smilies/icon_redface.gif)
Open the file with a text editor, and position to end of the file. If this is the end of the final line, add an end-of-line (that is, go into insert mode and press Enter). File the result.
If end-of-file is the line following the last line of data, then something else is the problem. Is "first line is header" checked on the Format tab? In this case, whether or not the first line is, in fact, column headings, line number 1 will not be processed. If the first line is actually data, make sure that this check box is cleared.
Finally, check that your job run limit is not set to 100.
![Embarassed :oops:](./images/smilies/icon_redface.gif)
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: One row missing
[quote="aruna_peri"]One row is missing in every load. If I load 101 rows then only 100 rows are loaded. The other one record is neither in error log/rejected file nor in Final Table. ( Initially thought the first row of the file is treated as header line so its not reading but I have not mentioned anything like that because there is no header line for the file.) What could be the reason. The job is server job.[/quote
Most probably you have checked the "First Line is Column Names" check box on the "Format" tab of your Sequential File Stage. Try unchecking !!!
Most probably you have checked the "First Line is Column Names" check box on the "Format" tab of your Sequential File Stage. Try unchecking !!!
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am