IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to separate dataset with some fields only


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
hiteshkataria
Currently Banned

New User


Joined: 01 Mar 2007
Posts: 1
Location: Chennai

PostPosted: Fri Mar 02, 2007 9:10 pm
Reply with quote

I have an input file with some records whose fields are as follows

Code:

Empno     Empname     Salary     Designation
x(5)      x(10)       x(6)       x(10)


I want to get 3 output files, such that the output is
O/p file 1 : contains only empno
O/p file 2 : contains only empname
O/p file 3 : contains only salary and designation
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Fri Mar 02, 2007 9:27 pm
Reply with quote

hiteshkataria, since you're new, a few tips:

1. Not everyone speaks COBOL. It's better if you show us the actual data, and indicate to us what position a field starts in, what format it's in, and how many characters long it is.

2. You need to specify what the input dataset RECFM and LRECL is, and what you require for the output.

3. Do any of these fields need to be sorted into a specific order?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


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

PostPosted: Fri Mar 02, 2007 9:55 pm
Reply with quote

hiteshkataria,

Here's a DFSORT job that will do what you asked for:

Code:

//S1    EXEC  PGM=ICEMAN
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file (FB/31)
//OUT1 DD DSN=...  empno file (FB/5)
//OUT2 DD DSN=...  empname file (FB/10)
//OUT3 DD DSN=...  salary/designation file (FB/16)
//SYSIN    DD    *
  OPTION COPY
  OUTFIL FNAMES=OUT1,BUILD=(1,5)
  OUTFIL FNAMES=OUT2,BUILD=(6,10)
  OUTFIL FNAMES=OUT3,BUILD=(16,16)
/*
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Allocated cylinders of a dataset DB2 12
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts Reading dataset in Python - New Line ... All Other Mainframe Topics 22
Search our Forums:

Back to Top