MQSeries.net :: View topic - duplicate rows with WMQI message flow

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 » duplicate rows with WMQI message flow

duplicate rows with WMQI message flow

« View previous topic :: View next topic »

Author

Message

narendra

Posted: Thu Sep 19, 2002 1:11 pm Post subject: duplicate rows with WMQI message flow

Apprentice

Joined: 04 Jun 2002
Posts: 26

Gurus

I have a message flow to extract data from the DB2 data base. It extracts
few hundred records quite well , after that it starts duplicating the same record.
Could some one out there know what is going on.

Thanks in advance
Narendra

kirani

Posted: Thu Sep 19, 2002 5:00 pm Post subject:

Jedi Knight

Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA

I would suspect the WHERE clause in your SELECT statement, which is returning your the same set of data every time.
_________________
Kiran

IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries

Segs

Posted: Thu Sep 19, 2002 11:02 pm Post subject:

Voyager

Joined: 04 Oct 2001
Posts: 78
Location: Zurich Financial Services

Have you got any table joins in the query? If you haven't set these up correctly this will cause the rows to be duplicated.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » duplicate rows with WMQI message flow

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