MVSFORUMS.com

[tattva]

IDX-1 ----> Table 1

IDX-2 -----> Table 2

IDX-2 is fetched from an internal table and is a constant value.

the problem that i am facing now is ..

i'm loadng idx-1 table through a fetch from DB2. here whats happening is

am getting multiple rows for CUST-NUM( table 1).

so while doing a Binary search on the IDX-1 table, the results are not as expected... Now all i want to know is how do i tune my DB2 query

Hope have made my self clear .......


TIA
-----
Tattva

[slade]

Hi Tattva,

It might be a good idea to provide the DECLARE CURSOR stmt.

If you could answer these ques, it might help in resolving your problem:

1) Is the CURSOR used for other purposes than using dia-num?

2) Is the CURSOR the "controling file" for your pgm?

3) Do the multiple rows for the same CUST-NUM contain different dia-num?

BTW, I assume that the CUST-NUMs for tbl 1 & 2 have different datanames. What are they?
_________________
Regards, Jack.

"A problem well stated is a problem half solved" -- Charles F. Kettering