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 » WebSphere Message Broker (ACE) Support » DB Resultsets Split

Post new topic  Reply to topic
 DB Resultsets Split « View previous topic :: View next topic » 
Author Message
DeadPool
PostPosted: Wed Jul 06, 2016 6:24 am    Post subject: DB Resultsets Split Reply with quote

Apprentice

Joined: 27 May 2016
Posts: 30

All Long time reader

Have an issue whereby I am making a call to a database and retrieving via Stored Proc a Resultset.

On retrieval the Debugger is showing the same resultset name in 2 parts with two thirds of teh overall resultset in 1 part and the remainder in another.

Previously I have not seen this issue as the data was not large but this happens at approx 2149 chars of a total of 2450.

This seems very strange to me as I would have thought that the size of teh response would not affect IIB.

So I have to now merge the 2 result sets together.

and to my question
If they have the same name and reference how to do this?

Many thanks
Back to top
View user's profile Send private message
mqjeff
PostPosted: Wed Jul 06, 2016 6:28 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Have you confirmed that this isn't caused by the stored procedure?
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
DeadPool
PostPosted: Wed Jul 06, 2016 6:39 am    Post subject: Reply with quote

Apprentice

Joined: 27 May 2016
Posts: 30

jeff good to know minds think alike.

Stored proc is only passing back a single resultset

so the split should either be in the ODBC connection or IIB.
Back to top
View user's profile Send private message
mqjeff
PostPosted: Wed Jul 06, 2016 6:45 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

what's the odbc trace show?

what's the trace node output show? (probably the two result sets?)

What database? What's the odbc config look like?
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
DeadPool
PostPosted: Wed Jul 06, 2016 6:52 am    Post subject: Reply with quote

Apprentice

Joined: 27 May 2016
Posts: 30

Forgot to mention this is on a Windows OS

Tends to split it at 2033 chars, as if a max length)

Will get config etc

SQL Server 2014
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DB Resultsets Split
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
 
 


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

Copyright © MQSeries.net. All rights reserved.