Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

InSync compare for low values

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
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    Post subject: InSync compare for low values
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    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Wed Apr 15, 2009 3:03 am    Post subject:
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: 6968
Location: porcelain throne

PostPosted: Wed Apr 15, 2009 3:13 am    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Wed Apr 15, 2009 9:34 pm    Post subject:
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    Post subject:
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    Post subject:
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    Post subject: Insync material
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

Site Director


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

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

Hello and welcome to the forum,

You might start here:
http://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    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts BI,TO=ZD Changing Values Tyler Dunbar DFSORT/ICETOOL 1 Tue Jul 25, 2017 12:12 am
No new posts compare 2 rows within the same file ram_vizag SYNCSORT 7 Wed Jun 14, 2017 12:34 am
No new posts Sorting of hex values Saurabh_mi DFSORT/ICETOOL 11 Thu May 25, 2017 3:49 pm
No new posts member list compare jzhardy TSO/ISPF 6 Fri May 12, 2017 3:18 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us