View previous topic :: View next topic |
Author |
Message |
sumithar Beginner
Joined: 22 Sep 2006 Posts: 84 Topics: 29
|
Posted: Fri Mar 16, 2012 8:47 am Post subject: Rexx compare timestamps DBRM |
|
|
I need to compare the timestamps of all the DBRM members in 2 datasets.
I've a working knowledge of REXX. So I know enough to get a member list from the 1st dataset and then trawl thru it member-by-member and then open the matching member in the 2nd dataset and so on.
The DBRM is an FB80 dataset. I also know (at least I think so) that timestamp always starts at position 25 and is 8 bytes long. But it's not really a text field.
Is it still as simple as reading the 1st line of the file, reading the 1st line of the matching member in the 2nd file and then comparing the substring from the 25th thru the 33rd positions?
Thanks! |
|
Back to top |
|
|
dbzTHEdinosauer Supermod
Joined: 20 Oct 2006 Posts: 1411 Topics: 26 Location: germany
|
Posted: Fri Mar 16, 2012 8:54 am Post subject: |
|
|
if one was generated under the old ebcidc and the second was generated under UTF-8 you could not do it.
but, seems a waste to write a rexx script when a superc compare (ISPF option 3.1?) of the two pds's would suffice.
use the option that only outputs statistics.
if the timestamps are the same, that means the complete dbrm is the same.
use the utility and forget the rexx. _________________ Dick Brenholtz
American living in Varel, Germany |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12375 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
sumithar Beginner
Joined: 22 Sep 2006 Posts: 84 Topics: 29
|
Posted: Fri Mar 16, 2012 3:10 pm Post subject: |
|
|
dbzTHEdinosauer wrote: | if one was generated under the old ebcidc and the second was generated under UTF-8 you could not do it.
but, seems a waste to write a rexx script when a superc compare (ISPF option 3.1?) of the two pds's would suffice.
use the option that only outputs statistics.
if the timestamps are the same, that means the complete dbrm is the same.
use the utility and forget the rexx. |
All I can tell myself is, Duh! And the resultant listing very conveniently puts a ** as the first 2 chars of each line where members are different!
Thanks! |
|
Back to top |
|
|
sumithar Beginner
Joined: 22 Sep 2006 Posts: 84 Topics: 29
|
Posted: Fri Mar 16, 2012 3:35 pm Post subject: |
|
|
Hi,
Thanks, interesting utility. The link you included had only the exec, but I found the panel and messages here
http://www.idug.org/p/do/sd/sid=686&type=0 (needs IDUG logon). |
|
Back to top |
|
|
|
|