Home > IT Answers > AS/400 > How to find out existing LF key is ascending or descending order?
SMisar
130 pts.
 How to find out existing LF key is ascending or descending order?
AS/400
How to find out existing LF key is ascending or descending order?

Software/Hardware used:
ASKED: January 25, 2012  11:50 AM
UPDATED: February 28, 2012  11:08 AM
RELATED QUESTIONS
Answer Wiki:
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>
Last Wiki Answer Submitted:  January 25, 2012  2:03 pm  by  CharlieBrowne   32,825 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,825 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

pdsathishkumar
 3,740 pts.