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
 

 

ICETOOL-to compare files

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

New User


Joined: 22 Jun 2007
Posts: 81
Location: bangalore

PostPosted: Tue Jul 29, 2008 10:20 am    Post subject: ICETOOL-to compare files
Reply with quote

SPLICE FROM(INPUT1) TO(OUTPUT1) ON(P,M,F) WITH(X,Y)
if the key positions are different , then how to compare two files in SPLICE option.
Back to top
View user's profile Send private message

ParagChouguley

Active User


Joined: 03 Feb 2007
Posts: 175
Location: PUNE(INDIA)

PostPosted: Tue Jul 29, 2008 10:32 am    Post subject:
Reply with quote

Quote:

if the key positions are different , then how to compare two files in SPLICE option.

You will have to arrange the keys on common location.
Useually, we do following.
Copy file A to a temporary MOD file (say TEMP1)
Copy file B to same temporary file TEMP1, rearranging the fields to have key in file B to appear at same location as of key of file A.

A programer has to identify a location in TEMP file at which keys from both the files can be arranged !
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Tue Jul 29, 2008 11:40 am    Post subject: Reply to: ICETOOL-to compare files
Reply with quote

Jan,

Quote:
SPLICE FROM(INPUT1) TO(OUTPUT1) ON(P,M,F) WITH(X,Y)
if the key positions are different , then how to compare two files in SPLICE option.


what actually is your requirement? If this is for your understanding then parag's post would do.

Also refer to the manuals to know more about SPLICE.
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: Tue Jul 29, 2008 9:42 pm    Post subject:
Reply with quote

janmejay,

There are many ways to use SPLICE. How exactly you would use it depends on what you're trying to do. If you need more specific help, show an example of the records in your input files (relevant fields only) and what you expect for the output records. If input file1 has duplicates within it, show that in your example. If input file2 has duplicates, show that in your example. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files.

If you want to try to figure it out yourself, see the DFSORT documentation on SPLICE at:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/6.13?DT=20060615185603

and the SPLICE examples at:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/6.13.2?DT=20060615185603
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 member list compare jzhardy TSO/ISPF 6 Fri May 12, 2017 3:18 pm
No new posts Using ICETOOL, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm


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