SQLSTATEs for Db2 as a web services consumer

Db2 returns SQLSTATE values for error conditions that are related to using Db2 as a web services consumer.

The following tables show possible SQLSTATE values.

Table 1. SQLSTATE values for SOAPHTTPV and SOAPHTTPC user-defined functions
SQLSTATE Description
38301 An unexpected NULL value was pass as input to the function.
38302 The function was unable to allocate space.
38304 An unknown protocol was specified ion the endpoint URL.
38305 An invalid URL was specified on the endpoint URL.
38306 An error occurred while attempting to create a TCP/IP socket.
38307 An error occurred while attempting to bind a TCP/IP socket.
38308 The function could not resolve the specified hostname.
38309 An error occurred while attempting to connect to the specified server.
38310 An error occurred while attempting to retrieve information from the protocol.
38311 An error occurred while attempting to set socket options.
38312 The function received unexpected data returned for the web service.
38313 The web service did not return data of the proper content type.
38314 An error occurred while initializing the XML parser.
38315 An error occurred while creating the XML parser.
38316 An error occurred while establishing a handler for the XML parser.
38317 The XML parser encountered an error while parsing the result data.
38318 The XML parser could not convert the result data to the database code page.
38319 The function could not allocate memory when creating a TCP/IP socket.
38320 An error occurred while attempting to send the request to the specified server.
38321 The function was unable to send the entire request to the specified server.
38322 An error occurred while attempting to read the result data from the specified server.
38323 An error occurred while waiting for data to be returned from the specified server.
38324 The function encountered an internal error while attempting to format the input message.
38325 The function encountered an internal error while attempting to add namespace information to the input message.
38327 The XML parser could not strip the SOAP envelope from the result message.
38328 An error occurred while processing an SSL connection.
Table 2. SQLSTATE values for SOAPHTTPNV and SOAPHTTPNC user-defined functions
SQLSTATE Description
38350 An unexpected NULL value was specified for the endpoint, action, or SOAP input.
38351 A dynamic memory allocation error.
38352 An unknown or unsupported transport protocol.
38353 An invalid URL was specified.
38354 An error occurred while resolving the hostname.
38355 A memory exception for socket.
38356 An error occurred during socket connect.
38357 An error occurred while setting socket options.
38358 An error occurred during input/output control (ioctl) to verify HTTPS enablement.
38359 An error occurred while reading from the socket.
38360 An error occurred due to socket timeout.
38361 No response from the specified host.
38362 An error occurred due to an unexpected HTTP return or content type
38363 The TCP/IP stack was not enabled for HTTPS.