Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to FTP GET a file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
karthickrrajamani

New User


Joined: 19 Aug 2008
Posts: 4
Location: Chennai

PostPosted: Fri Jun 10, 2011 2:09 am    Post subject: How to FTP GET a file
Reply with quote

I'm using a GET command to retrieve a file from my remote location and i see that the output file has spaces between each character as shown below. Also multiple records are getting concatenated as 1 long string. Any confirgurations I am missing ? Please enlighten


=COLS> ----+----1----+----2----+----3----+----4----+----5----+----6---
****** ***************************** Top of Data *********************
000001 ~1 1 0 6 0 2 ; 0 9 1 6 2 ; G 9 5 1 0 4 7 0 3 1 ; 0 0 0 0 0 0 1
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7232

PostPosted: Fri Jun 10, 2011 2:19 am    Post subject:
Reply with quote

Can you copy & paste the messages from the transfer with "code tags" (button above the input form, says Code)?

Can you also do a hex display for the data above, and where you think your data should be a 2nd record, and the end of the file?
Back to top
View user's profile Send private message
karthickrrajamani

New User


Joined: 19 Aug 2008
Posts: 4
Location: Chennai

PostPosted: Fri Jun 10, 2011 2:38 am    Post subject:
Reply with quote

Code:
EZA1736I FTP XX.XXX.XXX.XX (EXIT                                               
EZY2640I Using /etc/ftp.data for local site configuration parameters.           
EZA1450I IBM FTP CS V1R10                                                       
EZA1466I FTP: using TCPIP                                                       
EZA1772I FTP: EXIT has been set.                                               
EZA1554I Connecting to:   XX.XXX.XXX.XX port: 21.                               
220 DRFSFTPZ1 Microsoft FTP Service (Version 5.0).                             
EZA1459I NAME (XX.XXX.XXX.XX:T0AAAAA):                                         
EZA1701I >>> USER AAA                                                     
331 Password required for AAA.                                             
EZA1789I PASSWORD:                                                             
EZA1701I >>> PASS                                                               
230-Welcome the the Alpha Enterprises, Inc FTP Server. This server is for of
230-There is a zero tolerance rule for non-appropriate usage of this server.   
230-                                                                           
230-ALL TRANSFERS ARE LOGGED AND VIOLATORS WILL BE PROSECUTED.                 
230 User AAA logged in.                                                                                                                 
EZA1460I Command:                                                               
EZA1736I  CD /AAA/BBB                                     
EZA1701I >>> CWD /AAA/BBB                                   
250 CWD command successful.                                                     
EZA1460I Command:                                                               
EZA1736I  GET ABCtext.txt 't0AAAAA.bbb' (REPLACE             
EZA1701I >>> PORT 150,45,37,1,125,123                                           
200 PORT command successful.                                                   
EZA1701I >>> RETR ABCtext.txt                                           
150 Opening ASCII mode data connection for ABCtext.txt(530 bytes).       
226 Transfer complete.                                                         
EZA1617I 530 bytes transferred in 0.005 seconds.  Transfer rate 106.00 Kbytes/sec
EZA1460I Command:                                                               
EZA1736I  QUIT                                                                 
EZA1701I >>> QUIT

This is the transfer message am getting. I had posted only 1 record earlier. Please find the 2 records listed

Code:
=COLS> ----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
****** ***************************** Top of Data ******************************
000001  ~1 1 0 6 0 2 ; 0 9 1 6 2 ; 8 9 5 1 0 4 7 0 3 1 ; 0 0 0 0 0 0 1 ;  1 1 0

The semi-colon after 0000001 indicates start of new record.
I am not aware of the code tags that you had mentioned

Thanks
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jun 10, 2011 2:45 am    Post subject:
Reply with quote

Hello,

The info you posted has been "Code'd".

A mentioned, it will probably help if you show the data using "HEX ON". Posting the same thing from the remote may also help.

How are the files defined (i.e. mainframe file info from 3.4 - anything that is available from the remote) ?
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Fri Jun 10, 2011 2:48 am    Post subject: Reply to: How to FTP GET a file
Reply with quote

karthickrrajamani, as far as we know, that's what the data is supposed to look like. I'm not going to let this topic drag on and on just to find out that the data, not created on a mainframe, is the source of the problem, which of course it is. Bill asked for the data content IN HEX, and I concur. You need to post a hex dump of the ASCII data, as it appears on the Microsoft FTP server.
Back to top
View user's profile Send private message
karthickrrajamani

New User


Joined: 19 Aug 2008
Posts: 4
Location: Chennai

PostPosted: Fri Jun 10, 2011 2:59 am    Post subject:
Reply with quote

I do have the file sent to us from the server as it comes from a different app team. All i know is that cognos tool creates this csv file and when we receive it, we receive it with spaces in between.

The file in mainframe is defined as Fixed Block with an LRECL of 800.

My doubt would be whether a "csv" file could be the source of the issue ?
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7232

PostPosted: Fri Jun 10, 2011 3:06 am    Post subject: Reply to: How to FTP GET a file
Reply with quote

H-E-X

What do you, personally, make of the tilde? That's this thing: ~

Are you expecting that? Your second record doesn't have anything like it, but has something that "looks like space".

Try to do this, then you get the next bit.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Fri Jun 10, 2011 3:08 am    Post subject:
Reply with quote

karthickrrajamani, what are you expecting the data to look like? Are the other three semicolons in the record that you did not mention also end of record markers? If not, what distinguishes an end of record semicolon from any other semicolon (hopefully the HEX display will shed some light on that)? There's a great deal of information you did not provide -- information that is required to identify and resolve your issue (and answering the questions so far posted will probably only lead to other questions before answers).
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jun 10, 2011 3:08 am    Post subject:
Reply with quote

Hello,

As Kevin mentioned - you need to see the hex of the remote file. Once you know exactly what you are working with, some progress can be made.

One thing i do when uploading data to the mainframe is to pre-allocate the receiving file on the mainframe with the attributes i want (i.e. fb, lrecl=800).
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7232

PostPosted: Fri Jun 10, 2011 3:55 am    Post subject: Reply to: How to FTP GET a file
Reply with quote

He seems to have just wandered off (again, see his only other topic).

FB, LRECL 800. 530 bytes of data all as one record instead of individual records. No big surprise.

What about the ASCII mode for the transfer? I'd expect EBCDIC or BINARY. Yet we can read, at least some of, the data. Are we seeing the file after the transfer, or after it has been de-ASCII'd by something?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Fri Jun 10, 2011 6:07 am    Post subject:
Reply with quote

Bill, I'm thinking UTF-8, which is backward compatible with ASCII but can use 1 to 4 8-bit bytes per character.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us