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
 

 

To make the output file using three input files

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
comp_ashok

New User


Joined: 30 Nov 2007
Posts: 15
Location: India

PostPosted: Wed Dec 12, 2007 10:15 am    Post subject: To make the output file using three input files
Reply with quote

input file1: account no- col 2 to 5 pic(4), amount- col 10 to 12 ,pic(3)

12222abcd600xyz
2dfsdjgfsjopgopgg
2sadhgjdfgudgjgid
13333ghij250abc
12222uhki500dxc
14444ghyt900sxz
22222abcd2001on
13333kilo750olk

input file2: account no- col 2 to 5 pic(4), amount- col 6 to 9 ,pic(3)

122221600xyz
2dfsdjgfsjopgopgg
2sadhgjdfgudgjgid
133332250abc
122223500dxc
144449900sxz
22222abcd2001on
133330750olk


input file3: account no- col 2 to 5 pic(4), amount- col 10 to 12 ,pic(3)

16666abcd600xyz
2dfsdjgfsjopgopgg
2sadhgjdfgudgjgid
17777ghij250abc
12222uhki500dxc
14444ghyt900sxz
26666abcd2001on
15555kilo750olk


output file should be?
account no | field of file1 | field of file2 | field of file3
pic 9(10) | pic? | pic ? | pic ?

pic clausa is to identify for ? .


Specifications:

1) select only those records which have 1 in the first byte
2) output file should be ksds with account no as key
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: Thu Dec 13, 2007 12:22 am    Post subject:
Reply with quote

It's not clear what you want.

Quote:
input file2: account no- col 2 to 5 pic(4), amount- col 6 to 9 ,pic(3)


6-9 is 4 columns but you have pic(3) - is it 7-9?

Quote:
output file should be?
account no | field of file1 | field of file2 | field of file3
pic 9(10) | pic? | pic ? | pic ?

pic clausa is to identify for ? .


I have no idea what this means.

Please show the expected output records for your example input records.

What is the RECFM and LRECL of each input file?
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 1 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 3 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm


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