|
View previous topic :: View next topic
|
| Author |
Message |
Subhasis Mishra
New User
Joined: 05 Nov 2013
Posts: 3
Location: India
|
|
|
|
Hi everyone, I have this following requirement.
There is a input dataset with some records with first 3 characters being the key
Example:
| Code: |
100 Mr Andy 29 9898982344.
101 Mr Yardy B 22 8987878888
102 Mr Zuker S 34 9876543210
.
.
199 Mr Robert 44 8978654121 |
The first 3 characters are key
Next 15 characters is name
Then 2 characters for age
finally 10 characters for contact #
In my JCL user will give input as instream data like
| Code: |
//Sysin DD *
101
102
/* |
The desired output is
| Code: |
100 Mr Andy 29 9898982344 Not Processed
101 Mr Yardy B 22 8987878888 Processed
102 Mr Zuker S 34 9876543210 Processed
.
.
199 Mr Robert 44 8978654121 Not Processed |
Can anyone please help me regarding this like How to do this in JCL!!! (No Easytrieve please)
Code'd |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
| Quote: |
| Can anyone please help me regarding this like How to do this in JCL!!! |
No, as you (or i) cannot do this with JCL. The JCL must execute some program.
I suspect you will want to use your sort product. Which sort is used on your system?
You should be able to do what you want using JOINKEYS. There is info in whichever sort manual as well on this forum (found using the Search in the blue line at the top of the page). |
|
| Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
|
|
|
|
| Subhasis-kun, I advise you to use Code tags when posting anything for which alignment is important. The data you show does not match your description of it (quite aside from the alignment problem. |
|
| Back to top |
|
|
Subhasis Mishra
New User
Joined: 05 Nov 2013
Posts: 3
Location: India
|
|
|
|
Hi Akatsukami ,
sorry for the alignment problem.Next time onwards I will use the code tags.
Hi Dick scherrer ,
We can use DFSORT.
I was wondering if there is any way to do this requirement using DFSORT or ICETOOL as I am instructed to do it through JCL only and no programs.That's the reason I said no to easytrieve too. |
|
| Back to top |
|
|
magesh23586
Active User
Joined: 06 Jul 2009
Posts: 213
Location: Chennai
|
|
|
|
| You can use DFSORT Joinkeys, use OUTFIL and include condition with OVERLAY statement to add Processed or not processed. |
|
| Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 1702
Location: Australia
|
|
|
|
Hi,
| Quote: |
I was wondering if there is any way to do this requirement using DFSORT or ICETOOL as I am instructed to do it through JCL only and no programs.That's the reason I said no to easytrieve too.
|
you are ignoring what has been said
| Quote: |
No, as you (or i) cannot do this with JCL. The JCL must execute some program.
|
NO PROGRAM NO RUN
JCL is required to run a program (DFSORT ICETOOL etc)
Gerry |
|
| Back to top |
|
|
Subhasis Mishra
New User
Joined: 05 Nov 2013
Posts: 3
Location: India
|
|
|
|
Hi Magesh
Thanx for your suggestion.I will check DFSORT materials and I will try to do it using DFSORT, OUTFIL with OVERLAY statements.
Hi Gerry,No program is in the sense,I do not want to execute any cobol programs for this. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| Hi Gerry,No program is in the sense,I do not want to execute any cobol programs for this. |
It has become more common for folks with a certain background to use this terminology.
In your own circle, it may work ok.
If you want to be considered as a professional, you need to use the proper terminology, not what has become popular among the locals.
Using improper termnology gives the rest of us the impression that you either don't know or don't care about being knowledgable or wanting to learn. |
|
| Back to top |
|
|
|
|
