FTP - Mismatch in number of column between data and link

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Sathish
Participant
Posts: 17
Joined: Tue Aug 10, 2004 3:23 pm

FTP - Mismatch in number of column between data and link

Post by Sathish »

I have problem using FTP stage to read data from Mainframe and write into sequential file.
When I execute the FTP job it gives the following message
"Mismatch in number of column between data and link"
This is a warning message for each record it processed, but it actually writes the data into the sequential file. I checked the sequential output file and it looks good. Also Metadata looks good to me.

Please suggest

Thanks
Sathish
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Please check the record delimiter and trailing blanks on both systems. Also check the 'Incomplete Column' attribute value in the resulting FTP-ed file in DataStage.
Jay
Participant
Posts: 105
Joined: Tue Nov 11, 2003 8:28 pm

Post by Jay »

Also check the length of the individual columns in the actual file and as defined in the column definition.
Post Reply