Replace one entire column with sapce



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Replace one entire column with sapce

Postby jvinoth » Wed Feb 01, 2012 12:54 pm

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?
jvinoth
 
Posts: 132
Joined: Fri Nov 18, 2011 3:13 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Replace

Postby expat » Wed Feb 01, 2012 2:33 pm

Probably.

Are you using this forum to get your homework questions answered ?
expat
 
Posts: 459
Joined: Sat Jun 09, 2007 3:21 pm
Has thanked: 0 time
Been thanked: 8 times

Re: Replace

Postby jvinoth » Wed Feb 01, 2012 2:40 pm

hi expat,
If you like to give solution means give...otherwise just ignore my post k.
jvinoth
 
Posts: 132
Joined: Fri Nov 18, 2011 3:13 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Replace

Postby prino » Wed Feb 01, 2012 5:24 pm

If you were a poster on the forum where I'm an admin, you wouldn't be anymore.
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 635
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 28 times

Re: Replace

Postby Robert Sample » Wed Feb 01, 2012 5:33 pm

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.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Replace

Postby jvinoth » Wed Feb 01, 2012 6:22 pm

thks robert....i think this fourm is for beginners and students...so i have doubt in that so i post got it prino::::::::::;
jvinoth
 
Posts: 132
Joined: Fri Nov 18, 2011 3:13 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Replace

Postby enrico-sorichetti » Wed Feb 01, 2012 6:30 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Replace

Postby Robert Sample » Wed Feb 01, 2012 7:12 pm

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.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Replace one entire column with sapce

Postby Frank Yaeger » Wed Feb 01, 2012 11:43 pm

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
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Replace one entire column with sapce

Postby jvinoth » Thu Feb 02, 2012 11:39 am

thank you so much frank...
jvinoth
 
Posts: 132
Joined: Fri Nov 18, 2011 3:13 pm
Has thanked: 0 time
Been thanked: 1 time


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post