records fetched in alphabatical order

[kishor]

Hi,

I have a PF
DDS

                                            UNIQUE
                R RCOUNTRY                        
                  CNTRYNAME     20                
                K CNTRYNAME

inserted records in some random order, but while retrieving records in program they are coming in alphabetical order.

anyone know the reason??

Thanks

[B.Hauser]

Re: records fetched in alphabatical order

Since there is a key defined on CTRYNAME within the DDS description.
... And I assume you used keyed Access in your program (Check for K in your F-Specs).

Birgitta

[GLS400]

Re: records fetched in alphabatical order

Hi Kishor:

If you are using SQL you need an ORDER BY statement.
Even though the file is keyed SQL will pick the best access path.

Best of Luck
GLS