By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

DEFAULT SCHEMA IN CLP

P: n/a
bea
Is there a way to set a default schema name by setting environment
variable, so that it is set for CLP before connect to the database?

Thank you.

Feb 9 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Feb 9, 2:55 pm, "bea" <mbeatrizrodrig...@gmail.comwrote:
Is there a way to set a default schema name by setting environment
variable, so that it is set for CLP before connect to the database?

Thank you.
Hi,
Can u be more descriptive in what u want to achieve!!!

Feb 9 '07 #2

P: n/a
bea
On Feb 9, 12:59 pm, "Racerx" <p.paingan...@gmail.comwrote:
On Feb 9, 2:55 pm, "bea" <mbeatrizrodrig...@gmail.comwrote:
Is there a way to set a default schema name by setting environment
variable, so that it is set for CLP before connect to the database?
Thank you.

Hi,
Can u be more descriptive in what u want to achieve!!!
Of course. I want to access to a table with schema = DWAPROV but my
user has other name. I donīt want to make set current squema = ''. I
have tried to modify db2cli.ini but this doesn`t work with CLP.

Is it possible make this?
Feb 9 '07 #3

P: n/a
bea wrote:
On Feb 9, 12:59 pm, "Racerx" <p.paingan...@gmail.comwrote:
>On Feb 9, 2:55 pm, "bea" <mbeatrizrodrig...@gmail.comwrote:
>> Is there a way to set a default schema name by setting environment
variable, so that it is set for CLP before connect to the database?
Thank you.
Hi,
Can u be more descriptive in what u want to achieve!!!

Of course. I want to access to a table with schema = DWAPROV but my
user has other name. I donīt want to make set current squema = ''. I
have tried to modify db2cli.ini but this doesn`t work with CLP.
There is no cli.ini like capability for CLP.
Assuming you are dealing with a select number of tables. Have you
considered creating ALIASes?

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Feb 9 '07 #4

P: n/a
On Feb 9, 2:19 pm, "bea" <mbeatrizrodrig...@gmail.comwrote:
On Feb 9, 12:59 pm, "Racerx" <p.paingan...@gmail.comwrote:
On Feb 9, 2:55 pm, "bea" <mbeatrizrodrig...@gmail.comwrote:
Is there a way to set a default schema name by setting environment
variable, so that it is set for CLP before connect to the database?
Thank you.
Hi,
Can u be more descriptive in what u want to achieve!!!

Of course. I want to access to a table with schema = DWAPROV but my
user has other name. I donīt want to make set current squema = ''. I
have tried to modify db2cli.ini but this doesn`t work with CLP.

Is it possible make this?
You could always qualify your table/procedure names.
e.g SELECT * from DWAPROV.tablename.

Although this does make things a bit clunky.

Feb 12 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.