MVSFORUMS.com :: View topic - Easytrieve - match criteria

MVSFORUMS.com
A Community of and for MVS Professionals

FAQ

Quick Manuals

Profile

Easytrieve - match criteria - order not change/sorted
Goto page Previous 1, 2

MVSFORUMS.com Forum Index -> Application Programming

View previous topic :: View next topic

Author

Message

radkrish82
Beginner

Joined: 19 Feb 2009
Posts: 50
Topics: 10

Posted: Wed Feb 08, 2012 9:04 am Post subject:

Quote:

Step0200 : Sort File-A on trans-dt,acct,branch#,group#,ind,value to another temp file and remove the dups using sum fields=none.

Kolusu, Thanks.
For AAAAAAA - branch 311,610,312 is sorted to a temporary file in the order 311,312,610 which is incorrect. It should be retained in the order.
Only branches 311 and 610 is required to be picked here. Hence it is required to be retained in the order.

Code:

acct-9(Alpha) branch# 3(PD) group# 4(PD) ind 1(Alphq) Trans-dt4(PD) value 8(PD) result# 8 (Alpha)
5-13 15-17 18-21 28-28 74-77 84-91

AAAAAAA 311 54320 A 1120130 30.00000 1517A151
AAAAAAA 311 54320 A 1120130 30.00000 1517A151
AAAAAAA 610 44121 A 1120130 30.00000 1517A152
AAAAAAA 610 44121 A 1120130 30.00000 1517A152
AAAAAAA 312 71573 A 1120130 30.00000 1517A153
AAAAAAA 312 71573 A 1120130 30.00000 1517A153

BBBBBBB 321 54321 B 1120130 30.00000 1666A155

DDDDDDD 622 71573 A 1120130 30.00000 1517A153
DDDDDDD 623 72221 A 1120130 30.00000 1517A154

CCCCCCC 611 54320 A 1120130 30.00000 AAA7A1C1
CCCCCCC 611 44121 A 1120130 30.00000 AAA7A1C2
CCCCCCC 611 44121 A 1120130 30.00000 AAA7A1C3

kolusu
Site Admin

Joined: 26 Nov 2002
Posts: 12382
Topics: 75
Location: San Jose

Posted: Wed Feb 08, 2012 12:20 pm Post subject:

radkrish82 wrote:

Quote:

Step0200 : Sort File-A on trans-dt,acct,branch#,group#,ind,value to another temp file and remove the dups using sum fields=none.

Kolusu, Thanks.
For AAAAAAA - branch 311,610,312 is sorted to a temporary file in the order 311,312,610 which is incorrect. It should be retained in the order.[/B]
Only branches 311 and 610 is required to be picked here. Hence it is required to be retained in the order.

*Sigh* if your intention is to pick only branches 311 and 610, why can't use a simple INCLUDE COND=(15,3,PD,EQ,311,OR,15,3,PD,EQ,610) ?

You are trying to make a monster out of nothing.

Kolusu

radkrish82
Beginner

Joined: 19 Feb 2009
Posts: 50
Topics: 10

Posted: Thu Feb 09, 2012 2:08 am Post subject:

Quote:

INCLUDE COND=(15,3,PD,EQ,311,OR,15,3,PD,EQ,610)

Wrong. I showed the records For acct AAAAAAA - branch 311,610,312. Request is to pick the records for first key combination and immediate key change for that account as I had mentioned earlier. I thought I had mentioned my requirement completely from the first post. Apologise if i made it otherway.

radkrish

kolusu
Site Admin

Joined: 26 Nov 2002
Posts: 12382
Topics: 75
Location: San Jose

Posted: Thu Feb 09, 2012 12:25 pm Post subject:

radkrish82, I give up. There are ways to group the records , but I guess it is a moot point to even discuss it. Good luck

Display posts from previous:

	MVSFORUMS.com Forum Index -> Application Programming	All times are GMT - 5 Hours Goto page Previous 1, 2
Page 2 of 2

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum