MVSFORUMS.com

[mainframemouli]

example


KEY DATA NAME POSITIONS LNG

PPKK1 PPK01-KR-NO 037-040 4

PPK01-KR-SUFFIX 041-043 3

PPKK2 PPK01-PO-NO 051-054 4

PPK01-KR-NO 037-040 4

PPK01-KR-SUFFIX 041-043 3


In PPKK2

if PPK01-KR-NO and PPK01-KR-SUFFIX doesn't have proper values and

PPK01-PO-NO is having the value will it be fetching the correct record???????


can anyone pls calrify this.

[kolusu]

Mainframemouli,

You need to show us your SELECT statement that is used to fetch the rows from the table.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[mainframemouli]

Mr.Kolusu , This question is for Datacomm not for DB2 any how i will give the statements before the DBNTRY call

MOVE SPACE TO APK-FOUND-SWT.

MOVE REDKL TO DB-CMD-PPK.
MOVE 'PPK' TO DB-FILE-PPK.
MOVE 'PPKK2' TO DB-KEYNA-PPK.
MOVE SPACE TO DB-ELEMENTS-PPK.
MOVE 'PPK00 APK01 APK02' TO DB-ELEMENTS-PPK.
MOVE HIGH-VALUES TO DB-PPKK2.
MOVE POH-PO-NBR TO DB-PPKK2-PO-NO.


Now PPKK2 has three Keys with if the values in two keys are not having proper value and the Third one is having the proper value will it fetch a correct record????????????????/

[bstillwa]

This depends upon the sequence of the key fields.
If key PPKK2 consists of the following fields in this stated sequence (which is not clear in the "example"):
PPK01-PO-NO
KR-NO
KR-SUFFIX
Since high values were moved to the key and
since the command is "read key less than or equal to" then
any record with key field equal to "POH-PO-NBR" and the other key fields less than or equal to high values will be returned.
_________________
Bev.

[bstillwa]

A clarification:
any record with a key field LESS THAN OR equal to "POH-PO-NBR" and the other key fields less than or equal to high values will be returned.
_________________
Bev.

[kolusu]

[mainframemouli]

Mr.Kolusu i will agree with you , i might have posted with more clarity.
i will stick to what u have said.

Yes its fetching the record for the corresponding POH-PO-NBR as they said.