Re: Key in a Join File

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

-----Original Message-----
From: Oscar Barber <barberao@yahoo.es>
To: RPG400-L@midrange.com <RPG400-L@midrange.com>
Date: Monday, October 29, 2001 8:39 AM
Subject: Key in a Join File


>I have done a join file and I need to order it by field PSDODT. Can anybody
tell me how to do it?

put in a K spec


>This is the DDS of my join file:
>
>A                                      JDFTVAL
>A          R RJVAT               JFILE(SROVAT SRODTA)
>A          J                           JOIN(SROVAT SRODTA)
>A                                      JFLD(PSREFX DTREFX)
>A* SROVAT FIELDS
>A            PSDODT    R
>A            PSSTAT    R
>A*SRODTA FIELDS
>A            DTREFX    R
>A            DTCUNO   R


A    K psdodt

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman