Unable to view all records from sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 126
- Joined: Thu Jul 01, 2010 11:39 pm
Unable to view all records from sequential file
Hi guys,
I have a sequential file. The file has 2500 rows but when i processed the file using datastage using sequential file, the job is processing only 253 rows.
Even viewdata is showing only 253 rows. No error is occuring.
Can somebody help me to process the whole file.
Cheers!!!
I have a sequential file. The file has 2500 rows but when i processed the file using datastage using sequential file, the job is processing only 253 rows.
Even viewdata is showing only 253 rows. No error is occuring.
Can somebody help me to process the whole file.
Cheers!!!
Mac4rfree
-
- Participant
- Posts: 126
- Joined: Thu Jul 01, 2010 11:39 pm
-
- Participant
- Posts: 126
- Joined: Thu Jul 01, 2010 11:39 pm
Following two records got loaded.chulett wrote:Your metadata doesn't match your file's data, nothing more than that. What settings are you using in the stage? What is different between a row it will process and one it rejects? Can you post an example of each?
Code: Select all
2011-05-03Aveo RETAIL US 12CHEVROLET CARS ENTRY CAR
2011-05-03Aveo FLEET US 250CHEVROLET CARS ENTRY CAR
Code: Select all
2011-05-03DTS RETAIL US 0CADILLAC CARS LUXURY CAR
2011-05-03DTS FLEET US 59CADILLAC CARS LUXURY CAR
Mac4rfree
-
- Participant
- Posts: 26
- Joined: Fri Feb 19, 2010 2:08 am
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 126
- Joined: Thu Jul 01, 2010 11:39 pm
This is what i got
Code: Select all
dsadm@catom-gmapdvl38:/appl/data/Input/US> cat -vte TESTING.txt
2011-05-03DTS RETAIL US 0CADILLAC CARS LUXURY CAR$
2011-05-03DTS FLEET US 59CADILLAC CARS LUXURY CAR$
2011-05-03HHR RETAIL US 7CHEVROLET TRUCKS VAN/MPV$
2011-05-03HHR FLEET US 246CHEVROLET TRUCKS VAN/MPV$
2011-05-03STS RETAIL US 2CADILLAC CARS LUXURY CAR$
2011-05-03Aveo RETAIL US 12CHEVROLET CARS ENTRY CAR$
2011-05-03Aveo FLEET US 250CHEVROLET CARS ENTRY CAR$
Mac4rfree
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 126
- Joined: Thu Jul 01, 2010 11:39 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Could it be that there's a Ctrl-M at the end of the lines (shows as ^M in vi) that is interfering with the parsing? That is, in what mode did you perform the FTP and does your FTP tool handle translating line terminators?
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: 126
- Joined: Thu Jul 01, 2010 11:39 pm