Datastage sequential file

[Sandeepch19]

There is a file with n rows but sequential source stage is only considering
n-3 rows--we are reading it as DOS file

[dsusersaj]

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?.

[SURA]

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

[Sandeepch19]

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.

[kandyshandy]

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!!

[ray.wurlod]

Server jobs don't have reject links on Sequential File stage.

Are there any warnings in the job log?

[Sandeepch19]

there are no warnings in the job log.

[ray.wurlod]

As a test, can you try reading from the file with the metadata describing only one field, say VarChar(2000) data type?

[kandyshandy]

My bad Ray. I did not notice that it is a server job.

Sandeep, did you find out what was wrong?