IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Compare only some fields of a variable file


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
gigs

New User


Joined: 08 Aug 2005
Posts: 27
Location: USA

PostPosted: Thu Jun 29, 2006 11:49 am
Reply with quote

Hi,

How to compare only some fields of a file. If the file has a variable fields and I need to skip during compare, is it posible ?

Supose a file has fields: A B C D E F G H I J K
E is variable fields occurs 100 times. I need to skip E and I fields and compare only rest of the fields.
Back to top
View user's profile Send private message
Jerry

New User


Joined: 16 Sep 2005
Posts: 42

PostPosted: Fri Jun 30, 2006 1:51 pm
Reply with quote

Hi Gigs,

Can you please elaborate your query. From what I understand, I think we can do this using Fileaid's compare feature.
Back to top
View user's profile Send private message
gigs

New User


Joined: 08 Aug 2005
Posts: 27
Location: USA

PostPosted: Fri Jun 30, 2006 5:02 pm
Reply with quote

I want to compare to two files, and only the fields of interest to me is the fields A B C D G H J and K. I don't want to compare the fields E and I.

I know that it can be done by fileaid, but I don't know it can be done.
Back to top
View user's profile Send private message
Jerry

New User


Joined: 16 Sep 2005
Posts: 42

PostPosted: Tue Jul 04, 2006 2:12 pm
Reply with quote

Hi Gigs,

By fields, do you mean you have fixed column numbers or copy book for these fields.

If I understand your question, I think you could use the compare option and then use unformatted and specify the columns and the length you want to compare.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Compare only first records of the fil... SYNCSORT 7
Search our Forums:

Back to Top