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
 

 

Compare Files and extract matching records using ICETOOL.

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

New User


Joined: 28 Feb 2010
Posts: 21
Location: Bloomington, IL

PostPosted: Wed Jan 06, 2016 2:42 pm    Post subject: Compare Files and extract matching records using ICETOOL.
Reply with quote

Hello All,
I have a requirement to compare two files and extract records from File1.Details are below;

I have two files; File1 and File2.

File1, 80 length, FB
--------------------
Code:
HDR111
0112345P88888888 XXXA
02DGG839
02KHH452
TLR111

HDR222
0183344G77777777 TTTA
02FFK839
02LPW452
TLR222

HDR333
0183921B44444444 KKKN
02GFF839
02RER452
TLR333


File2(Report format), 133 length,FBA
-------------------------------------------
Code:
******************REPORT-ID**********************
*************************************************
    EMP-ID       DEPT-ID      STATUS
    ------       -------      ------
    77777777     83344        A


File1 contains blocks of data, where each block has its own header and trailer records. After comparing File1 and File2, I need to extract block of records from File1.
For eg: in this case, EMP-ID(77777777, starting at 5th position, Len=8) DEPT-ID(83344, starting at 20th position, Len=5) and STATUS(A,starting at 30th position, Len=1) is matching with second set of block data in File1(01 format data). So output file should be as below(same format as File1)

Output
-------
Code:
HDR222
0183344 77777777 TTTA
02FFK839
02LPW452
TLR222


We don't have SORT JOINKEY facility installed and I tried with ICETOOL by putting them together after proper formatting and then using FIRSTDUP but didn't work since it's a block of records I need to extract. Could anyone help me?

Code'd
Back to top
View user's profile Send private message

Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Wed Jan 06, 2016 3:06 pm    Post subject:
Reply with quote

Can you check here http://ibmmainframes.com/viewtopic.php?t=33389 and let us know the product and release you use?
Back to top
View user's profile Send private message
vimalravi83

New User


Joined: 28 Feb 2010
Posts: 21
Location: Bloomington, IL

PostPosted: Wed Jan 06, 2016 3:17 pm    Post subject: ICETOOL version
Reply with quote

In one of my ICETOOL joblog, I see below message ;

ICE201I 0 RECORD TYPE IS F.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7236

PostPosted: Wed Jan 06, 2016 3:40 pm    Post subject: Reply to: Compare Files and extract matching records using ICETOOL.
Reply with quote

Unfortunately that either means you are up-to-date or extremely old.

Since JOINKEYS does not work for you (are you sure? please post what you tried, the entire sysout) it would look like you are way out of date. And, if so, out of luck. Write a program.
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 Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 1 Fri Dec 09, 2016 4:40 am
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 8 Thu Dec 01, 2016 8:28 pm
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts Matching with Key at different postions. rajatbagga DFSORT/ICETOOL 12 Wed Nov 09, 2016 10:58 am
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm


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