Home > IT Answers > AS/400 > How to find out existing LF key is ascending ...
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?
ASKED: Jan 25, 2012  11:50 AM GMT
UPDATED: February 28, 2012  11:08:50 AM GMT
RELATED QUESTIONS
CharlieBrowne
24,725 pts.
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

 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
Last Wiki Answer Submitted:  Jan 25, 2012  2:03 PM (GMT)  by  CharlieBrowne   24,725 pts.
To see other 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,665 pts.
 

[...] Can’t figure out if the existing LF key is ascending or descending order?  CharlieBrown provides the [...]

The Most-Watched IT Questions: February 6, 2012 - ITKE Community Blog
 0 pts.