How to find out existing LF key is ascending or descending order?

130 pts.
Tags:
AS/400
How to find out existing LF key is ascending or descending order?

Answer Wiki

Thanks. We'll let you know when a new response is added.

DSPFD yourfile
Scan for Key Fields
You will see something like this.
NOTE: The first field is in DESCENDING and the others are ASCENDING
<pre>
Key field . . . . . . . . . . . . . . . . : CHGEOMDATE
Sequence . . . . . . . . . . . . . . . : Descending
Sign specified . . . . . . . . . . . . : UNSIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Key field . . . . . . . . . . . . . . . . : CHGFINO
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : UNSIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Key field . . . . . . . . . . . . . . . . : CHGPRDCODE
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : UNSIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No</pre>

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • pdsathishkumar
    i can't get your points.... if you assign key field in PF, it ll access the record using keyed access path... otherwise it ll assign in arrival sequence access path... Arrival sequence access path don't perform ascending or descending.. Keyed access path can perform that operation while you try to read records using program.
    3,790 pointsBadges:
    report
  • The Most-Watched IT Questions: February 6, 2012 - ITKE Community Blog
    [...] Can’t figure out if the existing LF key is ascending or descending order?  CharlieBrown provides the [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: