Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
GDG Comparisons using ICETOOL.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL IBM Manuals
Quick References
View previous topic :: :: View next topic  
Author Message
avina

New User


Joined: 04 Dec 2007
Posts: 16
Location: Kolkata
PostPosted: Wed Feb 13, 2013 1:47 am    Post subject: GDG Comparisons using ICETOOL.
 Reply with quote
Hi,

I've 2 GDG generations and I want to compare the GDG versions and check for any new data. Please suggest an easy way using ICETOOL.

My GDG are of length 176 and I've three key fields as below (column postion and the lenght of the key).

PART_NO (1 : 18)

SUPPLIER_NO (31 :6)

DC_PART_NO (159: 18)

Many thanks.

Regards,
Avik.
Back to top
View user's profile Send private message

enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10648
Location: italy
PostPosted: Wed Feb 13, 2013 1:58 am    Post subject: Reply to: GDG Comparisons using ICETOOL.
 Reply with quote
the fact that You are dealing with GDG generations is irrelevant to the comparison

did You search the forums , there are gazillions of topics dealing with dataset comparison using JOINKEYS

take a shot at searching icon_biggrin.gif
Back to top
View user's profile Send private message
avina

New User


Joined: 04 Dec 2007
Posts: 16
Location: Kolkata
PostPosted: Wed Feb 13, 2013 2:46 am    Post subject:
Reply with quote
Thanks Enrico, but still can you show a simple way out.
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose
PostPosted: Wed Feb 13, 2013 3:20 am    Post subject:
Reply with quote
avina wrote:
Thanks Enrico, but still can you show a simple way out.


avina,

Simple way is to look at the examples of using JOINKEYS for various matching applications. Check Smart DFSORT Trick "Create files with matching and non-matching records" at:

http://www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094

I guess you are looking for much simpler version like complete job. And here it is

Assuming that there is no need to normalize any of the comparision keys, the following DFSORT JCL will give you the desired results, which will write out any unmatched records from current generation.

Code:

//STEP0100 EXEC PGM=SORT                           
//SYSOUT   DD SYSOUT=*                             
//CURR     DD DISP=SHR,DSN=Your.GDG.Base(0)   <<< Current gdg generation
//PREV     DD DISP=SHR,DSN=Your.GDG.Base(-1)  <<< yesterday's gdg generation
//SORTOUT  DD SYSOUT=*                             
//SYSIN    DD *                                     
  OPTION COPY                                       
  JOINKEYS F1=CURR,FIELDS=(1,18,A,31,6,A,159,18,A) 
  JOINKEYS F2=PREV,FIELDS=(1,18,A,31,6,A,159,18,A) 
  JOIN UNPAIRED,F1,ONLY                             
//*
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10648
Location: italy
PostPosted: Wed Feb 13, 2013 3:24 am    Post subject: Reply to: GDG Comparisons using ICETOOL.
 Reply with quote
Quote:
but still can you show a simple way out.


dumb of me ...
I should have imagined that the sentence meant ...
I am too lazy to do it, i' ll just wait for somebody to give me a working and tested solution icon_cool.gif
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 Using ICETOOL set return code as per ... Bhuvana Narasimhan DFSORT/ICETOOL 4 Fri Jan 24, 2020 12:58 pm
No new posts ICETOOL Sorting and Discarding DUPS Harold Barnes SYNCSORT 11 Sat Dec 14, 2019 5:55 am
No new posts ICETOOL - Finding keys within a file nartcr DFSORT/ICETOOL 10 Mon Sep 17, 2018 6:39 am
No new posts ICETOOL - RESIZE DYNAMICALLY kranthikumarb DFSORT/ICETOOL 0 Tue Nov 21, 2017 5:30 pm
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm

Facebook
© 2003-2017 IBM MAINFRAME Software Support Division Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us