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
 

 

GDG Comparisons using ICETOOL.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
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, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts Group elements using ICETOOL Learncoholic DFSORT/ICETOOL 2 Fri Apr 14, 2017 11:01 am
No new posts Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts ICETOOL/SYNCSORT - SYSPRINT output nartcr DFSORT/ICETOOL 17 Wed Oct 05, 2016 10:46 pm


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