-30072   parameter subcode PARAMETER NOT SUPPORTED ERROR

Explanation

A particular parameter is not supported by either the application requester or the remote server.

Values for parameter
  • Two byte hexadecimal DDM code point.
Values for subcode
  • Two byte hexadecimal number defined as follows: This subcode is composed of two distinct parts, but may optionally be zero. The high-order byte (when not zero) indicates the site at which the error was detected. This is X'01' if the error was detected by the local DB2®; it is X'02' if the error was detected by the remote server. The low order byte is always zero.
Common parameters that are not supported include:
X'2450'
Usually this means that the server does not support the attribute clause on prepare.

System action

The command/SQL statement is rejected. A disconnect has occurred.

Programmer response

The connection to the server has been broken, and the server has therefore rolled back the unit of work. In this case, the only SQL statement that may be successfully executed is ROLLBACK. However, if the requester detects this error on a COMMIT, then it is unknown whether the unit of work was committed or rolled back at the server.

SQLSTATE

58016