Datastage sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 36
- Joined: Fri May 21, 2010 12:40 am
- Location: Bangalore
Datastage sequential file
There is a file with n rows but sequential source stage is only considering
n-3 rows--we are reading it as DOS file
n-3 rows--we are reading it as DOS file
Sandeep Chandrashekar
Re: Datastage sequential file
Do you see any warnings?.
Is the option 'First Line column Name' set to True?
Do you exactly see the last 3 records being omitted when you view data or is it getting diplayed adjacent to the last record when you view data?.If so what is the record delimiter that you have specified?.
Is the option 'First Line column Name' set to True?
Do you exactly see the last 3 records being omitted when you view data or is it getting diplayed adjacent to the last record when you view data?.If so what is the record delimiter that you have specified?.
Re: Datastage sequential file
Try to open it in vi editor (if it is small). Understand the file.
Use reject link while read the data and try to find what the issue is.
DS User
Use reject link while read the data and try to find what the issue is.
DS User
-
- Participant
- Posts: 36
- Joined: Fri May 21, 2010 12:40 am
- Location: Bangalore
Re: Datastage sequential file
In the source itself these three records are being ignored. and this is in between the records. its a dos file and contains ^M\n towords the end of each record.all three records are coming in newline.
Sandeep Chandrashekar
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Sandeep, did you run the job at the first place or just viewing data in sequential file?
Even if a record does not meet the expected format, it will be rejected. So run the job and see what happens.
As suggested by another friend, use reject link & try!!
Even if a record does not meet the expected format, it will be rejected. So run the job and see what happens.
As suggested by another friend, use reject link & try!!
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 36
- Joined: Fri May 21, 2010 12:40 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore