Project variables in selection criteria?

anilkona · Post by **anilkona** » Wed Jun 22, 2005 5:44 pm

Can you use project/environment level variables defined in DataStage Administrator in the selection criteria for a DB2 or ODBC stage?

I tried adding project variables as job parameters and used them in the selection criteria like Division_num = '#$DIVISION_NUM#'. When I tried to view data after that, it complained and also did not give me the option to enter the value for the above parameter.

Is this possible in DataStage 7.1 or 7.5? I see that these variables can be used as derivations for a stage variable or a lookup. But I really have to use them in the where clause.

Thanks,
-Anil

ray.wurlod · Post by **ray.wurlod** » Wed Jun 22, 2005 6:15 pm

Yes, it's possible, but NOT in View Data! You need to provide an explicit value when prompted for the job parameter value. For some reason, the data browser can not pick up the user-defined environment variable - even though it's right there. This is probably a bug. You'll find that they work fine when the job is running.

anilkona · Post by **anilkona** » Wed Jun 22, 2005 6:17 pm

But I don't see the parameter in the popup window which displays the job parameters after I click the 'View Data' button.

I can only see the job parameters that I defined specifically for a job but not the ones that I added from the environment.