logo  
Google
 

DB2 SQL-Error: -30073

SQLState: 58017

Short Description: PARAMETER VALUE NOT SUPPORTED ERROR SQLCODE XAC DB DRDA DB S DB DE X U T R L DB BSDS DDF DSNLI DDF S P DB I G X U SQL DB COBOL SQL T SQLDELIMQUOTESQL I SQL SQL SQLDELIMAPOSTSQL X U C SQL XF M DYNAMICRULES I DB V DYNAMICRULESRUN DYNAMICRULES T T I DB X I X T S T SQL A P T T SQL ROLLBACK H COMMIT

The specified parameter value is not supported by either the local DB2 or the remote server. The parameter, is a 2-byte hexadecimal DDM code point. See Open Group Technical Standard, DRDA Version 3 Vol. 3: Distributed Data Management Architecture for a definition of the valid code points. Common values for parameter include: X'0035' Usually means that a DB2 server does not support the single-byte coded character set identifier (CCSID) sent by the requester, or a DB2 requester does not support the single-byte CCSID received from a server. See X'119C' for more information. X'1144' DRDA servers return this code point when a DB2 client specifies a version for a package and the DRDA server does not support versions. X'119C' If the subcode information contains X'01', the requester does not support the single-byte CCSID that the server wants to use. If the subcode information contains X'02', the server does not support the single-byte CCSID that the requester wants to use. Determine the single-byte CCSIDs for the requester and server systems. The single-byte CCSID for DB2 subsystems is defined in DSNHDECP. One or both partners might be using an incorrect CCSID, or support might need to be added. See DB2 Installation Guide for more information on CCSIDs. X'147A' DB2 servers can return this code point when a numeric input host variable is not within the range that DB2 supports. See the explanation

 <-  BACK TO INDEX