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?
ASKED: January 25, 2012  11:50 AM
UPDATED: February 28, 2012  11:08 AM

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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
  • SMisar
    [...] 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following