Results 1 to 5 of 5

Thread: Outer Join in World Writer

  1. #1
    New Member
    Join Date
    Aug 2005
    Posts
    1

    Outer Join in World Writer

    How do you perform an outer join on two files in World Writer? It seems the only join we can do is an equal join.


  2. #2
    Member szmyd's Avatar
    Join Date
    Mar 2002
    Location
    Pennsylvania
    Posts
    129

    Re: Outer Join in World Writer

    Sorry, you'll have to use Query for that.
    Nicholas Szmyd

    JD Edwards World A9.3.1.2
    iSeries V7R1

  3. #3

    Re: Outer Join in World Writer

    Or ODBC with MS Access

    Hal McGee
    Engineering Data Manager
    Group Engineering - Process and Compliance
    Seating Products Group
    B/E Aerospace
    Winston-Salem, NC



    szmyd
    <nszmyd@wengerfee
    ds.com> To
    Sent by: jdelistsubscribers@jdelist.com
    jdeworld-bounces@ cc
    jdelist.com
    Subject
    Re: Outer Join in World Writer
    08/16/2005 04:58
    PM


    Please respond to
    JD Edwards® World
    <jdeworld@jdelist
    .com>






    Sorry, you'll have to use Query for that.


    Nicholas Szmyd JD Edwards World A7.3 Cume 11 AS/400 V5R1




  4. #4
    Member
    Join Date
    Oct 2000
    Location
    Missoula, MT, USA
    Posts
    536

    Re: Outer Join in World Writer

    Only in my dreams can you do an outer join with WW. Sorry, not functional in WW but found in many other reporting packages and Query.
    Sannan Solberg
    IT Functional Analyst/CreateForm
    E1 9.1/9.2 Tools 9.1/9.2
    CreateForm 7.x/CTIS

  5. #5
    New Member
    Join Date
    Jun 2008
    Posts
    17
    You can try create Join file. And use this join file as base file for WW.

    Here is how to create Left Outer Join:

    https://www.ibm.com/support/pages/ho...eft-outer-join


    How to Create a DDS Logical File that Produces the Results of an Left Outer Join
    Troubleshooting

    Problem

    This documents discusses how you can create a join logical file in DDS that produces the results of an Left outer join.
    Resolving The Problem

    If you would like to get the results of a left outer join for a join logical file, you can use the JDFTVAL keyword to get that result. By using the JDFTVAL keyword, you will get all of the records in the first file even if there is no match in the second file, and you will get all of the records that have a match from the second file. An example of how the JDFTVAL can be used is as follows:

    Example

    The following example shows how to specify the JDFTVAL keyword.

    |...+....1....+....2....+....3....+....4....+....5 ....+....6....+....7....+....8
    00010A JDFTVAL
    00020A R RECORD1 JFILE(PF1 PF2)
    00030A J JOIN(PF1 PF2)
    00040A JFLD(NAME NAME)
    00050A NAME JREF(1)
    00060A ADDR
    00070A BAL
    A

    PF1 is the primary file and PF2 is a secondary file. You should assume that PF1 and PF2 have the following records:
    PF1 NAME

    ADDR

    PF2 NAME

    BAL
    Anne 120 1st St. Anne 5.00
    Doug 40 Pillsbury Doug 6.50
    Mark 2 Lakeside Dr. Sue 2.00
    Sue 120 Broadway

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.