MQSeries.net :: View topic - Batch Processing

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 » Batch Processing

Batch Processing

« View previous topic :: View next topic »

Author

Message

ShaileshBajaj

Posted: Mon Nov 06, 2006 9:23 pm Post subject: Batch Processing

Newbie

Joined: 04 Jul 2006
Posts: 6

Env.: WBI 6
We need to send message at certain period/intervals.
Basically we have to read all the DB records not sent and create new messages , post them and update the sent flag.
Basically my queries were
1) Can I use a timeout control and notification nodes to achieve this.
2) How do I read through all the DB records in ESQL.

TIA

Edde

Posted: Tue Nov 07, 2006 12:33 am Post subject: Re: Batch Processing

Acolyte

Joined: 01 Oct 2006
Posts: 67
Location: Moscow, Russia

1) Yes.
2) Use SELECT statement that returns multiple database records, e.g.

Code:

SET Environment.Variables.Customer[] =
SELECT * FROM Database.Customers AS CT
WHERE CT.Sent = 'N';

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Batch Processing

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