| Author |
Message
|
| sachinramesh |
 Posted: Tue Apr 29, 2008 1:52 am Post subject: need some clarification on dsn uid/pwd |
 |
|
Disciple
Joined: 20 Feb 2007
Posts: 170
|
Hi
My Problem is i am using a database with datasource name"CUDB" connects using db2admin/db2admin ,The schema name of the tables in the database is "db2admin" now when i changed the dsn uid/pwd to Ramesh/unify and run the flow i am getting an exception at this particular statement ( SELECT T.ACTIVITY_CODE FROM Database.TBL_CU_ACTIVITY_DEF_BUNDLEDCP AS T WHERE
T.ACTIVITY_CODE = TRIM ( '"' FROM TRIM("InputBody"."TMM_RECORD"[1].
saying that Ramesh.TBL_CU_ACTIVITY_DEF_BUNDLEDCP is an undefined name.
the above table has a schema name of db2admin.
I could not understand why it is showing that error when my DSN is connecting with ramesh/unify.
I had also tried changing the code mentioning the schema name .
SELECT T.ACTIVITY_CODE FROM Database.db2admin.TBL_CU_ACTIVITY_DEF_BUNDLEDCP AS T WHERE
T.ACTIVITY_CODE = TRIM ( '"' FROM TRIM("InputBody"."TMM_RECORD"[1].
but still facing the same error |
|
| Back to top |
|
 |
| AkankshA |
| Posted: Tue Apr 29, 2008 2:08 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
does the table TBL_CU_ACTIVITY_DEF_BUNDLEDCP exist in schema ramesh??
try specifying schema as well in eSQL statement n see if that works |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Apr 29, 2008 2:13 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| AkankshA wrote: |
| does the table TBL_CU_ACTIVITY_DEF_BUNDLEDCP exist in schema ramesh?? |
I think the poster said, quite clearly, it exists in schema db2admin 
| AkankshA wrote: |
try specifying schema as well in eSQL statement n see if that works |
I think the post indicates that's been tried as well:
| sachinramesh wrote: |
| I had also tried changing the code mentioning the schema name . |
There is no point posting advice which has already failed. Unless you're into post count. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| sachinramesh |
| Posted: Tue Apr 29, 2008 2:14 am Post subject: |
|
|
Disciple
Joined: 20 Feb 2007
Posts: 170
|
| AkankshA wrote: |
does the table TBL_CU_ACTIVITY_DEF_BUNDLEDCP exist in schema ramesh??
try specifying schema as well in eSQL statement n see if that works |
No ,i don't have any table with schema Ramesh.all the tablea are having db2admin as the schema name .
i had also specified the schema name and tried ( SELECT T.ACTIVITY_CODE FROM Database.db2admin.TBL_CU_ACTIVITY_DEF_BUNDLEDCP AS T WHERE
T.ACTIVITY_CODE = TRIM ( '"' FROM TRIM("InputBody"."TMM_RECORD"[1].
but getting the same error.
Is the error pointing to the schema name or the dsn uid,bcos ramesh is my dsn uid. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Apr 29, 2008 2:16 am Post subject: Re: need some clarification on dsn uid/pwd |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| sachinramesh wrote: |
| I could not understand why it is showing that error when my DSN is connecting with ramesh/unify. |
By default, DB2 uses the logged on name as the schema name.
| sachinramesh wrote: |
I had also tried changing the code mentioning the schema name .
|
What schema (if any) is the DSN set to use?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| sachinramesh |
| Posted: Tue Apr 29, 2008 2:21 am Post subject: Re: need some clarification on dsn uid/pwd |
|
|
Disciple
Joined: 20 Feb 2007
Posts: 170
|
| Vitor wrote: |
| sachinramesh wrote: |
| I could not understand why it is showing that error when my DSN is connecting with ramesh/unify. |
By default, DB2 uses the logged on name as the schema name.
| sachinramesh wrote: |
I had also tried changing the code mentioning the schema name .
|
What schema (if any) is the DSN set to use? |
I did not set any schema for the DSN,and i dont know how to set.
i had only set the UID/PWD using db2setparms brkname -u CUDB -n ramesh -p unify |
|
| Back to top |
|
|
| AkankshA |
| Posted: Tue Apr 29, 2008 2:37 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
| Vitor wrote: |
| AkankshA wrote: |
| does the table TBL_CU_ACTIVITY_DEF_BUNDLEDCP exist in schema ramesh?? |
I think the poster said, quite clearly, it exists in schema db2admin
| AkankshA wrote: |
try specifying schema as well in eSQL statement n see if that works |
I think the post indicates that's been tried as well:
| sachinramesh wrote: |
| I had also tried changing the code mentioning the schema name . |
There is no point posting advice which has already failed. Unless you're into post count. |
well,,, what i understood from the post was
the user has table created in db2admin schema and later moved to Ramesh schema
and now still the broker was trying to connect using db2admin..
and hence i asked for the existance of table in ramesh schema and suggested giving ramesh -schema name in query..
guess i run into too many assumptions which proved themself as fatal...
my apologies |
|
| Back to top |
|
|
|
|
