Posted: Tue Jul 21, 2009 8:09 pm Post subject: Replacing characters Using JCL
I wanted to convert some specific set of characters to some other characters in the given dataset using JCL.is it possible to do ?
Like I have dataset File1 which can have some special character for example $ now i want to convert all the $ sign with S in the dataset also i have file 2 which consists of this special character mapped with the new character.
Can i do it using JCL.Its urgent Pls reply soon if someone have idea about this.
Joined: 18 Feb 2006 Posts: 812 Location: San Jose, CA
Posted: Tue Jul 21, 2009 9:36 pm Post subject:
It's not clear what you want to do.
Please show an example of the records in each input file and what you expect for output. Explain the "rules" for getting from input to output. Give the RECFM and LRECL of the input file. Give the starting position, length and format of all relevant fields. _________________ Frank Yaeger - DFSORT Development Team (IBM) - email@example.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
Now i have created a dataset using a program.Now any of these fields can have some characters other than A-Z or 0-9 for example Name field can have a value as $id.
Now I have one more dataset which as record layout as follows:
1)Special char PIC X(1)
2)Actual char PIC X(1)
Now this file give me the corresponding character which should replace the special char from first file.
For example above I have given an example that Name field can have value $id.Now I have to replace this $ with some other value which is defined in file 2.
Likewise i have to it for all such special character appearing in my file1 with cooresponding character defined in file2.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum