Hi,
I am using a conditional join with variable and constructing a cluster masterfile.
JOIN WHERE CAR EQ &&CAR.
How can I pass FOC_NULL to this variable.If I use FOC_NULL it throws me error.

This message has been edited. Last edited by: FP Mod Chuck,

Isn’t it _FOC_NULL? What’s the error?

(FOC32516) AN ELEMENT IN JOIN_WHERE EXPRESSION IS NOT RECOGNIZED: _FOC_NULL
BYPASSING TO END OF COMMAND

Can you share an example we could run? WF_Retail has FACTS and DIMENSIONS you can use to join SALES to PRODUCT.

I don't have the WF_Retail sample in my Repository

Hi,
Is there any way to do this.
How can we ignore the JOIN WHERE condition in run time.

It is really pretty simple. You have a conditional statement which implies sometimes you want it and other times you don't.

Just set the line to an & variable, sort of like this:

-SET &CJLINE=IF condition is true THEN 'YOUR LINE OF CODE' ELSE '-*';

then where your line of code is, just substitute it with &CJLINE like this:

... lines of code
&CJLINE
... more lines of code

When you want it, it will be there otherwise it will be a -* which the parse will ignore.

Also, why do you have 2 threads open for this question?

I can comment the line if I have it in the procedure.What I have is a cluster master file where I am joining two tables.In that one JOIN condition has &&Variable and the other is Table1_ID EQ Table2_ID.
The JOIN condition will be JOIN WHERE Enrollment Date GE &&VARIABLE.

If I pass a value to this variable it will work fine.
What if I need to ignore this condition and run it for only the join condition with the ID.

Have you looked into using a master file profile?

quote:

master file profile

I have not used MFD profiles much in my development.
It would be helpful if you can share how we can use MFD profiles to achieve this requirement.

Siva

An MFD Profile is just another fex you register with the master file. When you open the synonym in the properties there is a place to reference the fex to be used under MFD_PROFILE. It can set && variables every time a user accesses the master file.

Hi Chuck,
I am setting my variable in the procedure.But if i set it as _FOC_NULL it throws error.

Siva

Better open a case with techsupport I don't know why that would cause an error. Did you put it inside single quote marks?

The functionality of _FOC_NULL, to signal "ignore this line of code" only works in a fex (as the fex pre-processor is determining whether and in what form to push the line into Focstack for execution).

In code occurring in an MFD and referencing global (&&) variables, if the &&var's value is _FOC_NULL it will be taken literally -- if within quotes, as a text value; if unquoted, as a fieldname. Either way, the resolved line remains "active" and the Join will throw an error at run-time.