Self Join Logical File- DDS

Posted on 2006-05-17
Last Modified: 2012-05-05
Good Morning Every one.
Can any please provide me the DDS Specification for a Self Join Logical File.
& is their any Special way to Compile that of the same.
Question by:midwestexp
    1 Comment
    LVL 13

    Accepted Solution

    If the physical file PF has three fields like this:
    A          R FM1                                              
    A            USRPRF        10          TEXT('USER PROFILE')    
    A            DESC          30          DFT('BLANK')            
    A                                      TEXT('DESCRIPTION')    
    A            GRPPRF        10          TEXT('GROUP PROFILE')  
    where user profile USRPRF is in group profile GRPPRF

    The DDS for join logical file JLF is:
    A                                      JDFTVAL                  
    A          R JFM                       JFILE(PF PF)              
    A          J                           JOIN(1 2)                
    A                                      JFLD(GRPPRF USRPRF)      
    A            USRPRF                    JREF(1)                  
    A            DESC                      JREF(1)                  
    A            GRPPRF                    RENAME(USRPRF)            
    A                                      JREF(2)                  
    A            GROUPDES                  RENAME(DESC)              
    A                                      JREF(2)                  

    So, if the physical file looks like:
    USRPRF      DESC                            GRPPRF
    ----------     -------------------------     ----------
    BH              Barry                            SECADM
    SECADM      Security Admin Group  
    The resulting join logical file looks like:
    USRPRF      DESC                            GROUPNAM  GROUPDES                    
    ---------      --------------------------    -------------  ------------------------
    BH              Barry                            SECADM      Security Admin Group    
    SECADM     Security Admin Group                        BLANK                  

    I included a default value for the description field so you can see how it works.
    If you have any questions, please post back!

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
    Read about the 3 stages of the buyer's journey: awareness, consideration, and decision.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now