MQSeries.net :: View topic - Select query table name from a variable

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 query table name from a variable

Select query table name from a variable

« View previous topic :: View next topic »

Author

Message

aggarwal.intouch

Posted: Thu Jul 31, 2014 11:36 pm Post subject: Select query table name from a variable

Acolyte

Joined: 30 May 2011
Posts: 56
Location: India

I'm trying to give table name in a variable and later trying to pick table name from that variable in my select query. But this is not working. Any suggestions???

set TABLE = 'TEST'

SET value=(SELECT MAX (Z.DATE_STEHT) FROM Database.TABLE AS Z

aggarwal.intouch

Posted: Fri Aug 01, 2014 12:02 am Post subject:

Acolyte

Joined: 30 May 2011
Posts: 56
Location: India

Found solution of my query. Although there was no rocket science behind that.

Solution : Keep variable in curly braces.

Code:

set TABLE = 'TEST'

SET value=(SELECT MAX (Z.DATE_STEHT) FROM Database.{TABLE} AS Z

mqjeff

Posted: Fri Aug 01, 2014 5:28 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

ganesh

Posted: Fri Aug 01, 2014 5:50 am Post subject:

Master

Joined: 18 Jul 2010
Posts: 294

Did you try a different variable name, "TABLE" could be a key word.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Select query table name from a variable

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