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



TSO Programming, ISPF, SDF, SDSF and PDF, FTP, TCP/IP Concepts, SNA & SNA/IP etc...

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

Postby roopesh_vp » Fri Mar 20, 2009 6:25 pm

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

Thank you
roopesh_vp
 
Posts: 4
Joined: Fri Mar 20, 2009 6:20 pm
Has thanked: 0 time
Been thanked: 0 time

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

 

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

Postby MrSpock » Fri Mar 20, 2009 7:29 pm

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.
User avatar
MrSpock
Global moderator
 
Posts: 810
Joined: Wed Jun 06, 2007 9:37 pm
Location: Raleigh NC USA
Has thanked: 0 time
Been thanked: 2 times

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

Postby Bill Dennis » Fri Mar 20, 2009 7:31 pm

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.
Regards,

Bill Dennis

Disclaimer: My comments on this forum are my own and do not represent the opinions or suggestions of any other person or business entity.
Bill Dennis
 
Posts: 278
Joined: Thu May 15, 2008 9:45 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby dick scherrer » Fri Mar 20, 2009 11:29 pm

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?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to TSO & ISPF

 


  • Related topics
    Replies
    Views
    Last post