ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Search

 Search found 4 matches
Author Message
  Topic: Select using IN (?,?,?) with different values per message
wbader

Replies: 8
Views: 4471

PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon Mar 03, 2008 11:21 pm   Subject: Select using IN (?,?,?) with different values per message
This is my my code:

SET PASS = 'SELECT * FROM ACVWS_ALL_AC_ENTRIES WHERE AC_NO IN (' || QUESTIONMARKS ||') AND STMT_DT = ?'

SET Environment.Variables.ACCTXN[] = PASSTHRU(PASS ,ALL_CHILD , '20070 ...
  Topic: Select using IN (?,?,?) with different values per message
wbader

Replies: 8
Views: 4471

PostForum: WebSphere Message Broker (ACE) Support   Posted: Fri Feb 29, 2008 11:52 am   Subject: Select using IN (?,?,?) with different values per message
I'd appreciate it if you guys would please tell me how can I post my code.. It'll be easier.
  Topic: Select using IN (?,?,?) with different values per message
wbader

Replies: 8
Views: 4471

PostForum: WebSphere Message Broker (ACE) Support   Posted: Thu Feb 28, 2008 5:07 am   Subject: Select using IN (?,?,?) with different values per message
I'm trying to post my code, but i'm getting a message that says "no post mode specified"!
  Topic: Select using IN (?,?,?) with different values per message
wbader

Replies: 8
Views: 4471

PostForum: WebSphere Message Broker (ACE) Support   Posted: Thu Feb 28, 2008 4:02 am   Subject: Select using IN (?,?,?) with different values per message
Hi,
I'm trying to SELECT number of rows from a database WHERE column IN (?,?,?). The number of values varies per Message. I tried doing something but i'm getting an error that says "'[DataDirect ...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.