Re:

[Padman Kumar <padmancp@xxxxxxxxxxxxx>]

thanks dave khan,

        what u've suggest i have already tried and it is working fine.i want
to know  the reason behind this that why u can't chain on two different keys
which u've defined in physical file.

        thanks for u're beautiful clarification on this context.now i am
very well understood the cause behind this.thanks once again

see u
padman

At 07:16 PM 2/19/99, you wrote:
>Say your physical file is called PADMAN and it was keyed by FIELDA. You
>wanted to be able to access it either by FIELDA or FIELDB. So you defined
>FIELDB as an additional key within PADMAN. You now have a single access
>path using a compound key. When you want to read by FIELDA you move a value
>to FIELDA and use FIELDA to chain to PADMAN. It works.  :-)  Now you want
>to read by FIELDB so you move a value to FIELDB and use FIELDB to chain to
>PADMAN. It doesn't work because the program thinks you want to use the
>value in FIELDB as a partial key to access PADMAN through its single access
>path. As you've used a single field in the chain it assumes you want to use
>the first key field, which is FIELDA, not FIELDB.  :-(
>
>What you need to do is to put PADMAN back the way it was, with only FIELDA
>as a key field. Next define a logical file PADMANL1 specifying PADMAN as
>its PFILE, and with FIELDB as the key field. Define both files in your
>program. When you want to read by FIELDA use PADMAN. When you want to read
>by FIELDB use PADMANL1.
>
>Dave Kahn, ABB Steward Ltd.
>
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---
>
>
_____________________________________________________________________
CH.PADMAN KUMAR(mailto:padmancp@wipsys.ge.com)
______________________________________________________________________ 
                                      

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---