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.
Short input record - Sequential file stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
Short input record - Sequential file stage
Thanks
Karthick
Karthick
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
Then i tried to use a column export to have all the fields into 1 field, still not working.
The fields that are missing in the actual file have data type of varchar (not Null). And all the fields have proper values in it.
Can somebody help me. Please let me know if i need to supply any other input.
The fields that are missing in the actual file have data type of varchar (not Null). And all the fields have proper values in it.
Can somebody help me. Please let me know if i need to supply any other input.
Thanks
Karthick
Karthick