Environment :Data Stage 7.5.2, AIX server , DB2 UDB
Requirement:To generate data sets corresponding to the different table names using parallel process..
Ex:Employee table has different load tables like Employee_01,Employee_02 (loaded weekly,monthly etc..)Have same "meta data"
Employee_01 corresponding file emp_01.ds
Employee_02 .......................emp_02.ds
Employee_03 ..................emp_03.ds
we have a job " DB2 table read and writes to a Dataset "
[
Code: Select all
DB2 API (Employee)>>>>Dataset(emp.ds)
Given "table name" and "file name" as parameter to the above job.
Job properties:Allow multiple instances job
SQL query :Select ENAME,SAL,JOB ...FROM #TABLE NAME#
File name:#emp.ds#
Here we can pass "Invocation ID as 1,2,3...manually "to generate these files".
Questions:
How can we automate these"Invocation ID"to generate files in multiple invocation job?
or
can we implement any server "job control routine" to call table names , file names and Invocation ID in "Batch job" to generate files?
Thank you.