| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database explorer not showing views |
« View previous topic :: View next topic » |
| Author |
Message
|
| francoisvdm |
 Posted: Tue Feb 20, 2007 4:58 am Post subject: Database explorer not showing views |
 |
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
MB v 6, windows platform.
I'm trying to add an Oracle database via "New", "RDB Definition files" and it will populate all the tables, but the "views" are empty.
I can do all DB actions like inserting rows, but one of my selects is via a "view". The command
| Code: |
| PASSTHRU('select * from eai.mt_last_updated where rownum <= 5;') |
will give database error
Text = [IBM][CLI Driver][DB2/NT] SQL0204N "EAI.MT_LAST_UPDATED" is an undefined name. SQLSTATE=42704
From what I can learn from the dba is that MT_LAST_UPDATED is a "VIEW".
Any ideas? Thanks
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Feb 20, 2007 5:03 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
If you're getting database errors using PASSTHRU, then it's entirely a database issue.
Probably, it's a database permissions issue.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
