I created a simple data flow called df_mytest_fm_to_sql to move data from source to target. I am able to execute this flow without any problem. I added the following filter to select columns node in the data flow.
T1.FirstName = &&TESTVAR

I created a simple procedure called setdbvar and it has the following code
EX CMASAP REQ_NAME=df_mytest_fm_to_sql, CM_ASYNC=OFF, PARMS="&&TESTVAR=Jim";

When I execute the procedure, I am getting an error which says - (FOC295) A VALUE IS MISSING FOR: &&TESTVAR

My goal of this test is to pass the value "Jim" to the &&TESTVAR variable and I would like the procedure to run the data flow using CMASAP.

Any help here is appreciated.

AK,
You have a procedure (focexec) called 'setdbvar'.
In this procedure you have the command EX CMASAP. CMASAP is also a focexec.
If you write:

  
-SET &&TESTVAR='Jimm';

before your EX CMASAP it will receive the value of this global parameter.

Daniel, thanks for replying back.

I did try this option -
-SET &&MYVAR2 = 'Jim';
EX CMASAP REQ_NAME=df_mytest_fm_to_sql, CM_ASYNC=OFF, PARMS="&&TESTVAR=&&MYVAR2";

and I am getting the same error.

The filter in the iDM data flow is
T1.FirstName = &&TESTVAR

From the manual,

Syntax: How to Supply a Variable Value With Another Procedure
EX[EC] procedure name=value where:

procedure

Is the name of the procedure that will contain the name/value values.


name

Is the variable name.


value

Is the value you are giving to the variable.


EX SLRPT CITY=STAMFORD, CODE1=B10, CODE2=B20

So you should be able to
EX CMASAP REQ_NAME=df_mytest_fm_to_sql, CM_ASYNC=OFF, TESTVAR=Jim

Try this:

-DEFAULT &&TESTVAR='&&TESTVAR'

EX CMASAP REQ_NAME=df_mytest_fm_to_sql, CM_ASYNC=OFF, PARMS="&&TESTVAR=Jim";

I don't think you can set -DEFAULT values in this way. It still has to get the value of &&TESTVAR from somewhere.

I've done this before and it works for me. I copied this straight from a flow I have running right now:

-DEFAULT &&LOAD_YYM='&&LOAD_YYM'

-BUILD_CSV

EX CMASAP REQ_NAME=PF_IRF_CLAIM_CSV_BUILD, CM_ASYNC=OFF, PARMS="&&LOAD_YYM=&LOAD_YYM"
-RUN

You've got two different variables in there - &&LOAD_YYM and &LOAD_YYM. One is global, the other is local. In your code, where would it get the value for &LOAD_YYM?

The other way to pass the amper variable is to use the pipe character.

EX CMASAP REQ_NAME=df_mytest_fm_to_sql, CM_ASYNC=OFF, PARMS="&|&|TESTVAR=Jim";

This stops the test for the variable and removes the pipes when it is evalulated.

The value for &LOAD_YYM is determined higher up in the procedure. I didn't include all that code because I didn't think it was relevant to what AK was looking for. When the process executes, it comes out looking something like this:

-DEFAULT &&LOAD_YYM='&&LOAD_YYM'

-BUILD_CSV

EX CMASAP REQ_NAME=PF_IRF_CLAIM_CSV_BUILD, CM_ASYNC=OFF, PARMS="&&LOAD_YYM=200710"