JOIN  LEFT_OUTER FILE SMRSD01 AT SMRSD01 TAG DQ TO MULTIPLE
FILE SUDBA17_VAR_VW AT SUDBA17_VAR_VW TAG DE AS JA1
WHERE DQ.PAACCT_CODE EQ DE.DLR_DEALER_CODE_C;
WHERE DQ.DDLRX_DLR_SUB_C EQ DE.DLR_DEALER_SUBCD_C;
WHERE DQ.COUNTRY_ISO3_C EQ DE.CUS_COUNTRY_ISO3_C;
END

(FOC370) THE FIELDNAME USED IN JOIN CANNOT BE FOUND IN THE FILE: SMRSD01

SET MULTIPATH=COMPOUND
SET ALL=ON
SET KEEPDEFINES=ON

JOIN  LEFT_OUTER FILE SMRSD01 AT SMRSD01 TAG DQ TO MULTIPLE

quote:

The syntax of the conditional (WHERE-based) JOIN command is

JOIN [LEFT_OUTER|INNER] FILE hostfile AT hfld1 [TAG tag1]
[WITH hfld2]
TO {UNIQUE|MULTIPLE}
FILE crfile AT crfld [TAG tag2] [AS joinname]
[WHERE expression1;
[WHERE expression2;
...]
END
where:

INNER
Specifies an inner join. If you do not specify the type of join in the JOIN command, the ALL parameter setting determines the type of join to perform.

LEFT_OUTER
Specifies a left outer join. If you do not specify the type of join in the JOIN command, the ALL parameter setting determines the type of join to perform.

hostfile
Is the host Master File.

AT
Links the correct parent segment or host to the correct child or cross-referenced segment. The field values used as the AT parameter are not used to cause the link. They are simply used as segment references.

hfld1
Is the field name in the host Master File whose segment will be joined to the cross-referenced data source. The field name must be at the lowest level segment in its data source that is referenced.

tag1
Is the optional tag name that is used as a unique qualifier for fields and aliases in the host data source.

hfld2
Is a data source field with which to associate a DEFINE-based conditional JOIN. For a DEFINE-based conditional join, the KEEPDEFINES setting must be ON, and you must create the virtual fields before issuing the JOIN command.

MULTIPLE
Specifies a one-to-many relationship between from_file and to_file. Note that ALL is a synonym for MULTIPLE.

UNIQUE
Specifies a one-to-one relationship between from_file and to_file. Note that ONE is a synonym for UNIQUE.

Note: Unique returns only one instance and, if there is no matching instance in the cross-referenced file, it supplies default values (blank for alphanumeric fields and zero for numeric fields).

crfile
Is the cross-referenced Master File.

crfld
Is the join field name in the cross-referenced Master File. It can be any field in the segment.

tag2
Is the optional tag name that is used as a unique qualifier for fields and aliases in the cross-referenced data source.

joinname
Is the name associated with the joined structure.

expression1, expression2
Are any expressions that are acceptable in a DEFINE FILE command. All fields used in the expressions must lie on a single path.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server