Calling Environment Variables in Basic Transformer

gsym · Post by **gsym** » Fri Feb 09, 2007 12:34 pm

I am using a BASIC Transformer in a Parallel job to generate a calendar table. The values for the start and end dates for the calendar must be obtained from a couple of environment variables.

How do I go about doing this in the BASIC Transformer. Now if it was just a Transformer stage I would create two stage variables and set their initial values as GetEnvironment("Environmentvariablename") but this does not seem to work in BASIC Transformer.

Please help !

chulett · Post by **chulett** » Fri Feb 09, 2007 12:36 pm

So... does this need to be a Parallel job?

gsym · Post by **gsym** » Fri Feb 09, 2007 1:01 pm

chulett wrote:So... does this need to be a Parallel job?

I am using the BASIC Transformer here because of the ease of using Iconv/Oconv functions. But I must use it in a parallel job.

DSguru2B · Post by **DSguru2B** » Fri Feb 09, 2007 1:30 pm

You pass the environment variable as a job parameter.

gsym · Post by **gsym** » Fri Feb 09, 2007 2:12 pm

DSguru2B wrote:You pass the environment variable as a job parameter.

The problem is that I have been asked to only use specific environment variables in the jobs. No job parameters. I am doing it this way because the job is going to be executed using a control file and the values for all the environment variables used in the job is specified in the control file.

So I declare all the environment variables in the job properties>job parameters and both my start dates and end dates are specified there as environment variables.

edited to remove utter stupidity !!

DSguru2B · Post by **DSguru2B** » Fri Feb 09, 2007 2:15 pm

gsym wrote: So I declare all the environment variables in the job properties>job parameters and both my start dates and end dates are specified there as environment variables.

Well if you already have them setup in the job parameters then why not read them inside the transformer.

gsym · Post by **gsym** » Fri Feb 09, 2007 2:23 pm

Crap !!

I feel like a complete idiot !!

Ur right, I have already found the solution.

What was I thinking.....

Why don't I just delete this post

DSguru2B · Post by **DSguru2B** » Fri Feb 09, 2007 2:24 pm

Thats ok buddy. Glad you got it resolved. Just mark it as resolved and have a cup of tea, or coffee

gsym · Post by **gsym** » Fri Feb 09, 2007 2:27 pm

DSguru2B wrote:Thats ok buddy. Glad you got it resolved. Just mark it as resolved and have a cup of tea, or coffee

Thanks DSguru ...... I guess sometimes one has to put his problems in writing to realize he's already got the solution or that there was no problem at all in the first place !!

Guess I had somehow made the assumption that the environment variable has to be directly called in the BASIC Transformer stage and no job parameters should be used.....

ray.wurlod · Post by **ray.wurlod** » Fri Feb 09, 2007 3:50 pm

That's cool, because my advice was going to be to push back on the daft requirement!