Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Extract first name and last name from input file

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

New User


Joined: 27 Sep 2005
Posts: 8
Location: Gurgaon

PostPosted: Wed Nov 26, 2008 2:26 am    Post subject: Extract first name and last name from input file
Reply with quote

I have an input file having first name a space followed by the last name. The max combined length is 20 char. I need to pull up the first name and store it separately to a 2nd file and extract the last name and store it separately to a 3rd file. How do I do that using a JCL/SORT?
Back to top
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2285
Location: @my desk

PostPosted: Wed Nov 26, 2008 2:30 am    Post subject:
Reply with quote

Can you post here the sort product info.(DFSORT/Syncsort) with the version nbr. See the SYSOUT of any job run to find this info.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Nov 26, 2008 2:40 am    Post subject:
Reply with quote

Kushal,

You can use a DFSORT job like the following to do what you asked for.

Code:

//S1    EXEC  PGM=ICEMAN
//SYSOUT    DD  SYSOUT=*
//SORTIN DD *
ALFRED SMITH
WILLIAM JONES
JOE PLUMBER
GEORGE WASHINGTON
/*
//OUT1 DD SYSOUT=*
//OUT2 DD SYSOUT=*
//SYSIN    DD    *
  OPTION COPY
  OUTFIL FNAMES=OUT1,
    PARSE=(%01=(ENDBEFR=C' ',FIXLEN=20)),
    BUILD=(%01)
  OUTFIL FNAMES=OUT2,
    PARSE=(%=(ENDBEFR=C' '),
           %02=(FIXLEN=20)),
    BUILD=(%02)
/*


OUT1 would have:

Code:

ALFRED   
WILLIAM   
JOE       
GEORGE   


OUT2 would have:

Code:

SMITH       
JONES       
PLUMBER     
WASHINGTON 


For complete details of DFSORT's PARSE function, see:

http://www.ibm.com/systems/support/storage/software/sort/mvs/peug/
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 Compare yesterday's date to the one o... migusd SYNCSORT 8 Fri Sep 22, 2017 11:35 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am
No new posts SORT Trailer Count - LRECL Output co... amorante DFSORT/ICETOOL 5 Tue Aug 29, 2017 8:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us