View previous topic :: View next topic
|
Author |
Message |
premcitit
New User
Joined: 15 Nov 2011 Posts: 5 Location: India
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you pre-allocate the file on the mainframe with the desired attributes, then upload the data. |
|
Back to top |
|
|
premcitit
New User
Joined: 15 Nov 2011 Posts: 5 Location: India
|
|
|
|
Im sorry. Can you please elaborate this? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
I'm not sure what needs elaboration. . .
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 |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
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 |
|
|
premcitit
New User
Joined: 15 Nov 2011 Posts: 5 Location: India
|
|
|
|
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 |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
premcitit
New User
Joined: 15 Nov 2011 Posts: 5 Location: India
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
IND$FILE? (it's slow though) |
|
Back to top |
|
|
|