Page 1 of 1

Posted: Tue Dec 24, 2002 4:15 pm
by ray.wurlod
What you need to do is provide the value of the variable to the jobs started from your JobControl routine to the jobs it starts via a job parameter. Use the parameter name bounded by "#" characters (for example #MyUVTable#) in the table name field of the UV stage.
What you are trying to accomplish can only be achieved using a job parameter, unless you create your own DataStage BASIC routines.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Posted: Wed Dec 25, 2002 11:28 pm
by raviyn
With ur response what i have understood is that u want to run the same job for different "Table names".

U can acheive it by having multiple instances of the same jobs and running it with different values for the variable.

Or two jobs one for changing the variable for the table name each time.

Posted: Thu Dec 26, 2002 3:20 pm
by ray.wurlod
Within a single job the table name must remain fixed. The table is opened when the active stage to which it is connected starts, and is closed when the active stage to which it is connected finishes.
Therefore it is not possible to do what you want to do in a single job.
However, the table name can be a job parameter, and you can use a job parameter reference (as per my earlier post) to specifiy a different table name each time the job is run. Or for each job instance, as raivyn has pointed out.