MQSeries.net :: View topic - want to execute dynamic SQL Query in ESQL

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 » want to execute dynamic SQL Query in ESQL

want to execute dynamic SQL Query in ESQL

« View previous topic :: View next topic »

Author

Message

agrawalamit166

Posted: Thu Oct 15, 2009 12:16 pm Post subject: want to execute dynamic SQL Query in ESQL

Voyager

Joined: 17 Aug 2009
Posts: 78
Location: NY, US

DECLARE whareClause CHARACTER 'A.USER_NAME = userName' ;
DECLARE query CHARACTER 'SELECT A.* FROM Database.{tableName}AS A WHERE ' || whareClause;

Now I want to execute this query.

SET OutputRoot.XMLNSC.Test =Execution of query String.

Now please let me know how can i execute the dynamic string query in ESQL.

Vitor

Posted: Thu Oct 15, 2009 12:20 pm Post subject: Re: want to execute dynamic SQL Query in ESQL

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

agrawalamit166 wrote:

Now please let me know how can i execute the dynamic string query in ESQL.

Using any of the methods described in the documentation, or discussed on this forum from time to time.

_________________
Honesty is the best policy.
Insanity is the best defence.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » want to execute dynamic SQL Query in ESQL

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