Can we use a table name in custom routine

mohiddin · Post by **mohiddin** » Fri Apr 25, 2008 5:42 am

I have a requirement to use the table name in the custom routine.If we can use please give me the solution

ArndW · Post by **ArndW** » Fri Apr 25, 2008 6:13 am

You haven't really explained the problem. Why can't you use the table in a custom server routine?

ray.wurlod · Post by **ray.wurlod** » Fri Apr 25, 2008 6:26 am

"Use" the table name? That's a bit vague.

You can pass the table name as an argument. You can load up the table name into a job parameter or environment variable and interrogate that. You can use a number of system variables, like @USER0. The best approach may even be to have the routine code interrogate the job design to determine the table name.

It really depends on what "use" means in your context.