Home

	Expand Search

Open ClientConnect and Open ServerConnect Messages and Codes

Chapter 1: Introduction

Chapter 1

This book describes the messages and codes that are returned by the Open ServerConnect and Open ClientConnect programs and related products. For each message, a probable cause and suggested course of action is provided.

Messages returned by the following programs and products are included:

• Open ServerConnect
  • Gateway-Library
• Open ClientConnect
  • Client-Library
  • Connection Router
  • Gateway Control Transaction
• Mainframe Client Connect

Messages you can receive from other Sybase products that are part of the network setup are covered in the DirectConnect Error Message Guide. For information on MainframeConnect messages, refer to the MainframeConnect for DB2/MVS CICS Installation and Administration Guide.

About Open ServerConnect Messages

Open ServerConnect messages fall into the following categories:

• Errors in the client request
• Messages generated by customer-written host transactions
• Messages returned from the mainframe database

Some of these messages apply only to the mainframe transaction and are important only to the mainframe programmer. Others apply to Transaction Router Service and the client's request.

Open ServerConnect reports messages for the mainframe application to the client using the Gateway-Library function TDSNDMSG.

TDSNDMSG Parameters

The TDSNDMSG function uses the following parameters to return error information:

• MESSAGE_TYPE - Message type indicator. Indicates whether the message is an informational or error message.
• MESSAGE_NUMBER - The number that identifies the message.
• SEVERITY - The severity level of the error. These levels correspond to SQL Server severity levels.

  01 - 10  Status information
  11 - 16  Client application errors
  17 - 18  Non-fatal software or hardware errors
  19 - 24  Fatal system errors

• ERROR_STATE - This number provides additional information about the context of the error for Sybase Technical Support.
• LINE_ID - The identifier that marks the line number or area of the client program where the error was detected.
• TRANSACTION_NAME - The name of the currently executing transaction.
• TRANSACTION_NAME_LENGTH - The length of the TRANSACTION_NAME parameter.
• MESSAGE_TEXT - The text of the message.
• MESSAGE_LENGTH - The length of the MESSAGE_TEXT parameter.

Gateway-Library Return Codes

Gateway-Library return codes are passed back to functions by Gateway Library, indicating the result of the function's execution. For more information about Gateway-Library functions, see the Open ServerConnect Programmer's Reference (language specific) for your programming language. For your convenience, the Gateway-Library return codes are repeated in Appendix A, "Return Codes," in this manual.

About Open ClientConnect Messages

Open ClientConnect returns two types of error messages:

• Server error messages that are returned from SQL Server, Open Server, or MainframeConnect for DB2. Server error messages are retrieved with the CTBDIAG function call using a SERVERMSG structure.
• Client error messages that are internally generated by Client-Library when it detects an error locally. Client error messages are retrieved with the CTBDIAG function call using a CLIENTMSG structure.