Override Fully Qualified Table Name
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
Override Fully Qualified Table Name
Hi,
I am using 'SQL Builder' from DB2/UDB API stage.
But the problem is that I want to change the fully qualified name of the table, to include a Job Parameter.
Eg.
As of now I am getting SAMPLE.TESTTABLE
and I want #$DB_OWNER#TESTTABLE
From the 'SQL Builder' editor, I am unable to change the Table Name and also I get just one option and that too of Inserting a Job Parameter,
so does it mean that I should create a Job Parameter, say,
TBNAME = #$DB_OWNER#TESTTABLE and use it there??
Please suggest.
Thx,
Asit
I am using 'SQL Builder' from DB2/UDB API stage.
But the problem is that I want to change the fully qualified name of the table, to include a Job Parameter.
Eg.
As of now I am getting SAMPLE.TESTTABLE
and I want #$DB_OWNER#TESTTABLE
From the 'SQL Builder' editor, I am unable to change the Table Name and also I get just one option and that too of Inserting a Job Parameter,
so does it mean that I should create a Job Parameter, say,
TBNAME = #$DB_OWNER#TESTTABLE and use it there??
Please suggest.
Thx,
Asit
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
You can parameterize Servername,Schemaname,username and password and I don't think so database name is required in the parameterisation.
We have jobs with all parameters other than table name.
We have jobs with all parameters other than table name.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
I believe the question was with regard to the parameterization of the Scema name from the SQL builder.Nageshsunkoji wrote:You can parameterize Servername,Schemaname,username and password and I don't think so database name is required in the parameterisation.
We have jobs with all parameters other than table name.
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Re: Override Fully Qualified Table Name
Hi,
Definitely you can parameterize the schema name using the job paramters.
Use #SCHEMA# in the paramter it will work
Regards
Sreeni
Definitely you can parameterize the schema name using the job paramters.
Use #SCHEMA# in the paramter it will work
Regards
Sreeni
asitagrawal wrote:Hi,
I am using 'SQL Builder' from DB2/UDB API stage.
But the problem is that I want to change the fully qualified name of the table, to include a Job Parameter.
Eg.
As of now I am getting SAMPLE.TESTTABLE
and I want #$DB_OWNER#TESTTABLE
From the 'SQL Builder' editor, I am unable to change the Table Name and also I get just one option and that too of Inserting a Job Parameter,
so does it mean that I should create a Job Parameter, say,
TBNAME = #$DB_OWNER#TESTTABLE and use it there??
Please suggest.
Thx,
Asit
Re: Override Fully Qualified Table Name
Can you please tell me how to go about it if I am using the SQL builder - which I believe is the original question.Sreenivasulu wrote:Hi,
Definitely you can parameterize the schema name using the job paramters.
Use #SCHEMA# in the paramter it will work
Aneesh