MQSeries.net :: View topic - SELECT (sql) statement query

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SELECT (sql) statement query

SELECT (sql) statement query

« View previous topic :: View next topic »

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.

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.

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

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).

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.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SELECT (sql) statement query

Jump to:

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

Protected by Anti-Spam ACP