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?
This topic has been locked.
1 reply Latest Post - 2006-05-11T04:14:16Z by SystemAdmin
Pinned topic DB2 table name as parameter
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2006-05-11T04:14:16Z at 2006-05-11T04:14:16Z by SystemAdmin
SystemAdmin 110000D4XK93 PostsACCEPTED ANSWER
Re: DB2 table name as parameter2006-05-11T04:14:16Z in response to SystemAdminyes, 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