Compare a column in two different datasets

hiravibk · Active User Joined: 14 Dec 2008 Posts: 107 Location: India

Hi All,

Is it possible using file manager to compare two datasets for a particular position in both the files?
Example: I have two datasets FILEA and FILEB. I want to compare both the datasets for data on 10th position in both the files only.

Regards

chandracdac · New User Joined: 15 Jun 2007 Posts: 92 Location: bangalore

Hi

you don't need file aid to do this. we can do this by normal 3.13 option.
In 3.13 on top of the screen we can options, place the cursor over there and hit enter then we can see some options there. select edit statements there... give the starting and end column there...

example
Examples Explanation
CMPCOLM 5:60 75:90 Compare using two column compare ranges
LSTCOLM 25:90 List columns 25:90 from input
DPLINE 'PAGE ' Exclude line if "PAGE " found anywhere on line
SELECT MEM1,NMEM2:OMEM2 Compare MEM1 with MEM1 and NMEM2 with OMEM2
CMPLINE NTOP 'MACRO' Start comparing after string found in new DSN
LNCT 66 Set lines per page to 66

Nic Clouston · Posted: Tue Mar 22, 2011 7:10 pm

I do not know if you can do this using File Manager but the first place I would try is the 'help' key - usually F1 or PF1. The second place would be the manual. The last place to go is a forum.

Jitendra kushwah · New User Joined: 22 Jul 2009 Posts: 3 Location: Delhi

Through ICETOOL you can compare the two files.i think you can also comapre file via file aid.

Anuj Dhawan · Posted: Wed Mar 23, 2011 1:44 pm