Page 1 of 1

Comapring Fields in two Data set?

PostPosted: Tue Jun 23, 2009 8:53 am
by gokulNmf
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 ;)

Re: Comapring Fields in two Data set?

PostPosted: Tue Jun 23, 2009 9:40 am
by dick scherrer
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.

Re: Comapring Fields in two Data set?

PostPosted: Tue Jun 23, 2009 5:07 pm
by gokulNmf
: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

Re: Comapring Fields in two Data set?

PostPosted: Tue Jun 23, 2009 6:31 pm
by dick scherrer
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. . .

Re: Comapring Fields in two Data set?

PostPosted: Wed Jun 24, 2009 8:57 am
by gokulNmf
Thanks Dick, i :oops: will post this in Utilities..

Re: Comapring Fields in two Data set?

PostPosted: Wed Jun 24, 2009 9:05 am
by dick scherrer
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.