MVSFORUMS.com

mf_user · Intermediate Joined: 01 Jun 2003 Posts: 372 Topics: 105

Hi,

I searched the DB2/IMS part to find out how duplicate rows can be processed programatically that came out of an UNION ALL. But, I could not found the relavant info.

A COBOL-DB2 program combines two select statments with UNION ALL. The requirement is to process the duplicates also. Surprised

How to achieve it?

Please explain.

TIA.......

_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==

kolusu · Posted: Mon Mar 06, 2006 9:35 am Post subject:

mf_user,

Processing duplicate rows is one of the simplest task. define a working storage variable to hold the previous key

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

mf_user,
Since the requirement is to process all rows(including dups) what difference does it make. your program logic must be built to handle it. You are making us 'guess' specific program requirements. thanks

mf_user · Intermediate Joined: 01 Jun 2003 Posts: 372 Topics: 105

Kolusu Thank you very much for the idea.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==