Short input record - Sequential file stage
Posted: Thu Dec 29, 2011 5:56 pm
Hi
I have a job that pulls data from s DB2 table and then joins it with a file.
Then we do some transformation, and write it to a sequential file (using a sequential file stage).
The job completes successfully (no warnings too..
).
But when i click on View Data to see the data in the file, im getting the following error message:
Import complete; 0 records imported successfully, 2 rejected.
**VIEWDATA ROW LIMITER HIT**
Also when i go to vi to view the contents of the file:
I can see that some of the fields are missing in the actual file. (I totaly have 17 fields and the first 10 fields are missing in the actual file while checkin in the vi). But when i use a peek stage or data set to see the data, everything looks perfect.
Since some of the fields were getting dropped i tried to use a modify stage with KEEP, - its the same problem... job completes.. but actual file is missing first 10 fields.
I have a job that pulls data from s DB2 table and then joins it with a file.
Then we do some transformation, and write it to a sequential file (using a sequential file stage).
The job completes successfully (no warnings too..
![Smile :)](./images/smilies/icon_smile.gif)
But when i click on View Data to see the data in the file, im getting the following error message:
Import complete; 0 records imported successfully, 2 rejected.
**VIEWDATA ROW LIMITER HIT**
Also when i go to vi to view the contents of the file:
I can see that some of the fields are missing in the actual file. (I totaly have 17 fields and the first 10 fields are missing in the actual file while checkin in the vi). But when i use a peek stage or data set to see the data, everything looks perfect.
Since some of the fields were getting dropped i tried to use a modify stage with KEEP, - its the same problem... job completes.. but actual file is missing first 10 fields.