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
uvStage Tablename as variable
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.