| Author |
Message
|
| Hari |
 Posted: Mon Feb 25, 2008 2:36 pm Post subject: SELECT (sql) statement query |
 |
|
Centurion
Joined: 21 Nov 2002
Posts: 117
Location: USA
|
The Env:
Broker 6.0.2 on Windows
The Database is DB2 7.2.6
Is it possible to use the database isolation levels with the regular database SELECT statement [b](please note not using PASSTHRU)[/b].
For example: SELECT *.....WITH UR
I have tried using these options but does not seem to work, nor did I find any documentation pointing to it.
Further to this...
How does the SELECT query work internally in broker (does it follow the logic of the underlying database), does it hold any locks.
Thanks. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Feb 25, 2008 2:53 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I did not believe that DB2 v7 was supported with Broker v6.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| AkankshA |
| Posted: Tue Feb 26, 2008 2:15 am Post subject: Re: SELECT (sql) statement query |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
| Hari wrote: |
SELECT *.....WITH UR
|
Select * never worked for me too...
Anyways i always feel its better to fetch only what is required and not just whatever i can....
_________________
Cheers |
|
| Back to top |
|
|
| Hari |
| Posted: Fri Feb 29, 2008 4:34 pm Post subject: |
|
|
Centurion
Joined: 21 Nov 2002
Posts: 117
Location: USA
|
bump bump bump....to the top.
[quote="jefflowrey"]I did not believe that DB2 v7 was supported with Broker v6.[/quote]
Though the Supported Database lists DB2 v8.2 as the minimum requirement, broker v6 works fine with DB2 v7.2.
In my original post i was trying to indicate (my bad in conveying) the fact that i was trying to access DB2 v 7.2.6 table in my Compute node.
[quote="AkankshA"][quote="Hari"]
SELECT *.....WITH UR
[/quote]
Select * never worked for me too...
Anyways i always feel its better to fetch only what is required and not just whatever i can....[/quote]
Akanksha what i am talking is the database isolation level i.e. "WITH UR" component.
By the way i have used "SELECT *" without a hitch in my msg flows (of course without the database isolation levels). |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Sat Mar 01, 2008 3:52 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
ESQL SELECT doesn't support isolation levels.
ESQL Select is not the same as SQL Select.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
