Topic
1 reply Latest Post - ‏2006-05-11T04:14:16Z by SystemAdmin
SystemAdmin
SystemAdmin
93 Posts
ACCEPTED ANSWER

Pinned topic DB2 table name as parameter

‏2004-12-01T08:53:05Z |
Hi All,

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?
Updated on 2006-05-11T04:14:16Z at 2006-05-11T04:14:16Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    93 Posts
    ACCEPTED ANSWER

    Re: DB2 table name as parameter

    ‏2006-05-11T04:14:16Z  in response to SystemAdmin
    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