We have a situation where we need to load data into db2 tables but the table name has a suffix of a date and every month the data must be loaded into the table with the corresponding date.
Table structure stay the same.
Is it possible to use a parameter as a table name?
SystemAdmin 110000D4XK93 Posts
Re: DB2 table name as parameter2006-05-11T04:14:16ZThis is the accepted answer. This is the accepted answer.yes, u can add job param such as tbname and when give the value when execute th ejob. u can run the job with dsjob command and create a script for it with changed tablename
dsjob -run -param tbname=tablename project jobname