Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Editing dataset based on instream data using JCL only

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Subhasis Mishra

New User


Joined: 05 Nov 2013
Posts: 3
Location: India

PostPosted: Wed Nov 06, 2013 12:29 am    Post subject: Editing dataset based on instream data using JCL only
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Nov 06, 2013 12:45 am    Post subject:
Reply with quote

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
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Wed Nov 06, 2013 12:55 am    Post subject:
Reply with quote

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
View user's profile Send private message
Subhasis Mishra

New User


Joined: 05 Nov 2013
Posts: 3
Location: India

PostPosted: Wed Nov 06, 2013 9:22 am    Post subject:
Reply with quote

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
View user's profile Send private message
magesh23586

Active User


Joined: 06 Jul 2009
Posts: 158
Location: Chennai

PostPosted: Wed Nov 06, 2013 9:32 am    Post subject: Reply to: Editing dataset based on instream data using JCL o
Reply with quote

You can use DFSORT Joinkeys, use OUTFIL and include condition with OVERLAY statement to add Processed or not processed.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Wed Nov 06, 2013 10:03 am    Post subject:
Reply with quote

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
View user's profile Send private message
Subhasis Mishra

New User


Joined: 05 Nov 2013
Posts: 3
Location: India

PostPosted: Wed Nov 06, 2013 10:41 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Nov 06, 2013 10:43 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 0 Tue Dec 06, 2016 4:38 am
No new posts How to move a long alphanumeric data ... lind sh COBOL Programming 5 Mon Dec 05, 2016 7:51 pm
No new posts FTP - JCL failed while passing FTP co... Suneetha1612 JCL & VSAM 12 Wed Nov 16, 2016 7:33 pm
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us