• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Outer Join in World Writer

Tran

Member
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.
 

Hal_McGee

Active Member
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
 

ssolberg

VIP Member
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.
 

PavelK

Member
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/how-create-dds-logical-file-produces-results-left-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
 
Top