Override Fully Qualified Table Name

asitagrawal · Post by **asitagrawal** » Mon Dec 04, 2006 9:58 am

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

thebird · Post by **thebird** » Mon Dec 04, 2006 10:30 am

I am not sure if you can parametrize the schema name from the SQL Builder - though you can include parameters in the WHERE clause from here.

But why dont you use the Custom SQL query - where in you would be able to parameterize as you wish?

Aneesh

asitagrawal · Post by **asitagrawal** » Mon Dec 04, 2006 10:40 am

Ok...
Custom SQL worked, so I was just wondering whether I can parameterize table names from 'SQL Builder' or not....

One More thing, when I click on Help, the Help opens in some language other than English. So u get help in English (am asking only for SQL Builder Help)...

Thx anyways

thebird · Post by **thebird** » Mon Dec 04, 2006 10:47 am

asitagrawal wrote:Ok...
One More thing, when I click on Help, the Help opens in some language other than English. So u get help in English (am asking only for SQL Builder Help)...

Thx anyways

There is a chapter on the SQL Builder in the Parallel Job Developer's Guide.

asitagrawal · Post by **asitagrawal** » Mon Dec 04, 2006 11:52 am

Thx a lot...

Nageshsunkoji · Post by **Nageshsunkoji** » Mon Dec 04, 2006 12:06 pm

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.

thebird · Post by **thebird** » Mon Dec 04, 2006 12:13 pm

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.

I believe the question was with regard to the parameterization of the Scema name from the SQL builder.

Sreenivasulu · Post by **Sreenivasulu** » Mon Dec 04, 2006 11:03 pm

Hi,

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

thebird · Post by **thebird** » Mon Dec 04, 2006 11:34 pm

Sreenivasulu wrote:Hi,

Definitely you can parameterize the schema name using the job paramters.

Use #SCHEMA# in the paramter it will work

Can you please tell me how to go about it if I am using the SQL builder - which I believe is the original question.

Aneesh

DSXchange

Override Fully Qualified Table Name

Override Fully Qualified Table Name

Re: Override Fully Qualified Table Name

Re: Override Fully Qualified Table Name