Page 1 of 1

Replace one entire column with sapce

PostPosted: Wed Feb 01, 2012 12:54 pm
by jvinoth
hi ,
I have a flat file in that i need to replace one entire column with sapce, can anyone tell me how to do that?

Re: Replace

PostPosted: Wed Feb 01, 2012 2:33 pm
by expat
Probably.

Are you using this forum to get your homework questions answered ?

Re: Replace

PostPosted: Wed Feb 01, 2012 2:40 pm
by jvinoth
hi expat,
If you like to give solution means give...otherwise just ignore my post k.

Re: Replace

PostPosted: Wed Feb 01, 2012 5:24 pm
by prino
If you were a poster on the forum where I'm an admin, you wouldn't be anymore.

Re: Replace

PostPosted: Wed Feb 01, 2012 5:33 pm
by Robert Sample
I have a flat file in that i need to replace one entire column with sapce, can anyone tell me how to do that?
Yes. use IEBGENER. If you do not know how to do it using IEBGENER, find the Utilities manual on the IBM web site and look it up yourself. You will learn far more by looking up the answer yourself than you would by having somebody spoon-feed you what to do.

Re: Replace

PostPosted: Wed Feb 01, 2012 6:22 pm
by jvinoth
thks robert....i think this fourm is for beginners and students...so i have doubt in that so i post got it prino::::::::::;

Re: Replace

PostPosted: Wed Feb 01, 2012 6:30 pm
by enrico-sorichetti
If you like to give solution means give...otherwise just ignore my post k.

the classic reply from a lazy spoiled kid who expects to be spoon fed and do nothing himself

being a beginner does not exempt You from doing a bit of homework ( aka researching ) Yourself and exercising Your neurons

wise to read and meditate on
DFSORT Smart tricks
http://www.ibm.com/support/docview.wss?uid=isg3T7000094

or read about sort advanced functionalities starting from
http://www.ibm.com/support/docview.wss?uid=isg3T7000079

Re: Replace

PostPosted: Wed Feb 01, 2012 7:12 pm
by Robert Sample
This forum IS for beginners and students. However, that does not excuse you from doing some work yourself. If you are unable, for any reason, to actually find the manual and look up the syntax yourself (after being told which utility to use, which is in itself a major help) -- then you need to go find a different career path, one that would not require so much effort on your part. People who succeed in IT tend to be very self-motivated to learn things and use the manuals extensively to teach themselves what they need to know.

Re: Replace one entire column with sapce

PostPosted: Wed Feb 01, 2012 11:43 pm
by Frank Yaeger
I have a flat file in that i need to replace one entire column with sapce, can anyone tell me how to do that?


If you want help when you ask a question, you need to give the details of what you want to do. Otherwise, we can only guess.

However, as an example, if you wanted to replace positions 11-14 in each input record with spaces, you could use a DFSORT job like the following:

//S1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=...  input file
//SORTOUT DD DSN=...  output file
//SYSIN DD *
   OPTION COPY
   INREC OVERLAY=(11:4X)
/*


You can change 11: and 4X to meet your needs. For example, if you just want to change position 21 to a blank, you would use 21:1X instead of 11:4X.

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

http://www.ibm.com/support/docview.wss? ... g3T7000080

Re: Replace one entire column with sapce

PostPosted: Thu Feb 02, 2012 11:39 am
by jvinoth
thank you so much frank...