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
 

 

FTP a txt file to Mainframe

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

New User


Joined: 15 Nov 2011
Posts: 5
Location: India

PostPosted: Fri Apr 20, 2012 9:42 pm    Post subject: FTP a txt file to Mainframe
Reply with quote

Hi,

I transfered a txt file (having data under 7 columns) to mainframe as a flat file. When i viewed that flat file I noticed that the last 2 columns are appending at the bottom of the file. What should I do to make the last 2 columns to load after column 5?
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 Apr 20, 2012 9:51 pm    Post subject:
Reply with quote

Hello,

Suggest you pre-allocate the file on the mainframe with the desired attributes, then upload the data.
Back to top
View user's profile Send private message
premcitit

New User


Joined: 15 Nov 2011
Posts: 5
Location: India

PostPosted: Fri Apr 20, 2012 10:01 pm    Post subject:
Reply with quote

Im sorry. Can you please elaborate this?
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 Apr 20, 2012 10:17 pm    Post subject:
Reply with quote

Hello,

I'm not sure what needs elaboration. . . icon_confused.gif

By jcl or in tso/ispf allocate a file with the proper attributes (recfm, lrecl. space, etc). This should be the same dsn as is specified in the ftp process.

Run the ftp to upload the data into this file.
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 Apr 20, 2012 10:18 pm    Post subject: Reply to: FTP a txt file to Mainframe
Reply with quote

I don't suppose you could post an exact copy of the data (in hex) from the system you're sending FROM so maybe we might be able to make an educated guess?
Back to top
View user's profile Send private message
premcitit

New User


Joined: 15 Nov 2011
Posts: 5
Location: India

PostPosted: Fri Apr 20, 2012 11:02 pm    Post subject:
Reply with quote

Thanks you all. I can understand. But if we create a file and then load the data the time spending on this will be more time. If this could be fixed with some other option that wouldnt take much time will be very much helpful.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Fri Apr 20, 2012 11:11 pm    Post subject:
Reply with quote

premcitit wrote:
Thanks you all. I can understand. But if we create a file and then load the data the time spending on this will be more time. If this could be fixed with some other option that wouldnt take much time will be very much helpful.

Is your batch window really so tight that adding an IDCAMS step to one job would be ruinous?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Fri Apr 20, 2012 11:26 pm    Post subject: Reply to: FTP a txt file to Mainframe
Reply with quote

the description alone is not enough to provide any help.
if You are not able/willing to provide the info we ask,
then YOU are just wasting OUR time
Back to top
View user's profile Send private message
premcitit

New User


Joined: 15 Nov 2011
Posts: 5
Location: India

PostPosted: Fri Apr 20, 2012 11:35 pm    Post subject:
Reply with quote

If I do so I need to include an ftp step to load the data from the local to mainframe for which Im working to make my machine an FTP server. Thank you :-)
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: Sat Apr 21, 2012 12:04 am    Post subject:
Reply with quote

Hello,

Quote:
But if we create a file and then load the data the time spending on this will be more time.
Well, it could take "more" time, but i suspect it would be so little more that it would be nearly impossible to measure. . .
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Sat Apr 21, 2012 12:16 am    Post subject:
Reply with quote

premcitit, it is obvious that this forum is too advanced for you. Please go to the Beginner's and Students Forum instead of this one. You have a better chance of getting help there, although from the tone of your posts in this thread, I doubt that they will be able to help you as much as you need, either, since it appears that you know nothing about mainframes, nor JCL, nor data sets, nor FTP.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Apr 25, 2012 3:47 pm    Post subject:
Reply with quote

IND$FILE? (it's slow though)
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
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 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


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