View previous topic :: View next topic
|
Author |
Message |
jmreddymca Warnings : 1 New User
Joined: 14 Oct 2007 Posts: 29 Location: Bangalore
|
|
|
|
Good morning friends,
i have 1 file which is having many fields. in that 3rd field lenth is 10bytes
i want to change the 1 digit value to some no.
ex - 507xxxxxxx
462xxxxxxx
836xxxxxxx
i want change 1st position of all the no to 1 i.e
107xxxxxxx
162xxxxxxx
137xxxxxxx
is there any commadn plz suggest me. |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Reddy,
Your IP and OP length is different (10 & 11). You want to change the file lrecl also? |
|
Back to top |
|
|
jmreddymca Warnings : 1 New User
Joined: 14 Oct 2007 Posts: 29 Location: Bangalore
|
|
|
|
no murali
just assume i have 1 file.i want to edit a particular field.
ex- fld3
r1-3214x
r2-7124x
r3-4144x
i want update this file into
ex- fld3
r1-1214x
r2-1124x
r3-1144x
here i have changed all the 1st col value to 1 by manually.in case if i have millions of recs.what to do???? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
In tso/ispf, edit your data, key
and press enter.
A seven will be placed in pos 50 in all records. Change the 7 to whatever value you want and change the 50 to whatever position you want. |
|
Back to top |
|
|
|