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 » ODBC/CLI/SQL Return Codes (Remote User Databases)

Post new topic  Reply to topic
 ODBC/CLI/SQL Return Codes (Remote User Databases) « View previous topic :: View next topic » 
Author Message
PGoodhart
PostPosted: Thu Sep 02, 2004 6:11 am    Post subject: ODBC/CLI/SQL Return Codes (Remote User Databases) Reply with quote

Master

Joined: 17 Jun 2004
Posts: 278
Location: Harrisburg PA

Hello,
I am trying to document which ODBC error codes (DB2 8.1) can occur on a call to a remote database, so we can build error handling. Does anyone know where I should be looking? I did look at IBM's so called documentation for SQL/ODBC/CLI, but this information seems to be missing. The one that I am especially interested in, is the error that occurs when the connection has been interupted.
Warmest Regards!
_________________
Patrick Goodhart
MQ Admin/Web Developer/Consultant
WebSphere Application Server Admin
Back to top
View user's profile Send private message
contactop
PostPosted: Thu Sep 02, 2004 6:18 am    Post subject: Reply with quote

Acolyte

Joined: 26 Jun 2003
Posts: 50

Try seeing the trace that's being generated, when the flow executes. And keep track of possible erros that occur, and u can document them.

Try starting with Datasource not available to ur last case u wish to do so.
Back to top
View user's profile Send private message
PGoodhart
PostPosted: Thu Sep 02, 2004 6:22 am    Post subject: Reply with quote

Master

Joined: 17 Jun 2004
Posts: 278
Location: Harrisburg PA

Yes I know I could record them as they happen, but I'd rather plan then react. They have to be written down somewhere.
_________________
Patrick Goodhart
MQ Admin/Web Developer/Consultant
WebSphere Application Server Admin
Back to top
View user's profile Send private message
contactop
PostPosted: Thu Sep 02, 2004 6:23 am    Post subject: Reply with quote

Acolyte

Joined: 26 Jun 2003
Posts: 50

WBIMB, doesnot have such good documentation, So it would be better if u follow the methodlogy which i had suggested, It would be a great work.
Back to top
View user's profile Send private message
PGoodhart
PostPosted: Thu Sep 02, 2004 7:16 am    Post subject: Reply with quote

Master

Joined: 17 Jun 2004
Posts: 278
Location: Harrisburg PA

Answering my own question:
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0002159.htm

That only took four hours of looking.
For anyone interested look at SQLXXXXX entries.
_________________
Patrick Goodhart
MQ Admin/Web Developer/Consultant
WebSphere Application Server Admin
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 » ODBC/CLI/SQL Return Codes (Remote User Databases)
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.