FTP Binary Data from Mainframe to Sequential

[Bryceson]

We are using FTP Stage to FTP Binary Data from Mainframe to Sequential file - We are getting this warning "Mismatch in number of column between data and link". Why does DataStage give this warning??

Any idea/thoughts in dealing with FTP Stage is appreciated.

Thanks . . . Bryceson

[kcbland]

The metadata that defines the column definitions of the source data does not match that in the actual source data.

[Bryceson]

Hi Ken,

We have One column for the source data VarBinary 9999 and One column for target data VarBinary 9999. How could that Metadata not be matching??

Thanks . . . Bryceson

[kcbland]

If you are trying to use the FTP stage to copy a binary file from the mainframe to the server and retain it as a binary file, then I suggest you use the command line version of FTP to do the copy.

The FTP stage is trying to read the file with row delimiters, which you don't have, it's binary not sequential data. Therefore, the metadata doesn't work.

If the source data was textual, then you're okay. Try to use command line FTP to "move" files, and use the FTP stage to "read" files.