I put the following conditional Join in a master:

SEGMENT=ZSNV865_ATTRIBUTE_VALUE, SEGTYPE=KM, PARENT=ZSNV160_RECEIVEABLE, CRFILE = ZSNV865_ATTRIBUTE_VALUE, $
JOIN_WHERE=ZSNV160_RECEIVEABLE.VEH_MAKE_CD EQ ZSNV865_ATTRIBUTE_VALUE.VAL_CD; ,$
JOIN_WHERE=VAL_CD EQ 1; ,$

And I'm geting the following error when doing a check. What is wrong with my syntax?

(FOC03601) ERROR AT OR NEAR LINE 686 IN PROCEDURE GS_WS_EXTRACT
(FOC396) MASTER ATTRIBUTE REPEATED. TERMINATOR (,$) MISSING?: >JOIN_WHERE<
----------vvvvvvvvvv
JOIN_WHERE=VAL_CD EQ 1; ,$

This message has been edited. Last edited by: Kerry,

Ted,

I think that the problem is caused by a limitation to 1 JOIN_WHERE attribute in the master. Try:

  
JOIN_WHERE=(ZSNV160_RECEIVEABLE.VEH_MAKE_CD EQ ZSNV865_ATTRIBUTE_VALUE.VAL_CD) AND (VAL_CD EQ 1) ; ,$

Thanks Daniel! Looks like that may have done it. The example I used had multiple JOIN_WHERE clauses, but this did not give me the error when I did a check.

According to the book multiples are allowed -- But the closing ,$ for the entire Segment declaration comes at the very end:

Syntax: How to Define a Conditional Join in the Master File

SEGNAME=seg,  
  SEGTYPE=styp,  
  PARENT=parseg,
  CRFILE=xmfd,  
 [CRSEG=xseg,
  JOIN_WHERE=expression; [JOIN_WHERE=expression; ...] 
  ,$

So remove the first two $'s (after CRFILE=..., and between the two JOIN_WHERE=...; clauses) and you s/b set.

Nice going Jack. I searched WebFocus and not FOCUS!
Is this not supported in WF? Doesn't seem likely. Not documented? VERY likely...

We support Conditional JOINs in the Developer Studio JOIN Tool as well as the JOIN Tool in InfoAssist.

I put the folliowing code in the master file:

SEGMENT=ZSNV865_ATTRIBUTE_VALUE, SEGTYPE=S0, PARENT=ZSNV160_RECEIVEABLE, LOCATION=ZSNV865_ATTRIBUTE_VALUE, JOIN_WHERE=(ZSNV160_RECEIVEABLE.VEH_MAKE_CD EQ ZSNV865_ATTRIBUTE_VALUE.VAL_CD) AND (ZSNV865_ATTRIBUTE_VALUE.VAL_CD EQ 1);, $
FIELDNAME=ATTR_TYPE_CD, ALIAS=ATTR_TYPE_CD, USAGE=I11, ACTUAL=I4, $
FIELDNAME=VAL_CD, ALIAS=VAL_CD, USAGE=I11, ACTUAL=I4, $
FIELDNAME=VAL_CD_DS, ALIAS=VAL_CD_DS, USAGE=A50V, ACTUAL=A50V, $
FIELDNAME=LSTUPDT_TS, ALIAS=LSTUPDT_TS, USAGE=HYYMDm, ACTUAL=HYYMDm, $
FIELDNAME=LSTUPDT_USER_ID_CD, ALIAS=LSTUPDT_USER_ID_CD, USAGE=A9, ACTUAL=A9, $


Here is the resulting access file code:

SEGNAME=ZSNV865_ATTRIBUTE_VALUE, TABLENAME=ZSNT01RV.ZSNV865_ATTRIBUTE_VALUE,
CONNECTION=GSDev, GUI_PARAMS='0,859,411,907,459,278,160', KEYS=0, $

But when I try to run a query against this code, here's the error message I get:

(FOC1354) ACCESS FILE RECORD ABSENT, WRONG OR INCOMPLETE FOR SEGMENT :
ZSNV865_ATTRIBUTE_VALUE


Any suggestions?

Why would you put a Conditional Join on a LOCATION segment, which, should be your DDNAME, not a column?

1. As I noted above, CRFILE attribute is required in any segment with JOIN_WHERE

2. Same document states: "Conditional joins in the Master File are supported for relational data sources only. The conditions are considered virtual fields in the Master File."

3. The LOCATION attribute applies only to Focus files.

Change LOCATION= to CRFILE=.

Solved.