|
View previous topic :: View next topic
|
| Author |
Message |
VivekKhanna
New User
Joined: 09 Feb 2009
Posts: 57
Location: India
|
|
|
|
Hi All,
I have two datasets namely Dataset-1, Dataset-2. The details are mentioned below:
Dataset-1
| Code: |
11111111111111111111111111111111
22222222222222222222222222222222
33333333333333333333333333333333
55555555555555555555555555555555
66666666666666666666666666666666
|
Dataset-2
| Code: |
11111111111111111111111111111111
33333333333333333333333333333333
44444444444444444444444444444444
|
In output, I need two datasets:
Dataset-3 : should contain all the matching records in Dataset-1 and Dataset-2.
Dataset-4 : should contain all the non-matching records in Dataset-1 only.
Dataset-3
| Code: |
11111111111111111111111111111111
33333333333333333333333333333333
|
Dataset-4
| Code: |
22222222222222222222222222222222
55555555555555555555555555555555
66666666666666666666666666666666
|
RECTYPE=F, and LRECL=4595. |
|
| Back to top |
|
 |
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table
|
|
|
|
| Look at DFSORT Tricks Look for: Create files with matching and non-matching records.... |
|
| Back to top |
|
|
bipinpeter
Active User
.jpg)
Joined: 18 Jun 2007
Posts: 213
Location: Cochin/Kerala/India
|
|
|
|
| You can use the SORT JOIN for this... |
|
| Back to top |
|
|
smijoss
Active User
Joined: 30 Aug 2007
Posts: 114
Location: pune
|
|
|
|
| true .. a sample JCL is given in the document for join keys |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Viv,
Note that DFSORT cannot do matching on 4595 bytes. The limit is closer to 4088 bytes.
Are you trying to do the match on all 4595 bytes? Or on a specific number of bytes (give the starting posiion and length)? |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Hi Frank,
| Frank Yaeger wrote: |
| The limit is closer to 4088 bytes. |
Why do you say "closer to" - is there no definite number? |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| 4088 is the maximum, but it can be less depending on which formats are used, whether EQUALS is used, etc. |
|
| Back to top |
|
|
|
|
