ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Join LF with Select and omit

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Join LF with Select and omit

    Title says it all...

    Is it possible to create a join file with 2 files and have select ad omit statements in it?
    Red.
    Everyday's a school day, what grade are you in?

  • #2
    Yes.
    Code:
     A          R AIR71                     PFILE(AIP71)         
     A                                                           
     A          K CDAC71                                         
     A          K *NONE                     DESCEND              
     A          K *NONE                     DESCEND              
     A                                                           
     A          S TYPE71                    CMP(EQ 'CR')         
     A          R AIR72                     PFILE(AIP72)         
     A                                                           
     A          K CDAC72                                         
     A          K INVN72                                         
     A          K *NONE                     DESCEND              
     A                                                           
     A          S TYPE72                    CMP(EQ 'CR')         
     A          R AIR72U                    PFILE(AIP72U)        
     A                                                           
     A          K CDAC72                                         
     A          K INVN72
    Regards

    Kit
    http://www.ecofitonline.com
    DeskfIT - ChangefIT - XrefIT
    ___________________________________
    There are only 3 kinds of people -
    Those that can count and those that can't.

    Comment


    • #3
      Excellent,
      Thank you kitvb1

      Red
      Everyday's a school day, what grade are you in?

      Comment

      Working...
      X