about join lf

[mamata]

hi
can anybody tell me how to join 4 files in join logical file?



thanks

mamata

[Zdenko]

Re: about join lf

Hi

Here are 5 files joined:

A          R JNDKOL1S                  JFILE(DVESTO4 NDKOL1 +  
A                                      DMDKUP MAVEST MAVEST)   
A          J                           JOIN(1 2)               
A                                      JFLD(MDART ART)         
A          J                           JOIN(1 3)               
A                                      JFLD(MDDOB6 MKSIF)      
A          J                           JOIN(1 4)               
A                                      JFLD(MDSOR XSSOR1)      
A                                      JFLD(MDZAC XVST1)       
A          J                           JOIN(1 5)               
A                                      JFLD(MDSOR XSSOR2)      
A                                      JFLD(MDKON XVST2)       
A            MDDOB6                                            
A            MKNAZ1                                            
A            MDART                                             
A            ART                N                              
A            MDTSA                                             
A            MDTSAX                                            
A            XSSOR1             N      JREF(4) RENAME(SSOR)    
A            XVST1          2S 0N      JREF(4) RENAME(VST)     
A            ZAC                       JREF(4) RENAME(VSTNAZ) 
A            XSSOR2             N      JREF(5) RENAME(SSOR)   
A            XVST2          2S 0N      JREF(5) RENAME(VST)    
A            KON                       JREF(5) RENAME(VSTNAZ) 
A            PARI                      RENAME(PARIX)          
A            MDZAC              N                             
A            MDKON              N                             
A            MDSOR              N                             
A            MDSEZ                                            
A          K MDSEZ                                            
A          K MDART

[mamata]

Re: about join lf

hello
i have done it but
it gives me error like:
1 join keyword required.
2. number of join specification not same order as files on jfile
3. to-files on join keyword.
why this is so?
mamata

Hi

Here are 5 files joined:

A          R JNDKOL1S                  JFILE(DVESTO4 NDKOL1 +  
A                                      DMDKUP MAVEST MAVEST)   
A          J                           JOIN(1 2)               
A                                      JFLD(MDART ART)         
A          J                           JOIN(1 3)               
A                                      JFLD(MDDOB6 MKSIF)      
A          J                           JOIN(1 4)               
A                                      JFLD(MDSOR XSSOR1)      
A                                      JFLD(MDZAC XVST1)       
A          J                           JOIN(1 5)               
A                                      JFLD(MDSOR XSSOR2)      
A                                      JFLD(MDKON XVST2)       
A            MDDOB6                                            
A            MKNAZ1                                            
A            MDART                                             
A            ART                N                              
A            MDTSA                                             
A            MDTSAX                                            
A            XSSOR1             N      JREF(4) RENAME(SSOR)    
A            XVST1          2S 0N      JREF(4) RENAME(VST)     
A            ZAC                       JREF(4) RENAME(VSTNAZ) 
A            XSSOR2             N      JREF(5) RENAME(SSOR)   
A            XVST2          2S 0N      JREF(5) RENAME(VST)    
A            KON                       JREF(5) RENAME(VSTNAZ) 
A            PARI                      RENAME(PARIX)          
A            MDZAC              N                             
A            MDKON              N                             
A            MDSOR              N                             
A            MDSEZ                                            
A          K MDSEZ                                            
A          K MDART

[mamata]

Re: about join lf

i got the answer

[karthikbellare]

Re: about join lf

Hi mamata... can u pls tell me the RDBMS concept of Primary Key and Foriegn Key in AS400... do u use Logical file for the same?

thx
Karthik