Comapring Fields in two Data set?



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Comapring Fields in two Data set?

Postby gokulNmf » Tue Jun 23, 2009 8:53 am

Hi !
I have 2 datasets and i want to comapre the field present in one data set with another fields in another data set :? .
Is it possible to do that :?:


Thanks in Advance ;)
Cheers,
Gokul
User avatar
gokulNmf
 
Posts: 114
Joined: Sat Mar 28, 2009 6:41 pm
Location: India
Has thanked: 0 time
Been thanked: 0 time

Re: Comapring Fields in two Data set?

 

Re: Comapring Fields in two Data set?

Postby dick scherrer » Tue Jun 23, 2009 9:40 am

Hello,

It probably is possible, but no one will be able to offer much help with the lack info posted. . .

Show some example input from the 2 files (a few records form each should be enough), what you want to compare, and what you want for output when the sample input is compared.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Comapring Fields in two Data set?

Postby gokulNmf » Tue Jun 23, 2009 5:07 pm

:oops: ... sorry !!!
here is what i want to do :?: :? ..
----------------------------------------------------------------------------------
i have 2 DS(data set), each havin 3 fields
DS1
fld1 fld2 fld3
----- ------ -----
01 NAME1 10
02 NAME2 13
03 NAME3 08
04 NAME4 16

DS2
fld1 fld2 fld4
----- ------ -----
01 NAME1 M
02 NAME5 F
03 NAME6 M
04 NAME2 F


IF THE FLD2 OF BOTH (DS1 AND DS2) ARE SAME I WANT TO WRITE THE RECORD FROM DS1 INTO ANOTHER DS3.
DS3
fld1..... fld2.... fld3
------- -------- -----------
NAME1 10 M
NAME2 13 F
Cheers,
Gokul
User avatar
gokulNmf
 
Posts: 114
Joined: Sat Mar 28, 2009 6:41 pm
Location: India
Has thanked: 0 time
Been thanked: 0 time

Re: Comapring Fields in two Data set?

Postby dick scherrer » Tue Jun 23, 2009 6:31 pm

Hello,

What about duplicates in field 1 of either file? What about missing values in field 1 of either file?

What are the recfm and lrecl of the 3 files?

Which sort product is used on your system? Which release of the sort (the informational output frrom a sort will show this or you could ask your tech support people).

This is not a jcl question, it is a utility question. JCL has little to do with this requirement. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Comapring Fields in two Data set?

Postby gokulNmf » Wed Jun 24, 2009 8:57 am

Thanks Dick, i :oops: will post this in Utilities..
Cheers,
Gokul
User avatar
gokulNmf
 
Posts: 114
Joined: Sat Mar 28, 2009 6:41 pm
Location: India
Has thanked: 0 time
Been thanked: 0 time

Re: Comapring Fields in two Data set?

Postby dick scherrer » Wed Jun 24, 2009 9:05 am

Hello,

I can re-locate your topic, but you need to post which sort product is being used (as well as the other requested info).

There are different parts of the forum for DFSORT and Syncsort.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post