Passing Substring of Parameter into Table Name

[grb_garre]

Hi,

Jobs are writing the Data into a Table /Extracting Data from table
Actual requirement i want to pass table name as dynamic.
Table Name is substring of one of the job parametre

Example :
Parameter Values have like ABC_XYZ
How can i pass 'ABC' as Table Name?


Can anybody share the ideas ?

Thanks in Advance

[roy]

Hi,
then you'll have to have a job parameter for that table name to be parsed outside the job in a squence job's routine activity and passing it as a parameter to the job or similar.

IHTH,

[chulett]

Exactly. Since you have no opportunity to manipulate the value of the parameter in the job before it must be used in the stage, then you must do that outside the job and pass in the substringed result ready to use.

[grb_garre]

Hi,
then you'll have to have a job parameter for that table name to be parsed outside the job in a squence job's routine activity and passing it as a parameter to the job or similar.

IHTH,

Thanks a lot roy ..will try it

[Sainath.Srinivasan]

Define the job with 2 parameter. Use them as concatenated when you want the full parameter and use partial for table names.