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
FTP Binary Data from Mainframe to Sequential
Moderators: chulett, rschirm, roy
The metadata that defines the column definitions of the source data does not match that in the actual source data.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Re: FTP Binary Data from Mainframe to Sequential
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
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
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.
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle