Short input record - Sequential file stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsuser_cai
Premium Member
Premium Member
Posts: 151
Joined: Fri Feb 13, 2009 4:19 pm

Short input record - Sequential file stage

Post by dsuser_cai »

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.
Thanks
Karthick
dsuser_cai
Premium Member
Premium Member
Posts: 151
Joined: Fri Feb 13, 2009 4:19 pm

Post by dsuser_cai »

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.
Thanks
Karthick
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

if the records gets dropped, then they have not met the metadata defined.
Please look into this, else post your actual data and the datatype.
pandeeswaran
Post Reply