Page 1 of 1

Is it possible to FTP a PS to an exce file?

PostPosted: Fri Mar 20, 2009 6:25 pm
by roopesh_vp
Is it possible to FTP a PS to an exce file? If so, please explain me how is it done..

Thank you

Re: Is it possible to FTP a PS to an exce file?

PostPosted: Fri Mar 20, 2009 7:29 pm
by MrSpock
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.

Re: Is it possible to FTP a PS to an exce file?

PostPosted: Fri Mar 20, 2009 7:31 pm
by Bill Dennis
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.

Re: Is it possible to FTP a PS to an exce file?

PostPosted: Fri Mar 20, 2009 11:29 pm
by dick scherrer
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?