View previous topic :: View next topic
|
Author |
Message |
Lkmi
New User
Joined: 04 Mar 2005 Posts: 53 Location: Newyork
|
|
|
|
Iam comparing 2 files based on certain key fields. Both of the files are exactly similar when viewed seperately on Insync. but shows mismatch for a certain field when compared(insync jcl). These fields do not show any values on hex on(should be low values). does Insync cupport comparison of low or high values? |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
It would help if you could copy/paste exactly what you see when viewing your files separately, and your JCL, and be able to prove that InSync is telling you there is a mismatch. |
|
Back to top |
|
|
Lkmi
New User
Joined: 04 Mar 2005 Posts: 53 Location: Newyork
|
|
|
|
Mismatch:
Code: |
DSN1 RECORD # 502 DSN2 RECORD # 624
DATASET 1 FIELD VALUE DATASET 2 FIELD VALUE
fld1 +10000002747 +10000002747
fld2 +31021 +31021
fld3 X'0000' X'0000'
fld4 X'0000' X'0000' |
fld1 and fld2 are the keys. Though fld3 and fld4 are the same in both the files.the above mismatch is displayed.
( DSN1 RECORD # 502 - from file1 and DSN1 RECORD # 624 IS FROM FILE2)
JCL includes the compare statement
COMPARE=(FLD3,FLD3)
while viewing the files seperately, tehre are not displayable values in both teh files for these fields(both on hex-on and not hex-on). |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Please post "that part" of the records with hex on.
Every value on the mainframe is displayable with "hex on". . .
Postng the same part of the copybook will probably also help. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
posting the control cards might help, also.
don't know anything about insync,
but considering its cost,
I imagine that it works, if the control cards are correct.
if it shows that the control cards are correct, then the data is different.
the requested data from Herr Scherrer would be of benefit in helping you. |
|
Back to top |
|
|
Lkmi
New User
Joined: 04 Mar 2005 Posts: 53 Location: Newyork
|
|
|
|
Hi,
this is the display in both the files on doing a hex on. There are no characters displayed for both teh fields on doing a hex on. the previous field which is the transit number shows the hex values.
Code: |
File 1:
TRANSIT-NBR LINES-DESC CREDIT-DESC
S(9) (164-168) PS(3) (169-170) C(200) (171-370)
---------------------- ---------------------- --------------------------------
'059990000C'
'059990000C'
'059990000C'
'059990000C'
File 2:
TRANSIT-NBR LINES-DESC CREDIT-DESC
S(9) (164-168) PS(3) (169-170) C(200) (171-370)
---------------------- ---------------------- --------------------------------
'059990000C'
'059990000C'
'059990000C'
'059990000C' |
Code: |
copybook declaration:
TRANSIT-NBR PIC S9(9) COMP-3.
LINES-DESC PIC S9(3) COMP-3.
CREDIT-DESC PIC X(200). |
Code'd |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
Lkmi wrote: |
Mismatch:
Code: |
DSN1 RECORD # 502 DSN2 RECORD # 624
DATASET 1 FIELD VALUE DATASET 2 FIELD VALUE
fld1 +10000002747 +10000002747
fld2 +31021 +31021
fld3 X'0000' X'0000'
fld4 X'0000' X'0000' |
fld1 and fld2 are the keys. Though fld3 and fld4 are the same in both the files.the above mismatch is displayed.
( DSN1 RECORD # 502 - from file1 and DSN1 RECORD # 624 IS FROM FILE2)
JCL includes the compare statement
COMPARE=(FLD3,FLD3)
while viewing the files seperately, tehre are not displayable values in both teh files for these fields(both on hex-on and not hex-on). |
Where, in this posted code, does InSync tell you there is a mismatch? I think you need to post more information than you have so far. |
|
Back to top |
|
|
Lkmi
New User
Joined: 04 Mar 2005 Posts: 53 Location: Newyork
|
|
|
|
This is the report that the insync creates on running teh compares which is basically the list of mismatches between the 2 files. fld1 and fld2 are the extra keys 2 be displayed and rest would be the fields that do not match between both the files.. Though fld 3 and fl4 are similar in both teh records, the display shows that they do not match. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You need to post the actual data from those 2 records (with hex on) using standard tso/ispf rather than insync. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
Are these files variable length records? Are the records long enough to include the fields you are comparing on? |
|
Back to top |
|
|
Lkmi
New User
Joined: 04 Mar 2005 Posts: 53 Location: Newyork
|
|
|
|
Thanks for your response. The problem was due to variable length records being present in the file.
Craq,
Thanks..yes...it was the issue. |
|
Back to top |
|
|
santosh_bubu
New User
Joined: 21 Oct 2009 Posts: 1 Location: India
|
|
|
|
Hi,
Can anyone please guide me where can I find the material on Insync. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
Back to top |
|
|
|