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

InSync compare for low values


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

New User


Joined: 04 Mar 2005
Posts: 53
Location: Newyork

PostPosted: Wed Apr 15, 2009 1:27 am
Reply with quote

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
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Wed Apr 15, 2009 1:45 am
Reply with quote

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
View user's profile Send private message
Lkmi

New User


Joined: 04 Mar 2005
Posts: 53
Location: Newyork

PostPosted: Wed Apr 15, 2009 2:01 am
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Apr 15, 2009 3:03 am
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Apr 15, 2009 3:13 am
Reply with quote

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
View user's profile Send private message
Lkmi

New User


Joined: 04 Mar 2005
Posts: 53
Location: Newyork

PostPosted: Wed Apr 15, 2009 6:22 pm
Reply with quote

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
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Wed Apr 15, 2009 9:12 pm
Reply with quote

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
View user's profile Send private message
Lkmi

New User


Joined: 04 Mar 2005
Posts: 53
Location: Newyork

PostPosted: Wed Apr 15, 2009 9:30 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Apr 15, 2009 9:34 pm
Reply with quote

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
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Wed Apr 15, 2009 10:04 pm
Reply with quote

Are these files variable length records? Are the records long enough to include the fields you are comparing on?
Back to top
View user's profile Send private message
Lkmi

New User


Joined: 04 Mar 2005
Posts: 53
Location: Newyork

PostPosted: Wed Apr 15, 2009 10:19 pm
Reply with quote

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
View user's profile Send private message
santosh_bubu

New User


Joined: 21 Oct 2009
Posts: 1
Location: India

PostPosted: Wed Oct 21, 2009 6:42 pm
Reply with quote

Hi,

Can anyone please guide me where can I find the material on Insync.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Oct 21, 2009 9:16 pm
Reply with quote

Hello and welcome to the forum,

You might start here:
www.macro4.com/solutions/A-Z-Products/InSync.aspx
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 INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts Compare two files with a key and writ... SYNCSORT 3
Search our Forums:

Back to Top