IBM Mainframe Forum

Is it possible to FTP a PS to an exce file? If so, please explain me how is it done..

Thank you

What is a "exce" file? Keep in mind that this is an IBM mainframe-oriented forum and we need to stick to topics concerning standard IBM mainframe file formats.

But, for the sake of discussion, FTP doesn't care about the content of the data being transferred.

Do you mean an excel spreadsheet file?

There is no automatic method to insert column tab characters or change the presentation of the data during FTP transmit. You must manipulate the data through a utility on the mainframe and then FTP to the desktop.

Hello roopesh and welcome to the forum,

One easy way to do what you want to to create a tab-delimited text file using the cobol STRING statement. The file created on the mainframe should contain no packed-decimal, binary, or implied decimals.

FTP the tab-delimited file to the desktop and import into Excel.

You are asking about MS-Excel, right?