SQL10000-19999
| SQL Message ID | Message | Explanation | User Response |
|---|---|---|---|
|
SQL10002N |
The password supplied is too long. |
The length of the password is expected to be 18 characters or less. However, if the password is to be verified for an APPC conversation, it must be 8 characters or less. |
Ensure that the password is not longer than the limit allowed. sqlcode: -10002 sqlstate: 28000 |
|
SQL10003C |
There are not enough system resources to process the request. The request cannot be processed. |
The database manager could not process the request due to insufficient system resources. The resources that can cause this error include:
|
Stop the application. Possible solutions include:
sqlcode: -10003 sqlstate: 57011 |
|
SQL10004C |
An I/O error occurred while accessing the database directory. |
Either the system database directory or the local database directory cannot be accessed. This error may occur not only when the system is cataloging or uncataloging a database but also when the system is accessing a database that is cataloged in the directory. The command cannot be processed. |
sqlcode: -10004 sqlstate: 58031 |
|
SQL10005N |
The mode parameter parameter in the CONNECT TO statement is not valid. It must be SHARE for shared access, EXCLUSIVE for exclusive use or EXCLUSIVE MODE ON SINGLE NODE for exclusive use on single node. For DB2 Connect connections, only SHARE mode is supported. EXCLUSIVE MODE ON SINGLE NODE is only supported in MPP configuration. |
The mode parameter of the CONNECT TO statement must be SHARE for shared, EXCLUSIVE for exclusive use or EXCLUSIVE MODE ON SINGLE NODE for exclusive use on single node. If connecting to a database usingDB2 Connect , only shared access is allowed. EXCLUSIVE MODE ON SINGLE NODE is only supported in MPP configuration. The command cannot be processed. |
Resubmit the command with a valid mode parameter. |
|
SQL10007N |
Message msgno could not be retrieved. Reason code: code. |
The requested message <msgno> could not be retrieved from the message file. Reason code <code> is one of the following:
|
Reissue the command after verifying the following:
If all of these things have been verified and the error still occurs, reinstall DB2. |
|
SQL10009N |
The codeset codeset and/or territory territory that has been specified is not valid. |
This version of the database manager does not support the active codeset or territory or both, as specified by the Create Database command. The command cannot be processed. |
Refer to the Create Database command in the Administration Guide for details of valid codeset and territory pairs supported by the database manager. |
|
SQL10010N |
The specified library, name, was loaded, but the function function could not be executed. |
The function routine within the library cannot be found. The command cannot be processed. |
Federated system users: If the function name is "UnfencedWrapper_Hook" or "FencedWrapper_Hook", then verify that you specified the correct library name on the CREATE WRAPPER statement. Specify the library name that does not end in "U" or "F". For example, to create the DRDA wrapper on AIX, specify library 'libdb2drda.a', but not 'libdb2drdaU.a' or 'libdb2drdaF.a.'. If the wrapper library is supplied by a vendor, then contact the vendor to get an updated version of the wrapper library. sqlcode: -10010 sqlstate: 42724 |
|
SQL10011N |
An interrupt was received while loading the specified library name. |
When loading the library, the command was interrupted, perhaps by the interrupt key (usually Ctrl+Break or Ctrl+C). Processing is stopped. |
Resubmit the command. sqlcode: -10011 sqlstate: 42724 |
|
SQL10012N |
An unexpected operating system error was received while loading the specified library name. |
An unexpected error occurred when trying to load the library module specified in the program name field. |
Resubmit the current command. If the error continues, stop the database manager and start it again. If the error continues, reinstall the database manager. If reinstallation does not correct the error, record the message number (SQLCODE) and all information in the SQLCA if possible. If trace was active, invoke the Independent Trace Facility at the operating system command prompt. Then contact IBM as specified in this guide. sqlcode: -10012 sqlstate: 42724 |
|
SQL10013N |
The specified library name could not be loaded. |
The library module could not be found. |
Ensure that the specified library is available.
If the library identifies a wrapper module, that module must be installed, link-edited (as required), and available in the correct directory. The data source client libraries (used by the wrapper module) must also be installed and available in the correct directory. sqlcode: -10013 sqlstate: 42724 |
|
SQL10014N |
The invoking program name name specified is not valid. |
The library module or the program name syntax is not correct. |
Ensure that the library or program name is specified correctly. sqlcode: -10014 sqlstate: 42724 |
|
SQL10015N |
There are not enough system resources to load the specified library name. |
There is not enough memory to load the library module. |
Stop the application. Possible solutions are:
sqlcode: -10015 sqlstate: 42724 |
|
SQL10017N |
The SQL CONNECT RESET statement is not allowed in a this context. |
The remote procedure contains an SQL CONNECT RESET statement. |
Remove the SQL CONNECT RESET statement and retry the remote procedure. sqlcode: -10017 sqlstate: 38003 |
|
SQL10018N |
The disk is full. Processing was ended. |
The disk is full. During the export to a PC/IXF file, either the PC/IXF data file is on a fixed disk, or the PC/IXF data file and the database are on the same file system , or the PC/IXF data file and the message file are on the same file system. The EXPORT utility stops processing. The exported data is not complete. |
Provide more space on the disk or specify that the data file be located on a different file system than the database or the message file and resubmit the command. |
|
SQL10019N |
The database cannot be accessed in the specified path. |
The database cannot be accessed for one of the following
reasons:
|
Ensure that the path references a valid database and that the permissions are correct. sqlcode: -10019 sqlstate: 58031 |
|
SQL10021N |
The file permissions do not allow write access to the database. |
A write operation was attempted to a database residing on a file system which does not allow write access. The statement cannot be processed. |
Verify that the file permissions for the file system on which the database resides allow write access. |
|
SQL16000N |
An XQuery expression cannot be processed because the context-component component of the static context has not been assigned. Error QName=err:XPST0001. |
Static analysis of an expression relies on a component of the static context, context-component, that has not been assigned a value. The XQuery expression cannot be processed. |
Assign a value to the context-component. sqlcode: -16000 sqlstate: 10501 |
|
SQL16001N |
An XQuery expression starting with token token cannot be processed because the focus component of the dynamic context has not been assigned. Error QName=err:XPDY0002. |
Evaluation of the expression starting with token token requires that the focus component of the dynamic context be assigned. The token is being considered as the beginning of a path expression which does not have an associated context item or context sequence. This might be the result of not defining or retrieving a sequence as a context for the path expression. Other common causes for this error:
The XQuery expression cannot be processed. |
Investigate occurrences of token token in the XQuery expression. Correct the XQuery expression around an occurrence of this token to assign a focus component or make other changes so that the token is no longer expecting an assigned focus component. sqlcode: -16001 sqlstate: 10501 |
|
SQL16002N |
An XQuery expression has an unexpected token token following text. Expected tokens may include: token-list. Error QName=err:XPST0003. |
The token that follows text is not valid where it occurs in the expression. The token-list includes one or more possible tokens that are valid replacements for the unexpected token. The XQuery expression cannot be processed. |
Use the correct syntax for the expression. sqlcode: -16002 sqlstate: 10505 |
|
SQL16003N |
An expression of data type value-type cannot be used when the data type expected-type is expected in the context. Error QName=err:XPTY0004. |
An XQuery expression includes a value of the type value-type in a context where the expected type is expected-type. The XQuery expression cannot be processed. The following rules apply to types that are used in expressions:
|
Specify a value of the correct type. sqlcode: -16003 sqlstate: 10507 |
|
SQL16004N |
The fn:data function cannot be applied explicitly or implicitly to an XQuery node for which the type annotation denotes a complex type with element-only content. Error QName=err:FOTY0012. |
An XQuery expression attempted to apply the fn:data function to an XQuery node either explicitly or implicitly as a result of atomization. However, because the type annotation of the node denotes a complex type with element-only content, the typed value of the node is undefined. The fn:data function raises a type error when applied to a node whose type is undefined. XQuery expressions use atomization to convert items into atomic values in expressions such as: arithmetic expressions, comparison expressions, function calls with arguments whose expected types are atomic, cast expressions, constructor expressions for various kinds of nodes, order by clauses in FLWOR expressions, type constructor functions, source expressions in replace value of expressions, and new name expressions in rename expressions. Processing any of these these expressions will implicitly invoke the fn:data function which could result in this error. The XQuery expression cannot be processed. |
Try one of the following actions:
sqlcode: -16004 sqlstate: 10507 |
|
SQL16005N |
An XQuery expression references an element name, attribute name, type name, function name, namespace prefix, or variable name variable-name that is not defined within the static context. Error QName=err:XPST0008. |
During the static analysis phase, the static context is used to resolve element names, attribute names, type names, function names, namespace prefixes, and variable names. If an expression uses an undefined-name that is not found in the static context, a static error is raised. The XQuery expression cannot be processed. |
Use a name that is defined within the static context. If the QName includes a prefix, verify that the namespace prefix has been bound to a namespace through a namespace declaration. If the error resulted from a variable reference, verify that the variable is in-scope for the expression. If the value of an SQL Procedural Language (SQL PL) variable is used in an XQuery expression of an XMLTABLE or XMLQUERY function, or XMLEXISTS predicate, verify that the variable name is specified in the PASSING clause that specifies input values for the expression. sqlcode: -16005 sqlstate: 10506 |
|
SQL16006N |
XML schemas cannot be imported. Error QName=err:XQST0009. |
DB2 XQuery does not support the Schema Import Feature. The schema cannot be imported. |
Remove the schema import statement from the query prolog. sqlcode: -16006 sqlstate: 10502 |
|
SQL16007N |
The XQuery path expression references an axis axis-type that is not supported. Error QName=err:XQST0010. |
The axis-type that is specified is not supported because DB2 XQuery does not support the Full Axis Feature. The supported axes include: child, attribute, descendant, self, descendant-or-self, and parent. The XQuery expression cannot be processed. |
Specify an axis that is supported. sqlcode: -16007 sqlstate: 10505 |
|
SQL16008N |
XQuery library modules cannot be declared or imported. Error QName=err:XQST0016. |
A module declaration or module import exists in an XQuery statement, but DB2 XQuery does not support the Module Feature. The module cannot be declared or imported. |
Remove all module declarations or module imports from the query prolog. sqlcode: -16008 sqlstate: 10502 |
|
SQL16009N |
An XQuery function named function-name with number-of-parms parameters is not defined in the static context. Error QName=err:XPST0017. |
The expanded QName and number-of-parms in a call to the function function-name do not match the function name and number of parameters of a function signature in the static context. The XQuery expression cannot be processed. |
Try one of the following actions:
sqlcode: -16009 sqlstate: 10506 |
|
SQL16010N |
The result of the last step in an XQuery path expression contains both nodes and atomic values. Error QName=err:XPTY0018. |
The last step in the XQuery path expression contains at least one XQuery node and one XQuery atomic value. This combination of types is not allowed as the last step in an XQuery path expression. The XQuery expression cannot be processed. |
Ensure that the last step in each XQuery path expression returns only XQuery nodes or only XQuery atomic values. sqlcode: -16010 sqlstate: 10507 |
|
SQL16011N |
The result of an intermediate step expression in an XQuery path expression contains an atomic value. Error QName=err:XPTY0019. |
Each intermediate step in an XQuery expression must evaluate to a (possibly empty) sequence of XQuery nodes. Such sequences must not include any XQuery atomic values. The XQuery expression cannot be processed. |
Modify the expression to ensure that each intermediate step in an XQuery expression returns a sequence of nodes. sqlcode: -16011 sqlstate: 10507 |
|
SQL16012N |
The context item in an axis step must be an XQuery node. Error QName=err:XPTY0020. |
In an axis step, the context item (the item currently being processed) must be an XQuery node. The XQuery expression cannot be processed. |
Modify the axis step or the input to ensure that the context item is a node. sqlcode: -16012 sqlstate: 10507 |
|
SQL16014N |
The value of the namespace declaration attribute must be a literal string. Error QName=err:XQST0022. |
An XQuery expression contains a namespace declaration attribute that is not a literal string. The value of a namespace declaration attribute must be either a literal string containing a valid URI, or a zero-length string. The XQuery expression cannot be processed. |
Specify a literal string for the value of the namespace declaration attribute. sqlcode: -16014 sqlstate: 10502 |
|
SQL16015N |
An element constructor contains an attribute node named "node-name" that follows an XQuery node that is not an attribute node. Error QName=err:error-name. |
The sequence used for constructing element content contains an attribute node named node-name that follows an XQuery node that is not an attribute node. The particular context where this occurs is based on the error QName.
The XQuery expression cannot be processed. |
Modify the content sequence to ensure that attribute nodes follow other attribute nodes. sqlcode: -16015 sqlstate: 10507 |
|
SQL16016N |
The attribute name attribute-name cannot be used more than once in an element constructor. Error QName=err:XQDY0025. |
An XQuery expression uses an attribute-name more than once in an element constructor. This is not allowed because the attribute names that are used in an element constructor must be unique. The XQuery expression cannot be processed. |
Specify a unique name for each attribute. sqlcode: -16016 sqlstate: 10503 |
|
SQL16017N |
The string "?>" is not allowed in the name expression or content expression of a computed processing instruction. Error QName=err:XQDY0026. |
The name expression or content expression of a computed processing instruction cannot contain the string “?>” because these characters are reserved for use as end delimiters in XML processing instructions. The XQuery expression cannot be processed. |
Remove the string “?>” from the name expression or content expression. sqlcode: -16017 sqlstate: 10508 |
|
SQL16018N |
For the target data type type-name, a string literal is not specified as the operand of a cast expression or as the argument of a constructor function. Error QName=err:XPST0083. |
The target data type type-name is either xs:QName or a type derived from the xs:QName or xs:NOTATION predefined XML schema types. For any of these types, a string literal must be specified as the operand of a cast expression or as the argument of a constructor function. The XQuery expression cannot be processed. |
Perform one of the following actions:
sqlcode: -16018 sqlstate: 10510 |
|
SQL16020N |
The context node in a path expression does not have an XQuery document node root. Error QName=err:XPDY0050. |
The root node above the context node in a path expression must be an XQuery document node. The XQuery expression cannot be processed. |
Change the each path expression so that the context node has a root node that is an XQuery document node. sqlcode: -16020 sqlstate: 10507 |
|
SQL16021N |
The XQuery version declaration specifies a number version-number that is not supported. Error QName=err:XQST0031. |
DB2 XQuery does not support the XQuery version-number that is specified in a version declaration. The XQuery expression cannot be processed. |
Specify a version-number that is supported by DB2 XQuery. DB2 XQuery currently supports XQuery version 1.0. sqlcode: -16021 sqlstate: 10502 |
|
SQL16022N |
A value of type value-type is not valid in an expression that uses operation operator. Error QName=err:XPTY0004. |
The type value-type that is defined for an operand of an XQuery expression is not valid because the expression uses the constructor or operator operator. The XQuery expression cannot be processed. |
Specify a value that is the correct type to use with the constructor or operator operator. sqlcode: -16022 sqlstate: 10507 |
|
SQL16023N |
The XQuery prolog cannot contain multiple declarations for the same namespace prefix ns-prefix. Error QName=err:XQST0033. |
The prolog contains multiple declarations for the namespace prefix ns-prefix. Although a namespace declaration in a prolog can override a prefix that has been predeclared in the static context, the same namespace prefix cannot be declared more than once in the prolog. The XQuery expression cannot be processed. |
Remove any extra declarations for the prefix from the prolog, or change the prefix that is assigned to the extra declarations. Verify that the prefixes used in the query reference the correct namespaces. sqlcode: -16023 sqlstate: 10503 |
|
SQL16024N |
The prefix prefix-name cannot be redeclared or cannot be bound to the URI http://www.w3.org/XML/1998/namespace. Error QName=err:XQST0070. |
A namespace declaration or a namespace declaration attribute cannot redeclare the predefined namespace prefixes "xml" or "xmlns".
The XQuery expression cannot be processed. |
Perform one of the following actions:
sqlcode: -16024 sqlstate: 10503 |
|
SQL16025N |
The result of the content expression of an XQuery computed comment constructor contains two adjacent hyphens or ends with a hyphen character. Error QName=err:XQDY0072. |
The content specified for an XQuery computed comment constructor includes combinations of characters that are not allowed. This could be two adjacent hyphen (or dash) characters or the last character is a hyphen. The XQuery expression cannot be processed. |
Remove the invalid uses of hyphen characters from the content expression of each XQuery computed comment constructor. sqlcode: -16025 sqlstate: 10508 |
|
SQL16026N |
The name attribute-name is used for more than one attribute in the constructor for the element named element-name. Error QName=err:XQST0040. |
The name attribute-name in element-name cannot be used more than once because element constructors must use unique names for attributes. The XQuery expression cannot be processed. |
Use unique names for all attributes in element-name. sqlcode: -16026 sqlstate: 10503 |
|
SQL16027N |
The value of the name expression value in a computed processing instruction constructor is not valid. Error QName=err:XQDY0041. |
The atomized value of the name expression value is of type xs:string or xdt:untypedAtomic, but the value cannot be cast to xs:NCName. The XQuery expression cannot be processed. |
Change the value of the name expression to a value that can be atomized and then cast to the type xs:NCName. sqlcode: -16027 sqlstate: 10508 |
|
SQL16029N |
Two or more namespaces within the same XQuery element constructor use the same namespace prefix prefix-name. Error QName=err:XQST0071. |
The namespace prefix prefix-name cannot be used more than once in the same XQuery computed element constructor. If prefix-name is "xmlns", then more that one default namespace is specifed in the XQuery computed element constructor. The XQuery expression cannot be processed. |
Use unique namespace prefixes for local namespace declarations in the computed element constructor. Also, verify that the expression does not include more than one local namespace declaration that has no prefix. sqlcode: -16029 sqlstate: 10503 |
|
SQL16030N |
The value value returned by the name expression of a computed attribute constructor is in the namespace for the prefix xmlns, or is in no namespace and has the local name xmlns. Error QName=err:XQDY0044. |
It is an error for the name expression of a computed attribute constructor to return a QName that is in the namespace http://www.w3.org/2000/xmlns/ (corresponding to namespace prefix xmlns), or return a QName that is in no namespace and has the local name xmlns. The namespace prefix xmlns is used in XQuery to identify namespace declaration attributes. The XQuery expression cannot be processed. |
Modify the name expression of the computed attribute constructor to return a value that is not in the namespace for the prefix xmlns. sqlcode: -16030 sqlstate: 10508 |
|
SQL16031N |
XQuery language feature using syntax string is not supported. |
The XQuery expression includes the syntax indicated in string that is defined by the standard XQuery language specifications but is not supported in DB2 XQuery. The XQuery expression cannot be processed. |
Remove the unsupported expression starting with the syntax string from the XQuery expression. sqlcode: -16031 sqlstate: 10509 |
|
SQL16032N |
The string string is not a valid URI. Error QName=err:XQST0046. |
A namespace declaration or namespace declaration attribute specifies a string value that is not a valid URI. The XQuery expression cannot be processed. |
Specify a string value that is a valid URI. A valid URI must conform to the generic URI syntax specified by the World Wide Web Consortium (W3C). sqlcode: -16032 sqlstate: 10504 |
|
SQL16033N |
The target data type type-name of a cast or castable expression is not an atomic data type defined for the in-scope XML schema types or is a data type that cannot be used in a cast or castable expression. Error QName=err:XPST0080. |
The cast or castable expression specifies a target data type type-name that cannot be used. The predefined XML schema types xs:NOTATION, xs:anySimpleType, and xdt:anyAtomicType cannot be used as the target type of a cast or castable expression. If type-name is not one of these restricted types, then either the data type is not defined for the in-scope XML schema types or the data type is not an atomic type. The XQuery expression cannot be processed. |
Perform one of the following actions:
sqlcode: -16033 sqlstate: 10507 |
|
SQL16034N |
The QName qname is used as an atomic type in a sequence type, but is not defined in the in-scope schema type definitions as an atomic type. Error QName=err:XPST0051. |
The QName qname cannot be used as an atomic type because it is not defined in the in-scope schema type definitions as an atomic type. Error QName=err:XPST0051. |
Use a QName that is defined as an atomic type. sqlcode: -16034 sqlstate: 10503 |
|
SQL16035N |
A validate expression is not supported in DB2 XQuery. Error QName=err:XQST0075. |
The validation feature is not supported in DB2 XQuery, so a validate expression cannot be used as an XQuery expression. The XQuery expression cannot be processed. |
Remove all validate expressions from the XQuery expression. sqlcode: -16035 sqlstate: 10509 |
|
SQL16036N |
The URI that is specified in a namespace declaration cannot be a zero-length string. Error QName=err:XQST0085. |
The URI that is specified in a namespace declaration must be a valid URI that conforms to the generic URI syntax specified by the World Wide Web Consortium (W3C). The URI cannot be a zero-length string. The XQuery expression cannot be processed. |
Specify a valid URI in the namespace declaration. sqlcode: -16036 sqlstate: 10504 |
|
SQL16038N |
The arguments of fn:dateTime have different timezones. Error QName=err:FORG0008. |
The function fn:dateTime includes arguments that have different timezones. The timezone of both arguments could be explicitly part of the value or may be result from the use of the implicit timezone for the XQuery execution environment for one of the arguments. The XQuery expression cannot be processed. |
Ensure that the same timezone is used for both arguments of fn:dateTime. sqlcode: -16038 sqlstate: 10608 |
|
SQL16039N |
The function function name expected a string literal for argument argument-number. |
The function identified by function name requires that the argument number argument-number be specified as a string literal. The XQuery expression includes an invocation of function function name that does not use a string literal. The XQuery expression cannot be processed. |
Change argument argument-number of function function name to a string literal. sqlcode: -16039 sqlstate: 10608 |
|
SQL16040N |
The argument of function function name does not identify a single column with SQL data type XML. |
The function function name requires that the argument specify an SQL result table with a single column of data type XML. For db2-fn:xmlcolumn this is done by specifying a column within a table or view with the SQL data type XML. For db2-fn:sqlquery, the SQL query provided as an argument must specify a single column in the outer fullselect that has an SQL data type of XML. |
Correct the argument of function function name to return a single column with SQL data type XML. sqlcode: -16040 sqlstate: 10608 |
|
SQL16041N |
An implicit or explicit invocation of the fn:boolean function in the XQuery expression could not compute the effective boolean value of the sequence. Error QName=err:FORG0006. |
This error occurs if the effective boolean value of the sequence operand of an explicit or implicit invocation of the fn:boolean function cannot be computed for the sequence operand. The effective boolean value can be computed only if the sequence operand is one of the following sequences:
The XQuery expression cannot be processed. |
Determine the possible expressions within the XQuery expression where an effective boolean value is calculated either implicitly or explicitly. An implicit invocation of the fn:boolean function can occur when processing the following types of expressions:
Ensure that the sequence operand of each effective boolean value calculation would have a valid sequence operand (one described in the explanation). sqlcode: -16041 sqlstate: 10608 |
|
SQL16042N |
The name expression in a computed processing instruction constructor cannot be equal to "XML" in any combination of upper and lower case characters. Error QName=err:XQDY0064. |
The NCName that results from the name expression of a computed processing instruction constructor cannot be equal to the string of characters XML in any combination of upper or lower case characters. The XQuery expression cannot be processed. |
Modify the name expression to result in an NCName that is not equal to XML. sqlcode: -16042 sqlstate: 10508 |
|
SQL16045N |
An unidentified error was issued from an XQuery expression. Error QName=err::FOER0000. |
An XQuery expression resulted in an unidentified error. |
Fix the problem in the XQuery expression. sqlcode: -16045 sqlstate: 10611 |
|
SQL16046N |
A numeric XQuery expression attempted to divide by zero. Error QName=err:FOAR0001. |
A division or modulus operation attempted to divide an integer or decimal value by zero. The XQuery expression cannot be processed. |
Use a value for the divisor that is not equal to zero. sqlcode: -16046 sqlstate: 10601 |
|
SQL16047N |
An XQuery expression resulted in arithmetic overflow or underflow. Error QName=err:FOAR0002. |
An arithmetic operation resulted in a number that either exceeded the maximum or was below the minimum value allowed. The XQuery expression cannot be processed. |
Modify the expression to result in a number that does not result in an arithmetic overflow or underflow. sqlcode: -16047 sqlstate: 10601 |
|
SQL16048N |
An XQuery prolog cannot contain more than one declaration-type declaration. Error QName=err:error-qname. |
Declaring more than one declaration-type declaration in a prolog results in an error. The declaration-type declaration type is one of the following declarations that can be specified in an XQuery prolog:
This error could be returned for a variety of error QNames such as err:XQST0055, err:XQST0065, err:XQST0066, err:XQST0067, err:XQST0068, and err:XQST0069. The XQuery expression cannot be processed. |
Remove the extra declaration of type declaration-type from the prolog. sqlcode: -16048 sqlstate: 10502 |
|
SQL16049N |
The lexical value value is not valid for the date-type data type in the function or cast. Error QName=err:FOCA0002. |
A cast expression or function call includes a value that does not have the correct lexical form for the type-name data type. The XQuery expression cannot be processed. |
Try one of the following actions:
sqlcode: -16049 sqlstate: 10602 |
|
SQL16051N |
The value "value" of data type "source-type" is out of range for an implicit or explicit cast to target data type "target-type". Error QName=err:error-name. |
An XQuery expression requires that the value value with a data type of source-type be cast, either implicitly or explicitly to the target data type target-type. The value is outside the defined range of values for that data type. If the target-type is xs:dateTime or a data type derived from xs:dateTime, then the range applies to the value in the specified timezone and to the value converted to UTC using the timezone component of the value. This error could be returned for a variety of error QNames such as err:FOAR0002, err:FOCA0001, err:FOCA0003, err:FODT0001, err:FODT0002, and err:FORG0001. The XQuery expression cannot be processed. |
Change the XQuery expression to use a target data type with a range that supports the specific value value, or change the value to be within the defined range of the target data type target-type. sqlcode: -16051 sqlstate: 10602 |
|
SQL16052N |
NaN cannot be used as a float or double value in a datetime operation. Error QName=err:FOCA0005. |
NaN was passed as an argument to a datetime operation, but NaN is not a valid parameter value for datetime operations. The XQuery expression cannot be processed. |
Pass a valid float or double value to the datetime operation. sqlcode: -16052 sqlstate: 10602 |
|
SQL16053N |
The codepoint codepoint is not valid in a character string. Error QName=err:FOCH0001. |
A value that was passed to the fn:codepoints-to-string function in an XQuery expression contains a codepoint that is not a legal XML character. The XQuery expression cannot be processed. |
Modify the argument to pass in valid codepoints only, or remove the expression. sqlcode: -16053 sqlstate: 10603 |
|
SQL16054N |
The normalization form form that is specified as an argument of the function fn:normalize-unicode is not supported. Error QName=err:FOCH0003. |
The effective value form that was passed as the normalization form argument to the fn:normalize-unicode function is not supported. The effective value of the normalization form is computed by removing leading and trailing blanks, if present, and converting to upper case. The XQuery expression cannot be processed. |
Pass a supported normalization form to the fn:normalize-unicode function. sqlcode: -16054 sqlstate: 10603 |
|
SQL16055N |
An arithmetic operation involving a datetime value resulted in overflow. Error QName=err:FODT0001. |
An arithmetic operation involving a datetime value resulted in a number that exceeded the maximum value allowed. The XQuery expression cannot be processed. |
Modify the XQuery expression to result in a number that does not exceed the maximum value allowed. sqlcode: -16055 sqlstate: 10605 |
|
SQL16056N |
An arithmetic operation involving a duration value resulted in overflow. Error QName=err:FODT0002. |
An arithmetic operation involving a duration value resulted in a number that exceeded the maximum value allowed. The XQuery expression cannot be processed. |
Modify the XQuery expression to result in a number that does not exceed the maximum value allowed. sqlcode: -16056 sqlstate: 10605 |
|
SQL16057N |
A timezone value value is not valid. Error QName=err:FODT0003. |
An XQuery expression specifies a timezone value that is less than -PT14H00M or greater than PT14H00M. The XQuery expression cannot be processed. |
Specify a timezone value that is greater than -PT14H00M or less than PT14H00M. sqlcode: -16057 sqlstate: 10605 |
|
SQL16058N |
No context item is defined for the function or operation function-or-operation. Error QName=err:FONC0001. |
The function or operation name relies on a context item, but no context item is defined. The XQuery expression cannot be processed. |
Modify the XQuery expression to ensure that a context item is defined for the function or operation name. If the function or operation uses the context item because an argument is omitted, then modify the expression to ensure that the context item is defined before the function is invoked. sqlcode: -16058 sqlstate: 10606 |
|
SQL16059N |
No statically known namespace exists for the prefix in the value value cast to xs:QName. Error QName=err:FONS0003. |
An XQuery expression that casts to xs:QName specifies a value that uses a prefix, but the prefix cannot be mapped to a URI because there is no statically known namespace for the specified prefix. The XQuery expression cannot be processed. |
In the cast expression, specify a prefix in the value that exists as a statically known namespace. If the prefix is correct, ensure that there is a namespace declaration for the specified prefix. sqlcode: -16059 sqlstate: 10607 |
|
SQL16060N |
No namespace was found for the prefix in the QName qname. Error QName=err:FONS0004. |
The expanded QName of an element could not be resolved because no namespace exists for the prefix that is specified in the QName. The XQuery expression cannot be processed. |
Add a namespace declaration to bind the prefix to a URI, or specify a different prefix in the QName. sqlcode: -16060 sqlstate: 10607 |
|
SQL16061N |
The value value cannot be constructed as, or cast (using an implicit or explicit cast) to the data type data-type. Error QName=err:FORG0001. |
An XQuery expression attempted to use the value value as a data-type value but the value is not valid for the data type. The following situations might cause this error:
The XQuery expression cannot be processed. |
Try one of the following actions:
sqlcode: -16061 sqlstate: 10608 |
|
SQL16062N |
The argument passed to the function fn:zero-or-one is not valid because the sequence contains more than one item. Error QName=err:FORG0003. |
A sequence that was passed as an argument to the function fn:zero-or-one contains more than one item. The XQuery expression cannot be processed. |
Modify the expression to ensure that the sequence passed to the function fn:zero-or-one contains only one item or is an empty sequence. sqlcode: -16062 sqlstate: 10608 |
|
SQL16063N |
The argument passed to the function fn:one-or-more is not valid because the sequence is empty. Error QName=err:FORG0004. |
A sequence that was passed as an argument to the function fn:one-or-more is empty. |
Modify the expression to ensure that the sequence passed to the function fn:one-or-more is not an empty sequence. sqlcode: -16063 sqlstate: 10608 |
|
SQL16064N |
The argument passed to the function fn:exactly-one is not valid because the sequence is empty or contains more than one item. Error QName=err:FORG0005. |
A sequence that was passed as an argument to the function fn:exactly-one does not contain exactly one item. |
Modify the expression to ensure that the sequence passed to the function fn:exactly-one contains exactly one item. sqlcode: -16064 sqlstate: 10608 |
|
SQL16065N |
An empty sequence cannot be constructed as, or cast to, the data type datatype. Error QName=err:FORG0006. |
The data type datatype that is specified in a constructor or cast expression does not support casting or constructing an empty sequence of the specified type. |
Pass a value that is not an empty sequence to the constructor or cast expression. sqlcode: -16065 sqlstate: 10608 |
|
SQL16066N |
The argument passed to the aggregate function function-name is not valid. Error QName=err:FORG0006. |
The argument that was passed to the aggregate function function-name is not valid because the argument does not meet any of the conditions that are required for arguments to the function function-name. |
Try one of the following actions:
sqlcode: -16066 sqlstate: 10608 |
|
SQL16067N |
The flags argument value passed to the function function-name is not valid. Error QName=err:FORX0001. |
The function function-name includes a value that was passed to the function as a regular expression flag parameter. However, the string that was passed to the function includes characters that are not defined as flags. |
Modify the function call to pass in a string argument that contains only characters that are defined as flags. Valid characters include s, m, i, or x. sqlcode: -16067 sqlstate: 10609 |
|
SQL16068N |
The regular expression argument value passed to the function function-name is not valid. Error QName=err:FORX0002. |
The value that was passed to the function function-name is not valid according to the rules that are specified for regular expressions in XQuery. These rules are based on the regular expression syntax specified in XML Schema, with some extensions added to the syntax to accommodate XQuery. See the product documentation for a description of XQuery-specific extensions to the regular expression syntax for XML Schema. |
Specify a valid value for the regular expression. sqlcode: -16068 sqlstate: 10609 |
|
SQL16069N |
A regular expression argument value passed to the function function-name matches a zero-length string. Error QName=err:FORX0003. |
The value that was specified for the pattern parameter in a call to the function function-name matches a zero-length string. A zero-length string is not a valid pattern for this function because the pattern will never match a substring in the input string. |
Pass a valid pattern to the function call, or remove the function call from the expression. sqlcode: -16069 sqlstate: 10609 |
|
SQL16070N |
The replacement string argument value passed to the function fn:replace is not valid. Error QName=err:FORX0004. |
The value that was specified for the replacement string parameter in a call to the function fn:replace is not valid because the value includes one or more of the following invalid characters:
|
Use a value for the replacement string that includes valid characters only. sqlcode: -16070 sqlstate: 10609 |
|
SQL16071N |
The function function-name cannot be processed because the context item assumed to be the argument is not an XQuery node. Error QName=err:FOTY0011. |
The function function-name relies on a context node, but the context item is not a node. |
Modify the XQuery expression to ensure that the context item is a node. If the function uses the context item because an argument is omitted, then modify the expression to ensure that the context item is a node before the function is invoked. sqlcode: -16071 sqlstate: 10610 |
|
SQL16072N |
The items of the sequence argument of function fn:index-of are not comparable with the search argument. Error QName=err:FOTY0012. |
The sequence argument that was passed to the fn:index-of function is not valid because the items in the sequence are not comparable with the search argument. |
Pass a sequence to the function fn:index-of that contains items that are comparable with the search argument. sqlcode: -16072 sqlstate: 10610 |
|
SQL16074N |
An XQuery atomic value with the lexical representation starting with value of type type-name cannot be processed in the XQuery operation or function name because the length exceeds the operation or function limit of size bytes. |
An XML document contains an atomic value with the lexical representation starting with value that exceeds size bytes, which is the size limit for the XQuery data type type-name when used in the XQuery operation or function indicated by name. The statement attempts to use the atomic value in name. The statement cannot be processed. |
Possible ways to avoid this length limitation include:
sqlcode: -16074 sqlstate: 10902 |
|
SQL16075N |
The sequence to be serialized contains an item that is an attribute node. Error QName=err:SENR0001. |
A request was made to serialize an XML value. The XML value is a sequence containing an item that is an XQuery attribute node. There is no defined sequence normalization for an attribute node as an item in a sequence and therefore the sequence cannot be serialized. The statement cannot be processed. |
Remove any items in the sequence containing just an attribute node or do not attempt to serialize the sequence. sqlcode: -16075 sqlstate: 2200W |
|
SQL16076N |
The internal identifier limit of limit has been exceeded for the number of matched XQuery nodes. |
An XQuery expression that is matching XQuery nodes is limited to limit matching nodes. The XQuery expression that returned this error has exceeded the limit for the number of matching XQuery nodes. The statement cannot be processed. |
The XQuery expression should be modified to avoid the use of wildcards, the node() kind test, or descendant axes. Alternatively, the XQuery expression should be performed over a value with a reduced number of XQuery nodes, possibly by splitting the value into smaller values. sqlcode: -16076 sqlstate: 10903 |
|
SQL16077N |
The value of a name expression name-string in a computed element constructor, a computed attribute constructor, or a rename expression cannot be converted to an expanded QName. Error QName=err:XQDY0074. |
The value of name-string has a data type of xs:string or xs:untypedAtomic that must be converted to an expanded QName. The conversion fails if the string does not conform to the lexical form of an xs:QName value or if the namespace prefix of the value is not found in the statically known namespaces of the XQuery. The XQuery expression cannot be processed. |
Ensure that the name expression returns a valid string-name in the lexical form of an xs:QName that can be converted to an expanded QName in the XQuery expression. If the namespace prefix is not in the statically known namespaces, add a namespace declaration in the XQuery prolog to associate a namespace URI with the namespace prefix in the string-name. sqlcode: -16077 sqlstate: 10508 |
|
SQL16080N |
An XQuery expression includes one or more expression-type expressions outside the modify clause of a transform expression. Error QName=err:XUST0001. |
A basic updating expression is specified in an expression that is not part of the modify clause of a transform expression. One or more expression-type expressions results in an updating expression in a context where only a non-updating expression can be specified. The XQuery expression cannot be processed. |
Remove the expression-type expression and any other basic updating expressions from any expression that is not contained in the modify clause of a transform expression. sqlcode: -16080 sqlstate: 10701 |
|
SQL16081N |
An XQuery expression in the modify clause of a transform expression is not an updating expression or an empty sequence expression. Error QName=err:XUST0002. |
The expression in the modify clause of a transform expression is a non-updating expression other than an empty sequence expression. The expression in the modify clause of a transform expression must be an updating expression or an empty sequence expression. The XQuery expression cannot be processed. |
Ensure that the expression in the modify clause of every transform expression includes a basic updating expression or is the empty sequence expression. sqlcode: -16081 sqlstate: 10702 |
|
SQL16082N |
A target node in one or more expression-type expressions is not a node that was newly created in the copy clause of the transform expression. Error QName=err:XUDY0014. |
A target node of a basic updating expression must be a node that was newly created by the copy clause of the transform expression. One or more expression-type expressions has a target node that is not newly created. The XQuery expression cannot be processed. |
Ensure that the target nodes for every expression-type expression and any other basic updating expressions are newly created by the copy clause of the transform expression. sqlcode: -16082 sqlstate: 10703 |
|
SQL16083N |
Incompatible "expression-type" expressions exist in the modify clause of a transform expression. Error QName=err:error-name. |
The modify clause of a transform expression includes multiple expression-type expressions that operate on the same target node. These basic updating expressions are not compatible since the result would be nondeterministic based on the order of processing the expression-type expressions. The following list gives the reason for the error based on the error QName:
The XQuery expression cannot be processed. |
Change the expression in the modify clause of the transform expression to ensure that no two expression-type expressions have the same target node. sqlcode: -16083 sqlstate: 10704 |
|
SQL16084N |
An assigned value in the copy clause of a transform expression is not a sequence with exactly one item that is a node. Error QName=err:XUTY0013. |
The evaluation of the copy clause of a transform expression resulted in one or more invalid assignments. At least one assigned value was an empty sequence, a sequence with multiple items, or an atomic value. The assigned value must be a sequence with exactly one item that is a node. The XQuery expression cannot be processed. |
Ensure that every copy source expression in the copy clause of the transform expression returns a sequence with exactly one item that is a node. sqlcode: -16084 sqlstate: 10705 |
|
SQL16085N |
The target node of an XQuery expression-type expression is not valid. Error QName=err: error-name. |
The following list describes the reasons why the target node of a basic updating expression is not valid based on the error QName:
The XQuery expression cannot be processed. |
Correct the expression-type expression to use a valid target node as described in the explanation. sqlcode: -16085 sqlstate: 10703 |
|
SQL16086N |
The replacement sequence of a replace expression contains invalid nodes for the specified target node. Error QName=err:error-name. |
A node in the replacement sequence cannot be used to replace the target node. The reason is listed based on the error Qname:
The XQuery expression cannot be processed. |
Correct the source expression in the with clause of the replace expression to ensure that the replacement sequence contains only valid nodes for the target node. sqlcode: -16086 sqlstate: 10706 |
|
SQL16087N |
The result of an XQuery transform expression is not a valid instance of the XQuery and XPath data model. Additional information: token1, token2. Error QName=err:XUDY0021. |
The result of applying the updating expressions contained in a transform expression would result in an invalid instance of the XQuery and XPath data model (XDM). The specific constraint violation in the XDM instance can be identified from the additional information included in the tokens. If token1 is "attribute", then token2 is the name of an attribute that has occurred more than once in a target element, after applying the updating expressions in the transform expression. The XQuery expression cannot be processed. |
Correct the transform expression to ensure that the resulting instance of the XDM is correct. If token1 is "attribute" ensure that any updating expressions involving attributes do not use the name of an attribute that already exists in the target element and is not deleted or replaced within the same transform. sqlcode: -16087 sqlstate: 10707 |
|
SQL16088N |
An expression-type expression has a binding of a namespace prefix prefix-string to namespace URI uri-string, introduced to an element named element-name, that conflicts with an existing namespace binding of the same prefix to a different URI in the in-scope namespaces of that element node. Error QName=err:XUDY0023. |
An expression-type expression has introduced a new namespace binding for prefix prefix-string using URI uri-string into an element node named element-name that conflicts with one of the existing namespace bindings of the in-scope namespaces of that node. The element node could be the target in the updating expression or the parent of the target in the updating expression. For example, an insert expression might insert an attribute into an existing element. If the QName of the inserted attribute binds prefix P to some URI, but an in-scope namespace of the element node binds the same prefix P to a different URI, a conflict is detected and this error is raised. |
If the expression-type expression is intentionally introducing a new namespace binding, modify the expression so that it uses a namespace prefix that is different from all existing prefixes of the in-scope namespaces of the element named element-name. Alternatively, modify the expression so that the binding of prefix-string uses the same URI as the existing namespace binding of the in-scope namespaces of the element named element-name. sqlcode: -16088 sqlstate: 10708 |
|
SQL16089N |
An expression-type expression and possibly other updating expressions in the modify clause of a transform expression introduce conflicting namespace bindings into an element named element-name. The prefix prefix-string is bound to uri-string1 while another binding of the same prefix uses a different namespace URI. Error QName=err:XUDY0024. |
The combined effect of the updating expressions in the modify clause of a transform expression has been to introduce conflicting namespace bindings into element node named element-name. For example, two attributes might have been inserted whose QNames have the same namespace prefix but different namespace URIs. If expression-type is 'insert' or 'replace' the conflicting namespace bindings may be between 2 attribute nodes in the sequence of attribute nodes in the insertion sequence or replacement sequence. The conflict could also be with a namespace binding introduced to the element element-name for an attribute node that was inserted, replaced or renamed by another updating expression in the same modify clause of the transform expression. If expression type is 'rename', the namespace binding for the new name conflicts with a namespace binding also introduced to the element element-name for a node that was inserted, replaced or renamed by another updating expression in the same modify clause of the transform expression. |
If the expression-type expression is intentionally introducing a new namespace binding, modify the expression so that it uses a namespace prefix that is different from all other prefixes used in the updating expressions of the same transform expression that have the element named element-name as the target or parent of an attribute node target. Alternatively, modify the expression so that the binding of prefix-string uses the same URI as the other namespace bindings used in the updating expressions of the same transform expression that have the element named element-name as the target or parent of an attribute node target. sqlcode: -16089 sqlstate: 10708 |
|
SQL16090N |
The target of a rename expression is a processing instruction node and the namespace prefix of the QName qname-string is not empty. Error QName=err:XUDY0025. |
A transform expression includes a rename expression that has a target node that is a processing instruction node. The new name expression in the rename expression results in the QName qname-string that has a prefix that is not empty. The name of a processing instruction must not include a prefix. |
Change the new name expression of the rename expression so that the resulting QName has an empty prefix. sqlcode: -16090 sqlstate: 10709 |
|
SQL16100N |
XML document contains duplicate declarations for <!notation notation-name>. |
While parsing an XML document the XML parser encountered more than one declaration for the notation with name notation-name. Parsing or validation did not complete. |
Remove the duplicate notations from the XML document and try the operation again. sqlcode: -16100 sqlstate: 2200M |
|
SQL16101N |
XML schema contains an attribute attribute-name that has been declared more than once for element element-name. |
While parsing an XML document, two or more attributes with the same name attribute-name were found for an element named element-name. Parsing or validation did not complete. |
Correct the XML schema and try the operation again. sqlcode: -16101 sqlstate: 2200M |
|
SQL16102N |
XML document contains a notation declaration with name notation-name that is not found, is not a valid notation declaration, or does not have a valid QName. |
While parsing an XML document, the declaration for the identified XML notation identified by notation-name was not found in the document or associated schema/DTD, is incorrectly declared, or does not have a valid QName. Parsing or validation did not complete. |
Correct the XML notation identified by notation-name and try the operation again. sqlcode: -16102 sqlstate: 2200M |
|
SQL16103N |
A character was found in an XML document that is invalid or cannot be represented in the document encoding. |
While parsing an XML document the parser found a character that was invalid or is not represented in the document encoding. Parsing did not complete. |
Correct the XML document and try the operation again. sqlcode: -16103 sqlstate: 2200M |
|
SQL16104N |
Internal error encountered in XML parser. Parser error is parser-error. |
While parsing an XML document the parser encountered an internal error parser-error. The value of parser-error is the internal parser error code. Parsing or validation did not complete. |
Try the operation again and if the error persists, contact IBM service. sqlcode: -16104 sqlstate: 2200M |
|
SQL16105N |
Incorrect XML data. Expected data of type type-name and found value value which is not a valid value for that type. |
While processing an XML document or XML schema the XML parser expected to find data of a certain type and found a value that could not be converted to that type. If the data type is listed as 'datetime' the data type is one of the date or time data types such as date, time, duration, gDay, gMonth, gMonthDay, gYear. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16105 sqlstate: 2200M |
|
SQL16106N |
Invalid XML facet specified for data type type-name of the node. |
While parsing an XML document the parser found a facet specified that was not legal or supported for the specified data type of the node. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16106 sqlstate: 2200M |
|
SQL16107N |
XML schema contains an error in facet facet-name. One reason is reason-code. |
While processing an XML schema the XML parser found an error with the specified facet. One or more of the following reasons hold true:
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16107 sqlstate: 2200M |
|
SQL16108N |
XML schema contains an invalid combination of facets facet1 and facet2. One reason is reason-code. |
While parsing an XML document the parser found specified facets identified by facet1 and facet2 that are either mutually exclusive or have conflicting or invalid values. The reason-code indicates one of the possible reasons as described here.
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16108 sqlstate: 2200M |
|
SQL16109N |
XML document contains an invalid comment. Reason code = reason-code. |
While parsing an XML document the parser encountered an invalid comment. Possible values for reason-code include:
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16109 sqlstate: 2200M |
|
SQL16110N |
XML syntax error. Expected to find construct. |
While parsing an XML document, the parser expected to find a certain construct and did not. The XML is either not well formed, or not valid depending on the operation. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16110 sqlstate: 2200M |
|
SQL16111N |
XML Document contains an invalid CDATA section. Reason code = reason-code. |
While parsing an XML document the parser encountered an invalid or ill formed CDATA section indicated by reason-code. Possible reason codes are:
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16111 sqlstate: 2200M |
|
SQL16112N |
XML schema contains an element or attribute definition in error because 'name' or 'ref' was missing and required. Reason code = reason-code. |
While processing an XML schema the XML parser encountered an incorrect element or attribute definition. Value for reason-code corresponds to one of the following reasons:
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16112 sqlstate: 2200M |
|
SQL16113N |
XML document or XML schema contains an attribute attribute-name that is in error. Reason code = reason-code. |
While parsing an XML document the parser encountered an attribute that is not correctly defined or used. Possible reasons given by reason-code are:
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16113 sqlstate: 2200M |
|
SQL16114N |
XML document contains an ID with a duplicate value value. |
While parsing an XML document the parser encountered an ID value value that had previously been declared with the document. ID values must be unique with a document. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16114 sqlstate: 2200M |
|
SQL16115N |
XML document contains an element or attribute named name with an unresolved namespace prefix. |
While parsing an XML document the parser encountered an element or attribute, identified by the name name, whose namespace prefix cannot be resolved to a URI. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16115 sqlstate: 2200M |
|
SQL16116N |
XML document contains a duplicate value value in a type declaration. |
While parsing an XML document the parser encountered a duplicate value in the type declaration. A type declaration can only specify 'substitution', 'union', 'extension', 'list', or 'restriction' once. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16116 sqlstate: 2200M |
|
SQL16117N |
XML document declares an entity entity-name that is not terminated. |
While parsing an XML document the parser encountered an entity declaration for entity-name without the expected termination character. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16117 sqlstate: 2200M |
|
SQL16118N |
XML document declares an element with name element-name that is not terminated. |
While parsing an XML document the parser encountered an element declaration with name entity-name without the expected termination character. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16118 sqlstate: 2200M |
|
SQL16119N |
XML document contains an entity reference to entity-name that is not terminated. |
While parsing an XML document the parser encountered an entity reference to entity-name without the expected termination character. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16119 sqlstate: 2200M |
|
SQL16120N |
Document Type Definition (DTD) contains a content model specification for element element-name that was not terminated. |
While processing a DTD, the XML parser encountered a content model that was not terminated for an element named element-name. Parsing or validation did not complete. |
Correct the DTD and try the operation again. sqlcode: -16120 sqlstate: 2200M |
|
SQL16121N |
XML document contains an entity literal that is not terminated for an entity named entity-name. |
While parsing an XML document the parser encountered an entity literal that was not terminated that is associated with an entity named entity-name. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16121 sqlstate: 2200M |
|
SQL16122N |
XML document contains an invalid character reference codepoint. |
While parsing an XML document the parser encountered an invalid character reference that has the code point value of codepoint. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16122 sqlstate: 2200M |
|
SQL16123N |
XML document contains an element element-name with empty content where the content model requires content for this element. |
While parsing an XML document the parser encountered an element named element-name that included no content. The content model for the element does not allow empty content. Parsing or validation did not complete. |
Add content to the element or remove the element from the document and try the operation again. sqlcode: -16123 sqlstate: 2200M |
|
SQL16124N |
XML document contains an end tag that is not terminated for a tag with name tag-name. |
While parsing an XML document the parser encountered an end tag that was not terminated that is associated with an tag named entity-name.. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16124 sqlstate: 2200M |
|
SQL16125N |
XML document contains an invalid character with code point codepoint in the internal subset. |
While parsing an XML document, the parser encountered an invalid character defined with code point codepoint in the internal subset. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16125 sqlstate: 2200M |
|
SQL16126N |
Document Type Definition (DTD) contains an element element-name in the content model that was not declared. |
While parsing a DTD the parser encountered an element with name element-name in the content model that was not declared. Parsing or validation did not complete. |
Correct the DTD and try the operation again. sqlcode: -16126 sqlstate: 2200M |
|
SQL16127N |
A DTD contains unexpected whitespace before the character '?', '*', or '+'. |
While parsing a DTD, the parser encountered unexpected whitespace before an occurrence of the character '?', '*', or '+'. Whitespace is not allowed in this context. Parsing or validation did not complete. |
Remove the unexpected whitespace characters and try the operation again. sqlcode: -16127 sqlstate: 2200M |
|
SQL16128N |
XML document contains an invalid character with code point codepoint in attribute value attribute-name. |
While parsing an XML document the parser encountered an invalid character with code point codepoint in an attribute value identified by attribute-name. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16128 sqlstate: 2200M |
|
SQL16129N |
XML document expected end of tag tag-name. |
While parsing an XML document the parser expected to encounter the end of a tag with name tag-name and did not. Parsing or validation did not complete. |
Add or correct the missing end tag and try the operation again. sqlcode: -16129 sqlstate: 2200M |
|
SQL16130N |
XML document contains an invalid or not terminated processing instruction. Reason code = reason-code. |
While processing an XML document or XML schema the XML parser encountered an processing instruction that is not valid. One or more of the following reasons make the processing instruction not valid:
Parsing or validation did not complete. |
Correct the XML processing instruction and try the operation again. sqlcode: -16130 sqlstate: 2200M |
|
SQL16131N |
XML document contains a start tag tag-name that is not terminated. |
While parsing an XML document the parser encountered a start tag identified by tag-name that is not terminated. The content following the start tag may be missing the end tag or the content is not well-formed between the start tag and the end tag. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16131 sqlstate: 2200M |
|
SQL16132N |
XML document contains an invalid document structure. |
While parsing an XML document, the parser encountered an invalid document structure. The parser encountered non-whitespace character data in the prolog of an instance document or in the external subset of a DTD. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16132 sqlstate: 2200M |
|
SQL16133N |
XML document contains an invalid namespace declaration. |
While parsing an XML document, the parser encountered an invalid namespace declaration in a DOM instance. The namespace has the prefix "xmlns" and the URI http://www.w3.org/2000/xmlns/. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16133 sqlstate: 2200M |
|
SQL16134N |
XML document contains an invalid target namespace associated with name. |
While parsing an XML document the parser encountered an attribute declaration with ncname name with a target namespace that matched the XML schema namespace for instance documents ('http://www.w3.org/2001/XMLSchema-instance'). This URI cannot be used as a target namespace in an attribute declaration. Parsing or validation did not complete. |
Correct the element or attribute name and try the operation again. sqlcode: -16134 sqlstate: 2200M |
|
SQL16135N |
XML document contains an attribute list that references an element element-name that is not declared. |
While parsing an XML document the parser encountered and attribute list with a reference to an element named element-name that was not declared. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16135 sqlstate: 2200M |
|
SQL16136N |
XML schema contains a facet error. Reason code = reason-code. |
While parsing an XML document the parser encountered an error with a facet. Possible reasons given by reason-code are:
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16136 sqlstate: 2200M |
|
SQL16137N |
XML document contains an unknown simpleType type-name. |
While parsing an XML document the parser encountered a type name type-name that is an unknown simple type. Parsing or validation did not complete. |
Correct the type name and try the operation again. sqlcode: -16137 sqlstate: 2200M |
|
SQL16138N |
XML document contains an unknown complexType type-name. |
While parsing an XML document the parser encountered a type name type-name that is an unknown complex type. Parsing or validation did not complete. |
Correct the type name and try the operation again. sqlcode: -16138 sqlstate: 2200M |
|
SQL16139N |
XML schema contains an error in the content of simpleType type-name. |
While parsing an XML document the parser encountered an error in the content of simpleType with name type-name. The simpleType element definition is only allowed one of restriction, list or union. In some cases, the token may not be available. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16139 sqlstate: 2200M |
|
SQL16140N |
XML document contains a <group> or <attributeGroup> specification without a name or ref attribute. |
While parsing an XML document the parser encountered a <group> or <attributeGroup> specification that did not have a name or ref attribute. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16140 sqlstate: 2200M |
|
SQL16141N |
XML schema contains an invalid derivation by RESTRICTION or EXTENSION. Reason code = reason-code. |
While processing an XML schema the XML parser encountered a problem with a type derived by RESTRICTION or EXTENSION. The possible reasons are described by the reason-code values that follow.
Parsing or validation did not complete. |
Correct the XML schema and try the operation again. sqlcode: -16141 sqlstate: 2200M |
|
SQL16142N |
XML document contains an undefined entity entity-name. |
While parsing an XML document the parser encountered an entity identified by entity-name that is not defined. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16142 sqlstate: 2200M |
|
SQL16143N |
XML document contains an unexpected end of entity entity-name. |
While parsing an XML document, the parser encountered an end of entity named entity-name that was not expected. Parsing or validation did not complete. |
Correct the entity and try the operation again. sqlcode: -16143 sqlstate: 2200M |
|
SQL16144N |
XML document contains an open angle bracket character ('<') in the attribute attribute-name without specifying it as an entity. |
While parsing an XML document, the parser encountered an open angle bracket character ('<') in an attribute value for attribute named attribute-name. If the open angle bracket character is desired, it must be specified as the entity '<'. It cannot be specified as the character literal '<'. Parsing or validation did not complete. |
Correct the attribute value and try the operation again. sqlcode: -16144 sqlstate: 2200M |
|
SQL16145N |
XML document contains a hex radix character reference specified using "X" and not "x". |
While parsing an XML document, the parser encountered a hex radix character reference where the value was specified with upper case "X" instead of lower case "x". A hex radix character reference must use the lower case "x". Parsing or validation did not complete. |
Correct the hex radix character reference to use lower case "x" and try the operation again. sqlcode: -16145 sqlstate: 2200M |
|
SQL16146N |
The main XML document is empty. |
While parsing an XML document the parser encountered an empty main XML document. The main XML document cannot be empty. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16146 sqlstate: 2200M |
|
SQL16147N |
XML document contains an invalid use of the namespace for xmlns or the namespace prefix 'xmlns'. |
While parsing an XML document, the parser encountered either an attempt to explicitly bind a reserved prefix such as 'xml' or 'xmlns' to a namespace, or an attempt to explicitly bind a reserved namespace such as the namespace for xml or xmlns to a prefix. Reserved prefixes cannot be explicitly bound to any namespace but their own, nor can any reserved namespaces be bound to any prefix but their own. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16147 sqlstate: 2200M |
|
SQL16148N |
XML document contains an invalid element element-name1 with abstract set to true and substitutionGroup to element-name2. |
While parsing an XML document, the parser encountered element element-name1 with abstract set to true and defined as a member of a substitution group of element element-name. The abstract is required to be false for element-name1 as a member of the substitution group with head element element-name2. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16148 sqlstate: 2200M |
|
SQL16149N |
XML document contains a empty targetNamespace attribute value. |
While parsing an XML document, the parser encountered an empty targetNamespace attribute value. The attribute must be absent or contain a value that is not empty. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16149 sqlstate: 2200M |
|
SQL16150N |
XML document contains a keyref field keyref-name that refers to key field key-name with a different cardinality. |
While parsing an XML document, the parser encountered a mismatch in the cardinality of a keyref field keyref-name that refers to key field key-name. The cardinality in the kweyref must match the key. Parsing or validation did not complete. |
Correct the cardinality of the keyref field or the key field in the XML document and try the operation again. sqlcode: -16150 sqlstate: 2200M |
|
SQL16151N |
XML document contains a keyref field keyref-name that refers to key with name key-name that is not found. |
While parsing an XML document, the parser encountered a keyref field keyref-name that refers to a key field key-name that is not known in the document. Parsing or validation did not complete. |
Correct the name of the key field in the XML document and try the operation again. sqlcode: -16151 sqlstate: 2200M |
|
SQL16152N |
XML document contains multiple attributes derived from one type ID in the same complex type or attribute group. One of the attributes is attribute-name. |
While parsing an XML document, the parser encountered multiple attributes derived from one type ID in the same complex type or attribute group. One of the attributes with this property is identified by attribute-name. Parsing or validation did not complete. |
Correct the attributes of the complex type or attribute in the XML document and try the operation again. sqlcode: -16152 sqlstate: 2200M |
|
SQL16153N |
XML schema contains an attribute type definition with a default value or a fixed value that is different from the fixed value constraint of the reference type type-name. |
While parsing an XML document, the parser encountered a mismatch in the value constraint of the attribute and attribute reference type. Either the attribute specified a default and the reference type is fixed or the attribute specified a different fixed value than specified in reference type type-name. Parsing or validation did not complete. |
Correct the value constraint of the attribute reference in the XML document and try the operation again. sqlcode: -16153 sqlstate: 2200M |
|
SQL16154N |
XML schema contains an element element-name that has more than one attribute defined with the ID property. |
While parsing an XML schema (or DTD), two or more attributes with the ID property were declared for the element named element-name. Parsing or validation did not complete. |
Correct the XML schema or DTD and try the operation again. sqlcode: -16154 sqlstate: 2200M |
|
SQL16155N |
XML document contains an incorrectly specified or invalid URL. Reason code = reason-code. |
While parsing an XML document the parser encountered an incorrectly specified or invalid URL. The reason-code indicates which of the following conditions was found.
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16155 sqlstate: 2200M |
|
SQL16156N |
XML document has a primary document entity that could not be opened. System Id=system-id. |
While parsing an XML document, the parser encountered a primary document entity that could not be opened. The document is identified by the system identifier system-id. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16156 sqlstate: 2200M |
|
SQL16157N |
XML schema contains invalid relationships involving inclusion or exclusion facet value value of a derived type and the value space of the base type. Reason code = reason-code. |
While processing an XML schema the XML parser encountered an invalid relationship between inclusion facet values or exclusion facet values for a derived type and the value space of the base type. The reason-code indicates which of the following conditions was found.
One or more of the following conditions hold true:
Parsing or validation did not complete. |
Correct the facet value that is outside the value space of the base type and try the operation again. sqlcode: -16157 sqlstate: 2200M |
|
SQL16158N |
XML schema contains an invalid relationship involving minLength, maxLength, or length facet value dt-length in a derived type compared to the base type value base-length. Reason code = reason-code. |
While parsing an XML document, the parser encountered an invalid relationship between facets of a derived type and the base type. The reason-code indicates which of the following conditions was found.
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16158 sqlstate: 2200M |
|
SQL16159N |
XML document contains an anonymous complex type with a name attribute in element element-name. |
While parsing an XML document, the parser encountered an anonymous complex type in an element named element-name, yet the complexType had a name attribute. The combination of complexType and name attribute is not permitted in this context. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16159 sqlstate: 2200M |
|
SQL16160N |
XML document contains an anonymous simple type in element element-name with a name attribute. |
While parsing an XML document, the parser encountered an anonymous simple type in an element named element-name, yet that element had a name attribute. The combination of anonymous type and name attribute is not permitted. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16160 sqlstate: 2200M |
|
SQL16161N |
XML document contains an element with an information item that is not expected. |
While parsing an XML document, the parser encountered an information item that does not match (annonation?, (simpletype | complextype)?, (unique | key | keyref)*). Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16161 sqlstate: 2200M |
|
SQL16162N |
XML document contains an element element-name that cannot be part of the substitution group headed by substitution-name. |
While parsing an XML document, the parser encountered an element element-name that cannot be part of the specified substitution group substitution-name. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16162 sqlstate: 2200M |
|
SQL16163N |
XML document contains a duplicate element declaration for element-name. |
While parsing an XML document, the parser encountered duplicate element declaration in the same scope for the specified element. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16163 sqlstate: 2200M |
|
SQL16164N |
XML document contains duplication <annotation> elements in the content. |
While parsing an XML document, the parser encountered duplicate <annotation> elements in the contents. At most one <annotation> element is expected. Parsing or validation did not complete. |
Correct the XML document to remove the duplicate <annotation> and try the operation again. sqlcode: -16164 sqlstate: 2200M |
|
SQL16165N |
XML document contains unexpected text before the root element. |
While parsing an XML document, the parser encountered unexpected text before the root element. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16165 sqlstate: 2200M |
|
SQL16166N |
XML document contained partial markup in an entity value. |
While parsing an XML document the parser encountered partial markup in an entity value. The parser was expanding an entity in the XML document and the resulting XML mark up is not well-formed XML. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16166 sqlstate: 2200M |
|
SQL16167N |
XML document contained NDATA for a parameter entity. |
While parsing an XML document, the parser encountered NDATA for a parameter entity. NDATA is not legal for parameter entities. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16167 sqlstate: 2200M |
|
SQL16168N |
XML document contained an invalid XML declaration. Reason code = reason-code. |
While processing an XML document or XML schema the XML parser encountered a missing or invalid XML declaration. The reason-code indicates which of the following conditions was found.
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16168 sqlstate: 2200M |
|
SQL16169N |
XML document contained an element or attribute name that is invalid with respect to namespaces. Reason code = reason-code. |
While parsing an XML document, the parser encountered an invalid XML element or attribute name caused by namespaces. The reason-code indicates which of the following conditions was found.
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16169 sqlstate: 2200M |
|
SQL16170N |
XML document contains a type type-name1 with an unknown base type type-name2. |
While parsing an XML document, the parser encountered a type type-name1 with an unknown base type type-name2. Parsing or validation did not complete. |
Correct the base type for type-name1 in the XML document and try the operation again. sqlcode: -16170 sqlstate: 2200M |
|
SQL16171N |
XML document contained an error in the content of derivation by list for simple type type-name. |
While parsing an XML document, the parser encountered an illegal specification of the 'list' derivation in the declaration of simpleType type-name. Parsing or validation did not complete. |
Correct the the type declaration in the XML document and try the operation again. sqlcode: -16171 sqlstate: 2200M |
|
SQL16172N |
XML document contains a declaration-type declaration that has both a ref attribute and child contents. |
While parsing an XML document, the parser encountered an declaration-type declaration that included a ref attribute and child contents. A ref attribute and child contents cannot both be included in a declaration-type declaration. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16172 sqlstate: 2200M |
|
SQL16173N |
XML document contains an attribute attribute-name that is not allowed. |
While parsing an XML document, an attribute attribute-name was encountered that is not allowed in the element. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16173 sqlstate: 2200M |
|
SQL16174N |
XML document contains an XML schema uri1 whose target namespace does not match the one specified in the instance document uri2. |
While parsing an XML document, the parser encountered a target namespace mismatch. The target namespace in the XML schema does not match the target namespace in the instance document. Parsing or validation did not complete. |
Correct the target namespace in the XML document and try the operation again. sqlcode: -16174 sqlstate: 2200M |
|
SQL16175N |
XML document contains a schema where the root element element-name could not be resolved. |
While parsing an XML document, the parser encountered a problem resolving the root element of a schema document. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16175 sqlstate: 2200M |
|
SQL16176N |
XML Schema contains an illegal use of List, Union, or Restriction content for type type-name. |
While parsing an XML document, the specified type type-name is not permitted to be declared with List, Union, or Restriction. A list or union cannot be used with a type that is not a simple type. A simple type that derives from another type requires that the other type must also be a simple type. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16176 sqlstate: 2200M |
|
SQL16177N |
XML schema contains a derived type whose base type type-name could not be found. |
While parsing an XML document, a derived type was encountered and the base type type-name for that derived type could not be found. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16177 sqlstate: 2200M |
|
SQL16178N |
XML document contains a derived attribute attribute-name that is inconsistent with the definition for the base attribute. Reason code = reason-code. |
While parsing an XML document, a derived attribute was discovered that is inconsistent in some way with the base type for that attribute. Possible reasons given by reason-code are:
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16178 sqlstate: 2200M |
|
SQL16179N |
XML document contains an element or attribute name with a derivation-type declaration that expected a simpleType. |
While parsing an XML document, a derivation-type declaration was expecting a simpleType for the specified element or attribute name. A type other than a SimpleType was found. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16179 sqlstate: 2200M |
|
SQL16180N |
XML document contains empty simpleType content. |
While parsing an XML document, the parser encountered a simpleType that has no children. There must be one child defined for the simpleType. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16180 sqlstate: 2200M |
|
SQL16181N |
XML document contains invalid simpleContent. |
While parsing an XML document, some invalid simpleContent was encountered. The content must be RESTRICTION or EXTENSION. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16181 sqlstate: 2200M |
|
SQL16182N |
XML document contains invalid complexContent. |
While parsing an XML document, some invalid complexContent was encountered. The content must be RESTRICTION or EXTENSION. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16182 sqlstate: 2200M |
|
SQL16183N |
XML document contains an invalid child in a complexType. Reason code = reason-code. |
While parsing an XML document an invalid child was found in a complexType. Possible reasons given by reason-code are:
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16183 sqlstate: 2200M |
|
SQL16184N |
XML document contains duplicate annotation for type type-name. |
While parsing an XML document, duplicate annotation for the type type-name was encountered. A type can be annotated at most once. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16184 sqlstate: 2200M |
|
SQL16185N |
XML document contains a syntax error. Reason code = reason-code. |
While parsing an XML document the parser encountered a syntax error. Possible reasons given by reason-code are:
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16185 sqlstate: 2200M |
|
SQL16186N |
XML document encountered invalid unparsed entity reference entity-name. |
While parsing an XML document, an unparsed entity reference entity-name was encountered. That is invalid. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16186 sqlstate: 2200M |
|
SQL16187N |
XML document contains an abstract type type-name used in an xsi:type attribute. |
While parsing an XML document, the parser encountered use of an abstract type type-name in an xsi:type attribute. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16187 sqlstate: 2200M |
|
SQL16188N |
XML document contains an invalid content annotation specification for type type-name. |
While parsing an XML document, the parser encountered Content (Annotation?...) which is incorrect for the data type type-name. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16188 sqlstate: 2200M |
|
SQL16189N |
XML document contains a ref element element-name not found in the XML schema. |
While parsing an XML document, the parser encountered a ref element element-name that is not found in the XML schema. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16189 sqlstate: 2200M |
|
SQL16190N |
XML document contains a type "prefix:type-name" that is not found in the namespace. |
While parsing an XML document, the parser encountered a type that is not found in the namespace. The type is identified by prefix:type-name. Parsing or validation did not complete. |
Correct the use of the type in the XML document and try the operation again. sqlcode: -16190 sqlstate: 2200M |
|
SQL16191N |
XML document contained an invalid child in the complex type type-name. |
While parsing an XML document, the parser encountered an invalid child in the complex type type-name. A child of a completType can be a group, sequence, choice, all, attribute, or attributeGroup. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16191 sqlstate: 2200M |
|
SQL16192N |
XML document contains a circular attributeGroup reference for attribute-name. |
While parsing an XML document the parser encountered a circular attributeGroup reference. This use is disallowed outside a <redefine>. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16192 sqlstate: 2200M |
|
SQL16193N |
XML document contains a prefix prefix-name that has not been mapped to any URI. |
While parsing an XML document, the parser encountered a prefix prefix-name that has not been mapped to any URI. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16193 sqlstate: 2200M |
|
SQL16194N |
XML document contains a type type-name that is used in an xsi:type attribute but is not derived from the type of the element element-name. |
While parsing an XML document, the parser encountered an xsi:type attribute that specified type-name but this type is not derived from the type of the element element-name. Parsing or validation did not complete. |
Correct the type used in the xsi:type attribute in the XML document and try the operation again. sqlcode: -16194 sqlstate: 2200M |
|
SQL16195N |
XML document contains an invalid redefine. namespace-uri has already been included or redefined. |
While parsing an XML document, the parser encountered an invalid redefine. The namespace namespace-uri has already been included or redefined. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16195 sqlstate: 2200M |
|
SQL16196N |
XML document contains an element element-name that is not correctly specified. Reason code = reason-code |
While parsing an XML document the parser encountered an error with an element named element-name. Possible reasons given by reason-code are:
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16196 sqlstate: 2200M |
|
SQL16197N |
XML document contains key or keyref name name identity constraint that does not have enough values specified for element element-name. |
While parsing an XML document the parser encountered an element element name where the key or keyref name identity constraint does not have enough values specified. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16197 sqlstate: 2200M |
|
SQL16198N |
XML document contains the declaration of an object-type object with an invalid name name. |
While parsing an XML document the parser encountered a declaration for an object-type object with a name name that is not valid. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16198 sqlstate: 2200M |
|
SQL16199N |
XML document contains a type type-name which has complexContent and cannot be specified as the base in a simpleContent element. |
While parsing an XML document, the parser encountered a type type-name which has complexContent specified as the base in a simpleContennt element. Parsing or validation did not complete. |
Correct the XML document to specify a different type as the base and try the operation again. sqlcode: -16199 sqlstate: 2200M |
|
SQL16200N |
XML document contains a duplicate reference attribute "prefix:name" in a complexType. |
While parsing an XML document the parser encountered a duplicate reference attribute named prefix:name in a complexType. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16200 sqlstate: 2200M |
|
SQL16201N |
XML document contains invalid Unicode character hex-value in a public identifier. |
While parsing an XML document the parser encountered an invalid Unicode character in a public id. The invalid character is identified by the hexadecimal value hex-value. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16201 sqlstate: 2200M |
|
SQL16202N |
XML document contains invalid digit value for the associated radix. |
While parsing an XML document the parser encountered an invalid digit value for the associated radix. The radix could be base 10 or base 16. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16202 sqlstate: 2200M |
|
SQL16203N |
XML document input ended before all started tags were ended. Last tag started was tag-name. |
While parsing an XML document the parser encountered an end of input before all start tags were closed. The last tag that was started is indicated by tag-name. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16203 sqlstate: 2200M |
|
SQL16204N |
XML document contains reference to an external entity declaration ext-entity-name in a standalone document. |
While parsing an XML document the parser referenced an external entity identified by ext-entity-name in a standalone document. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16204 sqlstate: 2200M |
|
SQL16205N |
XML document contains too few elements to match content model name. |
While parsing an XML document, the parser did not find enough elements to match the content model identified by name. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16205 sqlstate: 2200M |
|
SQL16206N |
XML document contains reference to a URI uri-string for which no grammar is available. |
While parsing an XML document the parser attempted to locate a grammar for the URI uri-string. The grammar is not available. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16206 sqlstate: 2200M |
|
SQL16207N |
XML document contains an entity entity-name that was not defined. |
While parsing an XML document, the parser found an entity identified by entity-name that was not defined. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16207 sqlstate: 2200M |
|
SQL16208N |
XML document contains an invalid type type-name in xsi:type. |
While parsing an XML document, the parser found an invalid type type-name in an xsi:type definition. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16208 sqlstate: 2200M |
|
SQL16209N |
XML document requires specification of a member of the substitution group for abstract element element-name. |
While parsing an XML document the parser encountered a missing member of a substitution group for the abstract element element-name. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16209 sqlstate: 2200M |
|
SQL16210N |
XML document contained a value value that violates a facet constraint. Reason code = reason-code. |
While processing an XML document, the XML parser encountered a value that failed a facet constraint test. Possible reasons given by reason-code are:
Parsing or validation did not complete. |
Correct the value that violates the constraint facet in the XML document and try the operation again. sqlcode: -16210 sqlstate: 2200M |
|
SQL16211N |
XML document contained an invalid URI. Token 1=token1. Token 2=token2. Reason code = reason-code. |
While parsing an XML document the parser encountered an invalid URI. Possible reasons given by reason-code are:
Parsing or validation did not complete. |
Correct the URI in the XML document and try the operation again. sqlcode: -16211 sqlstate: 2200M |
|
SQL16212N |
XML document does not allow circular definitions for name. |
While parsing an XML document, the parser encountered the a use of name within the definition of name. XML does not allow circular definitions. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16212 sqlstate: 2200M |
|
SQL16213N |
XML schema contains an element element-name that must not have a constraint-type constraint because the type is derived from ID. |
While parsing an XML schema, the parser encountered an element that must not have a constaint-type constraint because it is derived from ID. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16213 sqlstate: 2200M |
|
SQL16214N |
XML document contains an imported schema import-uri that has a different targetNameSpace targetns-uri than what is declared declared-uri. |
While parsing an XML document the parser encountered a namespace mismatch. The XML schema that was imported import-uri has a target namespace targetns-uri that is different from the declared namespace declared-uri in the XML document. Parsing or validation did not complete. |
Correct the mismatch in namespaces for the XML document and try the operation again. sqlcode: -16214 sqlstate: 2200M |
|
SQL16215N |
XML document contains an included schema include-uri that has a different target namespace targetns-uri. |
While parsing an XML document, the parser encountered a namespace mismatch. The XML schema that was included with URI include-uri has a different target namespace URI targetns-uri. Parsing or validation did not complete. |
Correct the mismatch in namespaces for the XML document and try the operation again. sqlcode: -16215 sqlstate: 2200M |
|
SQL16216N |
XML document is missing attribute attribute-name that must appear in element-type element-name declarations. |
While parsing an XML document the parser encountered an element-type element-name declaration that is missing a required attribute attribute-name. Parsing or validation did not complete. |
Add the missing attribute to the global or local declaration in the XML document and try the operation again. sqlcode: -16216 sqlstate: 2200M |
|
SQL16217N |
XML document contains attribute attribute-name that cannot appear in element-type element-name declarations. |
While parsing an XML document the parser encountered an attribute named attribute-name that is not allowed in a element-type element-name declaration. Parsing or validation did not complete. |
Remove the attribute from the global or local declaration in the XML document and try the operation again. sqlcode: -16217 sqlstate: 2200M |
|
SQL16218N |
XML document contains a global declaration for component named name1 that is declared more than once. |
While parsing an XML document the parser encountered a duplicate global declaration for a component identified by name. The component could be an "element", "group", or "attributeGroup". Parsing or validation did not complete. |
Remove the duplicate declaration from the XML document and try the operation again. sqlcode: -16218 sqlstate: 2200M |
|
SQL16219N |
XML document contains a global type declaration for a type1 named name that is declared more than once or also declared as type2 |
While parsing an XML document the parser encountered a duplicate global type declaration for a type1 identified by name or name is also declared as a type2. The global type declarations could be a simpleType or a complexType. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16219 sqlstate: 2200M |
|
SQL16220N |
XML document contains an element or attribute name where NOTATION was used directly in the schema for that element or attribute. |
While parsing an XML document, the parser encountered an element or attribute where the schema used NOTATION directly for that element or attribute.. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16220 sqlstate: 2200M |
|
SQL16221N |
XML document contains a mismatch in the definition of the base type base-type-name and the derived type derived-type-name. |
While parsing an XML document, the parser encountered a mismatch in the definition of a base type base-type-nameand the derived type derived-type-name. If the content type of the base type is mixed then the derived type must also be mixed content. If the content of the base type is element-only, then the derived type must also be element-only content. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16221 sqlstate: 2200M |
|
SQL16222N |
XML document contains a global declaration-type declaration without a name |
While parsing an XML document, the parser encountered a global declaration-type declaration without a name. The global declaration must have a name. Parsing or validation did not complete. |
Correct the global declaration in the XML document and try the operation again. sqlcode: -16222 sqlstate: 2200M |
|
SQL16223N |
XML document contained a <redefine> element with a child of type type-name that is not allowed. |
While parsing an XML document, the parser encountered a redefine element with a child defined with data type type-name. A <redefine> element cannot contain a child of that type. Parsing or validation did not complete. |
Correct the <redefine> element in the XML document and try the operation again. sqlcode: -16223 sqlstate: 2200M |
|
SQL16224N |
XML document contains a mismatch in the definition of the base element base-element-name and the derived element derived-element-name. Reason code = reason-code. |
While parsing an XML document, the parser encountered a mismatch in the definition of a base element with name base-element-name and an associated derived element with name derived-element-name. Possible reasons given by reason-code are:
Parsing or validation did not complete. |
Correct the base element or the derived element in the XML document and try the operation again. sqlcode: -16224 sqlstate: 2200M |
|
SQL16225N |
XML document contains a namespace of namespace-uri that is not allowed by a wildcard in the base type. |
While parsing an XML document, the parser encountered an invalid namespace caused by a type which is derived from a base type with an "any" element that has an element definition with a namespace URI that does not match namespace-uri. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16225 sqlstate: 2200M |
|
SQL16226N |
XML schema contains an invalid group specification for group group-name. Reason code = reason-code. |
While processing an XML schema the XML parser encountered an invalid group specification. Possible reasons given by reason-code are:
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16226 sqlstate: 2200M |
|
SQL16227N |
XML document contains object "object-type" named "uri:object-name" that was not found in the schema. |
While parsing an XML document, the parser encountered an object of type object-type with name uri:object-name that could not be found in the XML schema. |
Correct the XML document or the XML schema and try the operation again. Parsing or validation did not complete. sqlcode: -16227 sqlstate: 2200M |
|
SQL16228N |
The content of <all> is restricted to <xs:element> but tag-name was encountered. |
While parsing an XML schema document, the parser encountered the element tag-name. XML Schema restricts the content of <all> to <xs:element>. |
Correct the XML schema document and try the operation again. sqlcode: -16228 sqlstate: 2200M |
|
SQL16229N |
XML document contains a redefine schema schema-uri with a different target namespace targetns-uri. |
While parsing an XML document, the parser encountered a redefine schema with a different target namespace. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16229 sqlstate: 2200M |
|
SQL16230N |
XML document contains more than one identity constraint named constraint-name. |
While parsing an XML document, the parser encountered multiple identity constraints that used the name constraint-name. Parsing or validation did not complete. |
Change the duplicate identity constraint names in the XML document and try the operation again. sqlcode: -16230 sqlstate: 2200M |
|
SQL16231N |
XML document contains a reference to namespace uri without an <import> declaration. |
While parsing an XML document, the parser encountered a reference to namespace uri without an import declaration for that namespace. Parsing or validation did not complete. |
Include and import for the namespace in the XML document and try the operation again. sqlcode: -16231 sqlstate: 2200M |
|
SQL16232N |
XML document contains a duplicate setting of attribute-name in the XML declaration. |
While parsing an XML document, the parser encountered duplicate declaration settings of attribute-name in the XML declaration. The XML declaration can only have one setting ot "version", "encoding" and "standalone" attributes. Parsing or validation did not complete. |
Remove the duplicate attribute setting in the XML declaration for the XML document and try the operation again. sqlcode: -16232 sqlstate: 2200M |
|
SQL16233N |
XML document contains a duplicate ID value ID-value. |
While parsing an XML document the parser encountered duplicate ID value ID-value. Parsing or validation did not complete. |
Change the duplicate ID values to unique ID values in the XML document and try the operation again. sqlcode: -16233 sqlstate: 2200M |
|
SQL16234N |
XML document contains an invalid declaration for data type type-name. Reason code = reason-code. |
While parsing an XML document, the parser encountered an invalid data type declaration. Possible reasons given by reason-code are:
Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16234 sqlstate: 2200M |
|
SQL16235N |
XML document contained a value value that is out of range. Range value 1=rvalue1. Range value 2=rvalue2. Reason code = reason-code. |
While parsing an XML document the parser encountered an invalid value. Possible reasons given by reason-code are:
Parsing or validation did not complete. |
Correct the out of range value in the XML document and try the operation again. sqlcode: -16235 sqlstate: 2200M |
|
SQL16236N |
Error encountered processing regular expression. Reason code = reason-code. Possible token = token. |
While processing a regular expression an error was encountered. The reason-code provides further information regarding the error along with a description of the possible token token if it is not empty.
Parsing or validation did not complete. |
Correct the regular expression and try the operation again. sqlcode: -16236 sqlstate: 2200M |
|
SQL16237N |
XML schema contains an occurrence range for element element-name that is not a valid restriction of range for the base element. |
While parsing an XML schema, the parser encountered an occurrence range in the element element-name that is not a valid restriction of the occurrence range for the base element. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16237 sqlstate: 2200M |
|
SQL16238N |
XML schema contains a prefix prefix-name that is not bound to a namespace URI in an XPath value. |
While processing an XML schema, the XML parser encountered a prefix prefix-name without a corresponding URI in an XPath value. Parsing or validation did not complete. |
Correct the XML schema and try the operation again. sqlcode: -16238 sqlstate: 2200M |
|
SQL16239N |
XML document contains a redefine for a type type-name that does not already have an existing declaration. |
While parsing an XML document, the parser did not encounter a declaration corresponding to type-name in the schema. The redefine request cannot be performed without a prior declaration. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16239 sqlstate: 2200M |
|
SQL16240N |
XML document contained tag which is only allowed in elementOnly content. |
While parsing an XML document, the parser encountered contents that are only valid in elementOnly content. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16240 sqlstate: 2200M |
|
SQL16241N |
XML document has tag content in a choice model group which is limited to 'element', 'group', 'choice', 'sequence', and 'any'. |
While parsing an XML document the parser encountered invalid content. A choice model group include the content tag that is not one of 'element', 'group', 'choice', 'sequence', or 'any'. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16241 sqlstate: 2200M |
|
SQL16242N |
XML document has name1 and name2 which violate the unique particle attribution rule. |
While parsing an XML document the parser encountered values that violate the unique particle attribution rule. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16242 sqlstate: 2200M |
|
SQL16243N |
XML document contains keyref value referencing a key or unique constraint that is out of scope. |
While parsing an XML document, the parser encountered an invalid keyref. The keyref value is the name of a key ior unique constraint that is defined but is not in the scope of the keyref. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16243 sqlstate: 2200M |
|
SQL16244N |
XML document contains an operation operation-name that is invalid for the spec type. |
While parsing an XML document, the parser encountered an operation that is invalid for the spec type. Parsing or validation did not complete. |
Correct the XML document and try the operation again. sqlcode: -16244 sqlstate: 2200M |
|
SQL16245N |
Unqualified SQL identifier string found at or near line lineno in XML schema document uri. |
The identifier string is missing a relational schema name and there is no global annotation db2-xdb:defaultSQLSchema specified in the XML schema. The XML schema document can be determined by matching uri to the SCHEMALOCATION column of catalog view SYSCAT.XSROBJECTCOMPONENTS. The XML schema is not enabled for decomposition. |
Either the global annotation db2-xdb:defaultSQLSchema must be defined or any table or nickname used in any mapping must be declared with a db2-xdb:table annotation that specifies a relational schema. sqlcode: -16245 sqlstate: 225DE |
|
SQL16246N |
Incomplete annotation mapping at or near line lineno in XML schema document uri. Reason code = reason-code. |
The annotation mapping the XML schema item near line in uri, to a database object is missing some information. Possible values for reason code include:
The XML schema document can be determined by matching uri to the SCHEMALOCATION column of catalog view SYSCAT.XSROBJECTCOMPONENTS. The XML schema is not enabled for decomposition. |
Modify the annotations in the XML schema. Possible actions based on the reason-code include:
Consult annotated XML schema documentation on the specified annotation to make sure that all required components have supplied values. sqlcode: -16246 sqlstate: 225DE |
|
SQL16247N |
Source XML type source-data-type cannot be mapped to target SQL type target-data-type in the annotation at or near line lineno in XML schema document uri. |
Annotation at or around line lineno in XML schema document uri maps a XML schema type source-data-type to an incompatible SQL type target-data-type. The XML schema document can be determined by matching uri to the SCHEMALOCATION column of catalog view SYSCAT.XSROBJECTCOMPONENTS. The XML schema is not enabled for decomposition. |
Consult annotated XML schema documentation on compatibility between XML schema types and SQL types. Correct the annotation appropriately. sqlcode: -16247 sqlstate: 225DE |
|
SQL16248N |
Error in annotation at or near line lineno in XML schema document uri. Additional information for the error includes errordetails. |
The annotated XML schema document uri contains an error in the annotation at or near line number lineno. Types of errors include: invalid value, unknown elements or attributes inside an annotation, mal-formed XML. Any available additional information on the type of error or the erroneous value is provided in errordetails. The XML schema document can be determined by matching uri to the SCHEMALOCATION column of catalog view SYSCAT.XSROBJECTCOMPONENTS. The XML schema is not enabled for decomposition. |
Consult annotated XML schema documentation for list of legal annotations and their syntax. Correct or remove the unknown annotation. sqlcode: -16248 sqlstate: 225DE |
|
SQL16249N |
The db2-xdb:expression or db2-xdb:condition annotation annotation-string at or near line lineno in XML schema document uri is invalid according to reason code reasoncode. |
The identified db2-xdb:expression or db2-xdb:condition annotation is not valid, as indicated by one of the following reason codes:
The XML schema document can be determined by matching uri to the SCHEMALOCATION column of catalog view SYSCAT.XSROBJECTCOMPONENTS. The XML schema is not enabled for decomposition. |
Consult annotated XML schema documentation regarding the syntax and limits for db2-xdb:expression or db2-xdb:condition annotations. Correct the expression appropriately. sqlcode: -16249 sqlstate: 225DE |
|
SQL16250N |
The db2-xdb:defaultSQLSchema with value schema-name at or near line lineno in XML schema document uri conflicts with another db2-xdb:defaultSQLSchema specified in one of the XML schema documents within the same XML schema. |
There can only be one value for the db2-xdb:defaultSQLSchema annotation across all XML schema documents that comprise an annotated XML schema. The specified SQL schema name schema-name at or near the line number lineno in the XML schema document uri conflicts with another value for db2-xdb:defaultSQLSchema annotation in this or another XML schema document of the XML schema. The XML schema document can be determined by matching uri to the SCHEMALOCATION column of catalog view SYSCAT.XSROBJECTCOMPONENTS. The XML schema is not enabled for decomposition. |
Correct the annotated XML schema such that all specifications of db2-xdb:defaultSQLSchema are consistent. sqlcode: -16250 sqlstate: 225DE |
|
SQL16251N |
Duplicate db2-xdb:table annotation defined for table or nickname table-name at or near line lineno in XML schema document uri. |
There is more than one db2-xdb:table annotation for the table or nickname table-name in the annotated XML schema. A second db2-xdb:table annotation has been found for this table or nickname at or around line lineno in XML schema document uri. The XML schema document can be determined by matching uri to the SCHEMALOCATION column of catalog view SYSCAT.XSROBJECTCOMPONENTS. The XML schema is not enabled for decomposition. |
Correct the annotated XML schema by removing any duplicate db2-xdb:table annotations for the table or nickname table-name from the XML schema documents of the XML schema. sqlcode: -16251 sqlstate: 225DE |
|
SQL16252N |
The db2-xdb:rowSet name rowset-name specifed at or near line lineno in the XML schema document uri is already associated with another table or nickname. |
A rowset in an annotated XML schema must correspond to exactly one table or nickname. The rowset declaration at or near line lineno declares an association between rowset rowsetname and the table or nickname specified in the enclosing db2-xdb:table annotation. The specified rowset has already been associated to a different table or nickname in another db2-xdb:table annotation. The XML schema document can be determined by matching uri to the SCHEMALOCATION column of catalog view SYSCAT.XSROBJECTCOMPONENTS. The XML schema is not enabled for decomposition. |
Correct the annotated XML schema such that each rowset name is uniquely associated with exactly one table or nickname across the annotated XML schema documents of the XML schema. sqlcode: -16252 sqlstate: 225DE |
|
SQL16253N |
The db2-xdb:condition annotation condition at or near line lineno in XML schema document uri is too long. |
The length of the string associated with db2-xdb:condition that starts with condition exceeds the maximum allowed. The db2-xdb:condition is found at or around line number lineno in XML schema document uri. The XML schema document can be determined by matching uri to the SCHEMALOCATION column of catalog view SYSCAT.XSROBJECTCOMPONENTS. The XML schema is not enabled for decomposition. |
Reduce the size of the condition string for db2-xdb:condition in the XML schema document. Consult annotated XML schema documentation on the limit for strings specified in db2-xdb:condition annotations. sqlcode: -16253 sqlstate: 225DE |
|
SQL16254N |
A db2-xdb:locationPath locationpath at or near line lineno in XML schema document uri is not valid with reason code reason-code. |
A value specified in the annotated schema for db2-xdb:locationPath
is not valid.
Possible values for reason code include:
The XML schema document can be determined by matching uri to the SCHEMALOCATION column of catalog view SYSCAT.XSROBJECTCOMPONENTS. The XML schema is not enabled for decomposition. |
Modify the annotations in the XML schema.
Possible actions based on the reason-code include:
sqlcode: -16254 sqlstate: 225DE |
|
SQL16255N |
A db2-xdb:rowSet value rowset-name used at or near line lineno in XML schema document uri conflicts with a db2-xdb:table annotation with the same name. |
The annotated XML schema contains a db2-xdb:table annotation which declares a table or a nickname named rowset-name, but the annotated XML schema does not have any db2-xdb:rowSet annotation declaration to associate rowset-name to any table or nickname. If a rowset is not declared in any db2-xdb:table annotation, it is implicitly associated to a table or nickname with the same name qualified by the value of db2-xdb:defaultSQLSchema. The annotated XML schema cannot use a db2-xdb:rowSet annotation that relies on an implicit association between a rowset and a table or a nickname with the same name of rowset-name, and at the same time declare a table or nickname named rowset-name using a db2-xdb:table annotation. The XML schema document can be determined by matching uri to the SCHEMALOCATION column of catalog view SYSCAT.XSROBJECTCOMPONENTS. The XML schema is not enabled for decomposition. |
Correct the annotated XML schema by adding a db2-xdb:rowSet child element to the db2-xdb:table element with name rowset-name. This will explicitly associate the rowset to the table or nickname. sqlcode: -16255 sqlstate: 225DE |
|
SQL16256N |
XML schema is missing a global complexType required to enable for decomposition. |
The XML schema has no global elements of complexType which would serve as a potential root element for instance documents. The XML schema must contain at least one global element of complexType in order to be enabled for decomposition. The XML schema is not enabled for decomposition. |
Ensure that the XML schema contains at least one global element of complexType before attempting to enable the XML schema for decomposition. sqlcode: -16256 sqlstate: 225DE |
|
SQL16257N |
Feature feature-number at or near line lineno in XML schema document uri, is not supported for decomposition. Any additional information on the error includes error-details. |
An unsupported feature was detected, as indicated by one of the
following feature numbers:
In some cases, the presence of the unsupported feature in the XML schema results in failure to enable for decomposition. In other cases, having annotations in the decomposition namespace on the unsupported feature results in failure to enable for decomposition. Any additional available information pertaining to the error is given in error-details. |
Remove the feature from the XML schema or remove the decomposition annotations associated with the feature, as appropriate. Consult decomposition documentation on the restrictions on use of the specified XML schema feature. sqlcode: -16257 sqlstate: 225DE |
|
SQL16258N |
The XML schema contains a recursive element which is an unsupported feature for decomposition. The recursive element is identified as "elementnamespace:elementname" of type "typenamespace:typename". |
XML schemas with recursive elements are not supported for decomposition. At least one recusive element was found identified as elementnamespace:elementname of type typenamespace:typename. The XML schema is not enabled for decomposition. |
Remove the use of recursion from the XML schema. sqlcode: -16258 sqlstate: 225DE |
|
SQL16259N |
Invalid many-to-many mappings detected in XML schema document uri1 near line lineno1 and in XML schema document uri2 near line lineno2. |
The two identified annotations specify an invalid many-to-many relationship between elements that map to the same rowset. If two element declarations have a sequence model group as their lowest common ancestor then only one of the paths from the element declaration up to that model group can have maxOccurs>1 on one or more elements declarations or modelgroups in that path. The XML schema documents can be determined by matching uri1 and uri2 to the SCHEMALOCATION column of catalog view SYSCAT.XSROBJECTCOMPONENTS. The XML schema is not enabled for decomposition. |
Correct the annotations such that there are no many-to-many mappings. Consult annotated XML schema documentation for rules on mapping elements and attributes. sqlcode: -16259 sqlstate: 225DE |
|
SQL16260N |
XML schema annotations include no mappings to any column of any table or nickname. |
The XML schema contains no annotations that map an XML element or attribute to any column of any table or nickname. The XML schema is not enabled for decomposition since it provides no information for performing decomposition. |
Add annotations to the XML schema so that at least one XML element or attribute is mapped to a column of a table or nickname. sqlcode: -16260 sqlstate: 225DE |
|
SQL16261N |
The number of namespace constraints specified for the wildcard exceeds the limit of max-namespaces. |
The number of namespaces explicitly listed in the namespace attribute of <xsd:any> or <xsd:anyAttribute> is more than the limit of max-namespaces namespaces. If the list contains the special values ##targetNamespace or ##local, these also count toward the limit. The XML schema is not enabled for decomposition. |
Reduce the number of namespace constraints specified in the wildcard definition to not more than max-namespaces namespaces. sqlcode: -16261 sqlstate: 225DE |
|
SQL16262N |
The annotated XML schema has no columns mapped for rowset rowsetname. |
The set of annotations involving rowset rowsetname contain no mappings to any column. In order for a rowset to be target for decomposition, at least one column must be mapped to some XML element or attribute. |
Add an annotation that maps a column of the specified rowset to some XML element or attribute. If the rowset is not intended to be a target for decomposition, remove references to the rowset from the annotated XML schema. sqlcode: -16262 sqlstate: 225DE |
|
SQL16263N |
The rowSet name string at or near line lineno in the XML schema document uri is not used in any mapping. |
The rowSet name string at line lineno in the XML schema document uri must be specified in at least one mapping in the XML shema. |
Ensure that the rowSet name string is specified in mapping at least one element or attribute in the XML schema. sqlcode: -16263 sqlstate: 225DE |
|
SQL16264N |
The rowSet name string at or near line lineno in the XML schema document uri cannot be used more than once under annotation-name. |
A rowSet name can be used only once under annotation-name. It can participate in only one hierarchy of operation orders. |
Verify that using the same rowSet name under multiple instances of the element db2-xdb:order under annotation-name is part of your design. If by design, combine the affected db2-xdb:order elements such that the resulting order is consistent with the required order of insertion. sqlcode: -16264 sqlstate: 225DE |
|
SQL16265N |
The XML document cannot be decomposed using XML schema xsrobject-name which is not enabled or is inoperative for decomposition. |
The XML schema identified by xsrobject-name is not in the
correct state to perform decomposition.
The XML schema could be in one of the following states:
XML decomposition was not started. |
Ensure that the XML schema is enabled for decomposition before attempting to use it for decomposition of an XML document. The decomposition status of an XML schema can be checked by selecting the DECOMPOSITION column of SYSCAT.XSROBJECTS for the XML schema identified by xsrobject-name. sqlcode: -16265 sqlstate: 225D1 |
|
SQL16266N |
An SQL error occurred during decomposition of document docid while attempting to insert data. Information returned for the error includes SQLCODE sqlcode, SQLSTATE sqlstate, and message tokens token-list. |
An SQL error occurred during decomposition of an XML document with document identifier docid. The error occurred while attempting an SQL insert operation based on some piece of data from the XML document. Some possible causes: format of data is incompatible with the target column's data type; length of data exceeds column size; providing null value for a column defined as non-null. The sqlcode, sqlstate and message token list (each token is separated by the vertical bar character) are provided. The message tokens may be truncated. See the corresponding message for the sqlcode for further explanation of the error. The XML document docid was not decomposed. |
Check the message associated with the SQLCODE. Follow the action suggested by that message. See the db2diag log file for complete information about the error condition. sqlcode: -16266 sqlstate: 225D2 |
|
SQL16267N |
An XML value string at or near line lineno in document docid is not valid according to its declared XML schema type type-name or is outside the supported range of values for the XML schema type. |
The specified XML value string is not supported as a value of data
type type-name. This error could occur for one of the following reasons:
The XML document docid was not decomposed. |
Consult the W3C recommendation on XML schema to determine the value space of the XML schema type. Validate that the XML document is consistent with the annotated XML schema you are using for decomposition. If the value appears to be in the value space for the type, check the range limits for the value in DB2 as documented in the XQuery Reference. If the XML value is out of range for the data type, map the elements or attributes that contains such values to a character string column. If the XML schema requires correction, it must be registered again in the XML schema respository (XSR) and enabled for decomposition. Then retry the decomposition. sqlcode: -16267 sqlstate: 225D3 |
|
SQL16268N |
The special numeric values INF, -INF, or NaN found at or near lineno of document docid cannot be assigned to a column. |
Decomposition processing found one of the special numeric values INF, -INF, or NaN at or near line number lineno in the document with identifier docid. These special values for XML schema floating point types are not valid values for assignment to numeric columns. The XML document docid was not decomposed. |
Possible methods of resolution:
sqlcode: -16268 sqlstate: 225D4 |
|
SQL16269N |
Element "namespace:elementname" at or near line "lineno" in document "docid" is not recognized. |
The element namespace:elementname at or near line
lineno in document docid is not recognized based
on the annotated XML schema in use for decomposition.
Possible causes:
The XML document docid was not decomposed. |
Check that the XML document docid is consistent with the annotated XML schema you are using for decomposition. One method of checking is to run XML decomposition again with validation turned on to ensure that document is valid. You should also check for use of features that are not supported for decomposition, such as substitution groups and xsi:type. If the annotated XML schema requires correction, it must be registered again in the XML schema respository (XSR) and enabled for decomposition. sqlcode: -16269 sqlstate: 225D5 |
|
SQL16270N |
Element "namespace:elementname" at or near line "lineno" in document "docid" is not valid in the context where it was found. |
The location with respect to the root element in the XML document of the element namespace:elementname at or near line lineno in document docid does not correspond to its position relative to the root as specified in the annotated XML schema used for decomposition or the element might be unreachable because it violates the cardinality specified in the annotated XML Schema. The XML document docid was not decomposed. |
Check that the XML document docid is consistent with the annotated XML schema you are using for decomposition. One method of checking is to run XML decomposition again with validation turned on to ensure that document is valid. If the annotated XML schema requires correction, it must be registered again in the XML schema respository (XSR) and enabled for decomposition. sqlcode: -16270 sqlstate: 225D5 |
|
SQL16271N |
Unknown attribute "namespace:attributename" at or near line "lineno" in document "docid". |
The specified attribute encountered in the document is not found the in the annotated XML schema you are using for decomposition. The XML document docid was not decomposed. |
Check that the XML document is consistent with the annotated XML schema you are using for decomposition. One method of checking is to run XML decomposition again with validation turned on to ensure that document is valid. If the annotated XML schema requires correction, it must be registered again in the XML schema respository (XSR) and enabled for decomposition. sqlcode: -16271 sqlstate: 225D5 |
|
SQL16272N |
Annotated XML schema requires migration from version xdbversion to the current version. |
The generated meta data for the annotated XML schema is from version xdbversion which is not valid for the current version of DB2. Decomposition cannot be performed for XML documents using this annotated XML schema until it has been migrated to the current version. Decomposition of the XML document was not started. |
Run db2xdbmig to migrate the meta data to the current version and then try the decomposition operation again. sqlcode: -16272 sqlstate: 225D6 |
|
SQL16273N |
For the XML document, docid, the XML schema identifier xml-schema-id contains no valid mappings for root element namespace:element-name or its descendants. |
Possible reasons for this error condition include:
The XML document docid was not decomposed. |
Check the annotations in the registered XML schema for the possible errors indicated in this message's Explanation. Additionally, check that the mapped items, as reflected by the data in the column MAPPINGDESCRIPTION of the view SYSCAT.XDBMAPSHREDTREES for the row corresponding to xml-schema-id, are as intended. Correct any erroneous annotations, register the XML schema again, and try decomposing the document again. sqlcode: -16273 sqlstate: 225D7 |
|
SQL16274N |
An SQL error occurred while preparing to insert data for rowset rowsetname. Information returned for the error includes SQLCODE sqlcode, SQLSTATE sqlstate, and message tokens token-list. |
An SQL error occurred preparing to perform the operation on the table or nickname associated with the specified rowset rowsetname based on the annotated XML schema. Some possible causes are:
The sqlcode, sqlstate and message token list (each token is separated by the vertical bar character) are provided. The message tokens may be truncated. See the corresponding message for the sqlcode for further explanation of the error. Decomposition of the XML document was not started. |
Check the message associated with the SQLCODE. Follow the action suggested by that message. See the db2diag log file for complete information about the error condition. sqlcode: -16274 sqlstate: 225D2 |
|
SQL16275N |
A name starting with string is not a valid QName. It was intended as a QName for structure-type. |
During parsing of an XML document or XML schema for a QName, a string starting with string was encountered that is not a valid QName. It may have started with an invalid character or contained invalid characters for a QName. Parsing or validation did not complete. |
Correct the invalid QName in the XML document or XML schema and try the operation again. sqlcode: -16275 sqlstate: 2200M |
|
SQL16276N |
The number of tables and nicknames that are mapped in the annotated XML schema exceeds the limit of maxtables. |
The total number of distinct tables or nicknames referenced in <db2-xdb:table> and db2-xdb:rowSet (where this refers to an actual database table or nickname, rather than a rowSet) annotations in the entire XML schema exceeds the maximum number maxtables. The XML schema is not enabled for decomposition. |
Reduce the number of distinct tables and nicknames referenced in these annotations to not more than maxtables. sqlcode: -16276 sqlstate: 225DE |
|
SQL16277N |
The global annotation string appears more than once in the XML Schema. Another occurrence of this annotation appears at or near line lineno in xml schema document uri. |
An annotated XML schema can contain at most one occurrence of the annotation string. |
Combine the contents of the multiple string annotations into a single annotation, and ensure that the resulting annotation does not contain any duplicate information. sqlcode: -16277 sqlstate: 225DE |
|
SQL16278W |
One or more documents could not be decomposed. The number of documents successfully decomposed was number-successful. The number of documents attempted was number-attempted. |
Error conditions prevented one or more documents from being decomposed. For more details on the status of each document, refer to the result_report output parameter. |
To decompose the XML documents that were not successfully decomposed:
sqlcode: +16278 sqlstate: 01H53 |
|
SQL16280N |
The XSLT processor returned the following error: error-message. |
The XSLT processor returned the error text error-message because it cannot transform the XML document. There may be a problem with the XML document itself, with the associated stylesheet document, or with the parameter document. The statement cannot be processed. If the error text of error-message appears to be truncated and you need to see the rest of the message, set the database manager configuration parameter, diaglevel, to 4 using, db2 update dbm cfg using diaglevel 4, prior to reissuing the XSLTRANSFORM function. Then consult the db2diag log file for message DIA11500E to find the complete error message. |
Examine your input documents as indicated by the error text of error-message. Correct the problem and resubmit the statement that invoked the XSLT processor. sqlcode: -16280 sqlstate: 225X0 |
|
SQL16402N |
JSON data is not valid. |
A value does not contain correctly formatted JSON data. |
Ensure the value contains valid JSON data. sqlcode: -16402 sqlstate: 22032 |
|
SQL16405N |
Result contains no SQL/JSON item. |
Using the specified SQL/JSON path, an item could not be found. |
Change the path expression so it will return an item. sqlcode: -16405 sqlstate: 22035 |
|
SQL16406N |
JSON data has non-unique keys. |
Two keys within a JSON data contain the same name. |
Correct the JSON data so all the keys have unique names. sqlcode: -16406 sqlstate: 22037 |
|
SQL16407N |
JSON object has non-unique keys. |
Two keys within a JSON object contain the same name. |
Correct the JSON object so all the keys have unique names. sqlcode: -16407 sqlstate: 22037 |
|
SQL16410N |
SQL/JSON member not found. |
The specified member could not be found using the SQL/JSON path expression in strict mode. |
Specify a JSON expression that includes the member or use lax mode. sqlcode: -16410 sqlstate: 2203A |
|
SQL16413N |
SQL/JSON scalar required. |
An SQL/JSON expression resulted in an SQL/JSON array, object or multiple matches. An SQL/JSON array or object cannot be converted to an SQL type. |
Specify an SQL/JSON expression that returns a scalar value. sqlcode: -16413 sqlstate: 2203F |
|
SQL16500N |
An internal error occurred. |
The spatial operation encountered an unexpected internal error. |
Repeat the command. If the problem persists, contact IBM Software Support. msgcode: -16500 sqlstate: 38S01 |
|
SQL16501N |
The spatial operation could not access its memory pool. Reason code: reason-code. |
The spatial operation tried unsuccessfully to access its memory pool. |
Note the reason code reason-code and contact IBM Software Support. msgcode: -16501 sqlstate: 38S02 |
|
SQL16502N |
The spatial operation could not allocate number bytes of memory. |
Not enough memory was available. Possible reasons are that the supply of memory was too low, or that memory was being used by other applications. |
Resolve the memory shortage and repeat the command. msgcode: -16502 sqlstate: 38S03 |
|
SQL16503N |
An internal parameter error occurred. |
The spatial operation encountered an unexpected error in a parameter passed to an internal function. The operation cannot be completed successfully. |
Repeat the command. If the problem persists, contact IBM Software Support. msgcode: -16503 sqlstate: 38S04 |
|
SQL16504N |
The spatial column, schema-name.table-name.column-name, could not be registered with the spatial reference system srs-name because it is already registered with another spatial reference system. |
A spatial reference system is already registered with the spatial column. It cannot be registered again unless it is unregistered first. |
Either unregister the spatial column and then register it with the spatial reference system you want or do not attempt to register it again. msgcode: -16504 sqlstate: 38S53 |
|
SQL16505N |
The spatial column schema-name.table-name.column-name is not registered. |
This spatial column was not registered with a spatial reference system. Therefore, it cannot be unregistered. |
Specify a spatial column that is already registered, or do not attempt to unregister the column. msgcode: -16505 sqlstate: 38S56 |
|
SQL16506N |
Invalid SRS identifier srs-id. |
The spatial reference system identifier srs-id that was provided to the spatial function or method does not identify an existing spatial reference system. |
Specify an existing numeric spatial reference system identifier or create a spatial reference system that is identified by srs-id. To check for existing reference systems, refer to the SYSCAT.ST_SPATIAL_REFERENCE_SYSTEMS catalog view. msgcode: -16506 sqlstate: 38SU1 |
|
SQL16507N |
Null unit name. |
A null was specified as a unit of measure. The specification for a unit of measure must be the unit itself (for example, “meter”). It cannot be a null. |
Either omit the unit of measure when calling the spatial function or method, or specify an existing unit of measure. Consult the catalog view SYSCAT.ST_UNITS_OF_MEASURE for supported units. msgcode: -16507 sqlstate: 38SU2 |
|
SQL16508N |
Unknown unit unit-name. |
The unit unit-name that was provided to the spatial function or method does not identify an existing unit of measure. |
Either omit the unit of measure when calling the spatial function or method, or specify an existing unit of measure. Consult the catalog view SYSCAT.ST_UNITS_OF_MEASURE for supported units. msgcode: -16508 sqlstate: 38SU3 |
|
SQL16509N |
Unsupported conversion to unit unit-name. |
The conversion to the unit unit-name is not supported. The functions ST_Area, ST_Buffer, ST_Length, and ST_Perimeter cannot accept a linear unit of measure if the given geometry is not in a projected coordinate system. |
Use one of the following methods:
msgcode: -16509 sqlstate: 38SU4 |
|
SQL16510N |
No unit in SRS. |
The spatial reference system for the geometry does not have an associated linear or angular unit. The operation cannot be performed in the requested unit of measure. |
Either represent the geometry in a correct spatial reference system, which does have an associated linear or angular unit of measure, or omit the unit parameter when you request the operation. msgcode: -16510 sqlstate: 38SU5 |
|
SQL16511N |
Unknown internal type id type-id. |
The value of the internal type identifier type-id for the geometry is not valid. This error can occur if the internal representation of the geometry is corrupted, or if the geometry was not constructed by one of the supported constructor functions or methods. |
Construct the geometry again by using one of the supported constructor functions or methods. msgcode: -16511 sqlstate: 38SU7 |
|
SQL16512W |
Invalid part number part-number. |
The specified part number part-number is not valid. A null value was returned. |
If the geometry is not empty, then specify a valid part number, which should be greater than 0 (zero) and less then or equal to the maximum number of parts in the geometry collection. You can use the ST_NumGeometries function to determine the number of parts of the geometry collection. If the geometry is empty, the method should not be applied. msgcode: +16512 sqlstate: 01HS0 |
|
SQL16513W |
Invalid ring number ring-number. |
The specified number ring-number for an internal ring is not valid. A null value was returned. |
If the polygon value is not empty, then specify a valid ring number, which should be greater than or equal to 1 (one) and less than or equal to the maximum number of interior rings in the polygon. If the polygon is empty, the function or method should not be applied. You can use the function ST_NumInteriorRings to determine the number of interior rings of the polygon. msgcode: +16513 sqlstate: 01HS1 |
|
SQL16514W |
Invalid point number point-number. |
The specified point number point-number is not valid. A null value was returned. |
If the curve value is not empty, then specify a valid point number, which should be greater than 0 (zero) and less than or equal to the maximum number of points in the curve. If the curve is empty, the function or method should not be applied. You can use the ST_NumPoints function to determine the number of points used to define the curve. msgcode: +16514 sqlstate: 01HS2 |
|
SQL16515N |
Invalid DE9-IM matrix. |
The intersection matrix matrix specified for the ST_Relate function is not valid. The matrix must be exactly 9 characters long, and each character in the matrix must be one of the following: 'T', 'F', '0', '1', '2', or '*'. |
Specify a valid intersection matrix. msgcode: -16515 sqlstate: 38SU9 |
|
SQL16516N |
Transformation to SRS srs-id failed. Reason code: reason-code. |
The geometry could not be transformed from the spatial reference system it is represented into the spatial reference system with the numeric identifier srs-id. The transform failed with reason code reason-code. The reason codes have the following meanings:
|
Represent the geometry in a spatial reference system that can be transformed into the spatial reference system identified by srs-id, or specify a different spatial reference system identifier to transform the geometry into. msgcode: -16516 sqlstate: 38SUC |
|
SQL16517N |
Unsupported cast type-id1, type-id2. |
The attempted cast operation from the data type with the internal type identifier type-id1 to the data type with the internal type identifier type-id2 is not supported. The geometry cannot be processed further. |
Specify a supported cast operation. For more information, refer to the IBM DB2 SQL Reference for the supported cast functions. msgcode: -16517 sqlstate: 38SUD |
|
SQL16518N |
The geometry was not converted to ST_Linestring because it is not a MultiPoint geometry. Internal type type-id. |
The conversion to LineString is only supported for MultiPoint geometries. |
Make sure to use a MultiPoint geometry as input for the conversion. msgcode: -16518 sqlstate: 38SUE |
|
SQL16519N |
The spatial operation was unable to register a column named schema-name.table-name.column-name because it is not a spatial column. |
Either this column does not have a spatial data type, or it does not belong to a local table. |
Define a spatial data type for column schema-name.table-name.column-name, or specify a column with a spatial data type as declared type. msgcode: -16519 sqlstate: 38S5E |
|
SQL16520N |
A geometry was not created from the specified KML document because of an error in the KML document. Reason code: reason-code. Content near the error in the KML file: fragment. |
The KML document cannot be converted into a geometry object due to the following reason:
|
Review the KML document and fix the format. msgcode: -16520 sqlstate: 38SUF |
|
SQL16521N |
Representation too short (length bytes). |
The representation of the geometry in well-known binary (WKB) representation or the shape representation is only length bytes long. It needs to have at least 4 bytes for the shape representation, exactly 5 bytes for the well-known binary representation for empty geometries, and at least 9 bytes for the well-known binary representation for non-empty geometries. The binary representation must also be long enough to contain all of the geometry points. |
Provide a valid well-known binary representation or shape representation to the function or method. msgcode: -16521 sqlstate: 38SUK |
|
SQL16522N |
Internal geometry too short. |
The internal representation of the geometry is too short. It could not be processed further. This error can occur if the internal representation of the geometry is corrupted, or if the geometry was not constructed by one of the supported constructor functions or methods. |
Construct the geometry again using one of the supported constructor functions or methods. msgcode: -16522 sqlstate: 38SUL |
|
SQL16523N |
Geometry inconsistent. |
The geometry value is inconsistent and cannot be processed any further. |
Recreate the geometry from a valid binary or text representation. msgcode: -16523 sqlstate: 38SUM |
|
SQL16524N |
Point is empty. |
It is invalid to specify an X coordinate, Y coordinate, Z coordinate, or measure for an empty point. If the point is constructed by the constructor function ST_Point, the point's X and Y coordinates must both be null. Furthermore, no Z coordinate or measure should be specified unless it is a null value. If the mutators ST_X, ST_Y, ST_Z, or ST_M are used to modify an empty point, the point's X and Y coordinates must both be null. No Z coordinate or measure should be specified unless it is null. |
Use mutators ST_X, ST_Y, ST_Z, or ST_M to modify points that are not empty, or construct the point by specifying both X and Y coordinates with values that are not null. msgcode: -16524 sqlstate: 38SUO |
|
SQL16525N |
Inconsistent coordinates. |
If a new point is constructed, both the X and Y coordinates must be specified. Both coordinates must be either null or not null. If both coordinate values are null, the resulting point will be empty. In that case, no Z coordinate or measure should be specified unless it is null. |
Specify null values for both the X and Y coordinates, or specify values that are not null for both coordinates. msgcode: -16525 sqlstate: 38SUP |
|
SQL16526N |
Invalid byte order byte-order. |
The byte order in the binary representation of the geometry must be either 0 (zero) or 1 (one), but it is byte-order. In the well-known binary representation, a byte order of 0 (zero) indicates big endian format, and a byte order of 1 (one) indicates little endian format. |
Correct the byte order in the binary representation so that it is either 0 (zero) or 1 (one). msgcode: -16526 sqlstate: 38SUQ |
|
SQL16527N |
Invalid number of points num-points in geometry. |
The geometry has an invalid number of points num-points. This number must be greater than or equal to 0 (zero). If the geometry is not empty, then the following conditions must be
met:
|
Construct the geometry by using the functions or methods supported by the spatial feature. msgcode: -16527 sqlstate: 38SUR |
|
SQL16528N |
Invalid extent (min-coord vs. max-coord) in geometry. |
The extent of the geometry in one of the dimensions is invalid. The minimum coordinate min-coord must be less than or equal to the maximum coordinate max-coord for all dimensions of the geometry. |
Construct the geometry by using the functions or methods supported by the spatial feature. msgcode: -16528 sqlstate: 38SUS |
|
SQL16529N |
Invalid text data (type ids type-id1, type-id2). |
A text representation that is passed as input to this spatial function or method has to represent a geometry whose data type identifier is type-id2. But the representation that was actually passed to the function represents a geometry whose data type identifier is type-id1. No geometry could be constructed. |
Either call the correct function which constructs geometries of type type-id1 or correct the text representation to represent a geometry of type-id2. msgcode: -16529 sqlstate: 38SUV |
|
SQL16530N |
Invalid GML, expecting char instead of string at position position. |
A character char was expected in the Geography Markup Language of the geometry, but the text string was found instead at position position. The GML representation is not valid. The spatial operation cannot construct the geometry successfully. |
Correct the GML representation and construct the geometry again. msgcode: -16530 sqlstate: 38SUW |
|
SQL16531N |
Invalid GML, expecting expected-tag instead of given-tag at position position. |
The tag given-tag was found in the Geography Markup Language of the geometry at position position, but a tag expected-tag was expected. The GML representation is not valid. The spatial operation cannot construct the geometry successfully. |
Correct the GML representation and construct the geometry again. msgcode: -16531 sqlstate: 38SUX |
|
SQL16532N |
Invalid GML, expecting number instead of text at position position. |
Unexpected text text was found in the Geography Markup Language of the geometry at position position. A number representing a coordinate was expected instead. The GML representation is not valid. The spatial operation cannot construct the geometry successfully. |
Correct the GML representation and construct the geometry again. msgcode: -16532 sqlstate: 38SUY |
|
SQL16533N |
Invalid GML type type. |
An unknown type type was specified in the Geography Markup Language of the geometry. The GML supports points, linestrings, polygons, multipoints, multilinestrings, and multipolygons. The spatial operation cannot construct the geometry successfully. |
Correct the GML representation and construct the geometry again. msgcode: -16533 sqlstate: 38SUZ |
|
SQL16534N |
GML point has been incorrectly specified. |
The problem occurred due to one of the following reasons:
The GML representation is not valid. The spatial operation cannot construct the geometry successfully. |
Correct the GML representation and construct the geometry again. msgcode: -16534 sqlstate: 38SV0 |
|
SQL16535N |
Invalid part offset part-offset in shape. |
An invalid offset part-offset for a part in the shape representation of the geometry was encountered. A part offset must be larger than or equal to 0 (zero), and each part offset must be larger than the preceding one. The shape representation is not valid. The spatial operation cannot construct the geometry successfully. |
Correct the shape representation and construct the geometry again. msgcode: -16535 sqlstate: 38SV4 |
|
SQL16536N |
Invalid type ID type-id in shape. |
The shape representation of the geometry contains an invalid type identifier type-id. The shape data is possibly corrupted. The spatial operation cannot construct the geometry successfully. |
Verify and correct the shape representation of the geometry. msgcode: -16536 sqlstate: 38SV5 |
|
SQL16537N |
Invalid length shape-length of shape encoding for type type, expecting only expected-length bytes. |
The shape encoding contains shape-length bytes, which is too long. To encode a geometry of the specified type type, only expected-length bytes are required. The shape data is possibly corrupted. The spatial operation cannot construct the geometry successfully. |
Verify and correct the shape representation of the geometry. msgcode: -16537 sqlstate: 38SV6 |
|
SQL16538N |
Invalid WKT format, expecting char instead of string. |
A character char was expected in the well-known text representation of the geometry, but the text string was found instead. The well-known text representation is not valid. The spatial operation cannot construct the geometry successfully. |
Correct the well-known text representation and construct the geometry again. msgcode: -16538 sqlstate: 38SV7 |
|
SQL16539N |
Invalid WKT format, expecting a number instead of text. |
An unexpected text text was found in the well-known text representation of the geometry. A number representing a coordinate was expected instead. The well-known text representation is not valid. The spatial operation cannot construct the geometry successfully. |
Correct the well-known text representation and construct the geometry again. msgcode: -16539 sqlstate: 38SV8 |
|
SQL16540N |
Unexpected parenthesis in WKT format at text. |
An unexpected opening or closing parenthesis was found in the well-known text representation of the geometry at text. The well-known text representation is not valid. The spatial operation cannot construct the geometry successfully. |
Correct the well-known text representation and construct the geometry again. msgcode: -16540 sqlstate: 38SV9 |
|
SQL16541N |
Parenthesis mismatch in WKT format, expecting parenthesis. |
The end of the well-known text representation was reached unexpectedly. A parenthesis parenthesis was expected. The well-known text representation is not valid. The spatial operation cannot construct the geometry successfully. |
Correct the well-known text representation and construct the geometry again. msgcode: -16541 sqlstate: 38SVA |
|
SQL16542N |
Unknown type type in WKT. |
The well-known text representation of the geometry contains an unknown type name of type. The well-known text representation is not valid. The spatial operation cannot construct the geometry successfully. |
Correct the well-known text representation and construct the geometry again. msgcode: -16542 sqlstate: 38SVB |
|
SQL16543N |
Invalid type id type-id in WKB. |
The well-known binary representation of the geometry contains an invalid type identifier type-id. The data is possibly corrupted. The spatial operation cannot construct the geometry successfully. The type identifiers of separate parts in a geometry collection (multipoint, multilinestring, or multipolygon) must have the same indicators for the Z and M coordinates as the geometry collection itself. |
Verify and correct the well-known binary representation of the geometry. msgcode: -16543 sqlstate: 38SVC |
|
SQL16544N |
Unknown error error-code. |
An internal error with code error-code was encountered when a geometry was processed. |
Note the error and contact IBM Software Support. msgcode: -16544 sqlstate: 38SS0 |
|
SQL16545N |
Insufficient memory. |
Not enough memory was available for the spatial function or method that you invoked. |
Make more memory available to the database manager process that executes the function or method. msgcode: -16545 sqlstate: 38SS2 |
|
SQL16546N |
Invalid geometry type. |
An invalid type of geometry was passed to the function or method that you invoked. |
Specify a valid geometry. For more information, refer to the IBM DB2 Spatial Analytics documentation. msgcode: -16546 sqlstate: 38SS3 |
|
SQL16547N |
Too many parts specified. |
The number of parts indicated in the binary or text representation of the geometry is greater than the actual number of parts supplied. Either the number of parts indicated is too high or not all the parts were supplied. |
Specify the correct number of parts or supply all parts for the geometry. msgcode: -16547 sqlstate: 38SS5 |
|
SQL16548N |
Incorrect geometry type. |
The wrong type of geometry was passed to the function or method that you invoked. For example, a linestring might have been passed to a function or method that takes only polygons as input. |
Either pass to the function or method a type of geometry that it can process, or use a function or method that accepts the type of geometry that you want to pass. msgcode: -16548 sqlstate: 38SS6 |
|
SQL16549N |
Text is too long. |
The geometry contains too much detail to be converted to its well-known text representation. The well-known text representation exceeds the maximum allowable length (2 gigabytes). |
Simplify the geometry - for example, by using the ST_Generalize function - or convert the geometry to its well-known binary representation. msgcode: -16549 sqlstate: 38SS7 |
|
SQL16550N |
Invalid parameter value. |
An invalid parameter was encountered. |
Refer to the IBM DB2 Spatial Analytics documentation for the function's correct syntax and retry the operation. If the problem persists, contact IBM Software Support. msgcode: -16550 sqlstate: 38SS8 |
|
SQL16551N |
Invalid geometry produced. |
The parameters provided for the function or method have produced an invalid geometry; for example, an invalid shape representation. An invalid geometry is one that violates a geometry property. |
Construct the geometry again from a valid representation. msgcode: -16551 sqlstate: 38SS9 |
|
SQL16552N |
Incompatible geometries. |
The function or method expected two geometries of a certain type and did not receive them. For example, the ST_AddPoint function expects two geometries, one a representation and the other a point. |
Specify geometries that the function or method accepts as valid input. To determine what types of geometries are valid for this function or method, refer to the IBM DB2 Spatial Analytics documentation. msgcode: -16552 sqlstate: 38SSA |
|
SQL16553N |
Invalid geometry. |
The function or method cannot process the geometry passed to it because one or more properties of the geometry violate the geometry's integrity. |
Use the ST_IsValid function to validate the geometry. Construct the geometry again from a correct representation if it is not valid. msgcode: -16553 sqlstate: 38SSB |
|
SQL16554N |
Too many points. |
The construction of a geometry has exceeded the 1-megabyte storage limit; the geometry has too many points. |
Construct a geometry that contains fewer points. Or, if possible, remove some points. For performance and storage considerations, include only those points that are needed to render a geometry. msgcode: -16554 sqlstate: 38SSC |
|
SQL16555N |
Geometry too small. |
The geometry returned by the ST_Difference, ST_Intersection, ST_SymDifference, or ST_Union function is too small to be represented accurately in the current spatial reference system. For example, this can happen if the internal computation constructs a very thin polygon, but the scale factor of the spatial reference system is so low that the geometry would collapse to a linestring if it were to be represented in this spatial reference system. It would lose its property as a polygon. |
Use a spatial reference system for the calculation which allows for a higher resolution. The ST_Transform function can be used to convert a geometry from one spatial reference system into another. msgcode: -16555 sqlstate: 38SSD |
|
SQL16556N |
Buffer out of bounds. |
The ST_Buffer function has created a buffer around the provided geometry that is outside the range of the coordinates to which the spatial reference system applies. Refer to the SYSCAT.ST_SPATIAL_REFERENCE_SYSTEMS catalog view to determine the minimum and maximum absolute values for each of the dimensions. These values must not be exceeded by the calculated buffer. |
Either reduce the distance to be used for the buffer calculation, or change the spatial reference system in which the calculation is done. The ST_Transform function can be used to convert geometries from one spatial reference system into another. msgcode: -16556 sqlstate: 38SSE |
|
SQL16557N |
Invalid scale factor. |
A scale factor for any of the four dimensions (X, Y, Z, and M) must be greater than or equal to 1 (one). |
Use a correctly defined spatial reference system to represent the geometry. msgcode: -16557 sqlstate: 38SSF |
|
SQL16558N |
Coordinate out of bounds. |
A coordinate cannot be represented in the spatial reference system because, in at least one dimension, it exceeds the possible minimum or maximum absolute value within the system's range of values. |
Determine whether the coordinate is correct. If it is, determine whether it fits within the extent of the spatial reference system that you are using. For information about this spatial reference system, consult the SYSCAT.ST_SPATIAL_REFERENCE_SYSTEMS catalog view to determine the minimum and maximum absolute values for each of the dimensions. msgcode: -16558 sqlstate: 38SSG |
|
SQL16559N |
Invalid coordinate system definition. |
There are one or more errors in the text representation of the definition of the coordinate system on which the geometry's spatial reference system is based. The representation cannot be converted into a valid projection. |
Verify the coordinate system definition of the spatial reference system. Alternatively, construct the geometry in a spatial reference system that is associated with a valid coordinate system. The ST_EqualCoordsys function can be used to verify the coordinate system definition by comparing it with itself. msgcode: -16559 sqlstate: 38SSH |
|
SQL16560N |
Projection error. |
An error occurred during an attempt to project a geometry to another spatial reference system. |
Make sure that the geometry is within the legal domain of the projection. msgcode: -16560 sqlstate: 38SSI |
|
SQL16561N |
Polygon rings overlap. |
The rings of a polygon overlap. By definition, the inner and outer rings of a polygon must not overlap. They can intersect only at a tangent, which means the rings can only touch but not cross each other. |
Specify the coordinates for the polygon that will not produce overlapping rings. Note that the scale factors of the spatial reference system for the geometry have an influence on the precision. msgcode: -16561 sqlstate: 38SSJ |
|
SQL16562N |
Too few points. |
The error is a result of one of the following:
Note that if the geometry to be constructed is empty, these rules do not apply. |
Construct the geometry again from a valid set of points. msgcode: -16562 sqlstate: 38SSK |
|
SQL16563N |
Polygon is not closed. |
The inner and outer rings that define the polygon must be closed. A ring is closed if the start and end points are identical in the X and Y dimensions. If the polygon has Z coordinates, then the start and end points must also be identical to the Z coordinates. Note that this rule does not apply to measures, which can be different for the start and end points. |
Specify inner and outer rings for the polygon that have the same points for the start and end points in the X and Y dimension. If the polygon has Z coordinates, the start and end points of the Z coordinate points also have to be identical. If the polygon has measures, the start and end points can be different. msgcode: -16563 sqlstate: 38SSL |
|
SQL16564N |
Invalid exterior ring. |
The exterior ring of the polygon is not valid. The exterior ring of a polygon must enclose all interior rings of the polygon. All interior rings have to be completely inside the area that is defined by the outer ring and must not cross the exterior ring. |
Specify a geometry that consists of a valid set of interior and exterior rings, where the interior rings lie fully within the area that is enclosed by the exterior ring to represent it. If the geometry has multiple polygons, use a multipolygon. msgcode: -16564 sqlstate: 38SSM |
|
SQL16565N |
Polygon has no area. |
The specified polygon lacks an interior that covers an area that is not the empty set in the X and Y dimensions. A geometry is a polygon only if its coordinates span two dimensions in the 2-dimensional space defined by the X and Y coordinates. |
Specify a polygon that encloses an area that is not empty. If the polygon is empty, construct an empty polygon. msgcode: -16565 sqlstate: 38SSN |
|
SQL16566N |
Exterior rings overlap. |
The exterior rings of distinct polygons in a multipolygon overlap. Distinct polygons in a multipolygon must not overlap, and the boundaries must touch only at a finite number of points. That means the polygons must not share line segments. The scale factors of the spatial reference system that is used to represent the geometry influences the precision that applies to the coordinates. Rounding operations performed when the geometry is converted to the representation in the spatial reference system might cause a loss in precision and, subsequently, this error. |
Specify coordinates for the polygon that will not produce overlapping rings. Note that the scale factors of the spatial reference system have an influence on precision. Refer to the Spatial Analytics catalog view SYSCAT.ST_SPATIAL_REFERENCE_SYSTEMS for the scale factor used for the spatial reference system in which the geometry will be represented. msgcode: -16566 sqlstate: 38SSO |
|
SQL16567N |
Polygon intersects itself. |
A ring of a polygon cannot intersect itself. The start and end points on each ring of the polygon must be reached twice when traversing the ring. All other points must only be reached once. This holds true also for the line segments that define the rings of the polygon. The scale factors of the spatial reference system that is used to represent the geometry influences the precision that applies to the coordinates. Rounding operations performed when the geometry is converted to the representation in the spatial reference system might cause a loss in precision and, subsequently, this error. |
Construct a valid polygon in which the rings do not intersect themselves. Refer to the Spatial Analytics catalog view SYSCAT.ST_SPATIAL_REFERENCE_SYSTEMS for the scale factor used for the spatial reference system in which the geometry will be represented. msgcode: -16567 sqlstate: 38SSP |
|
SQL16568N |
Invalid number of parts. |
The number of parts indicated in the binary or text representation of the geometry is not equal to the actual number of parts supplied. Either the number is too low or too many parts were supplied to the function or method. |
Specify the correct number of parts or supply all parts for the geometry. msgcode: -16568 sqlstate: 38SSQ |
|
SQL16569N |
Incompatible spatial reference systems. |
The two spatial reference systems are not compatible. They cannot be transformed into or compared with one another. The operation cannot be completed successfully. |
Specify two compatible spatial reference systems. msgcode: -16569 sqlstate: 38SSR |
|
SQL16570N |
BLOB too small. |
The number of bytes in the specified binary representation of the geometry is too small. |
Specify a valid binary representation of the geometry. msgcode: -16570 sqlstate: 38SSS |
|
SQL16571N |
Invalid geometry type. |
An invalid internal geometry type was encountered. The geometry is not valid and will not be processed any further. |
Construct the geometry again from a valid binary or text representation. msgcode: -16571 sqlstate: 38SST |
|
SQL16572N |
Invalid byte order. |
The byte order in the binary representation of the geometry has an invalid value. The byte order must be 0 (zero) or 1 (one). In the well-known binary representation, a byte order of 0 (zero) indicates big endianess, and a byte order of 1 (one) indicates little endianess. |
Specify a valid byte order in the binary representation for the geometry. msgcode: -16572 sqlstate: 38SSU |
|
SQL16573N |
Empty geometry. |
An empty geometry was passed to the ST_AsBinary function, even though it is not allowed as input. |
Edit the SQL statement that you submitted so that only non-empty geometries will be passed to the ST_AsBinary function. For example, you can use the ST_IsEmpty function in the WHERE clause to exclude empty geometries. msgcode: -16573 sqlstate: 38SSV |
|
SQL16574N |
Invalid end point. |
The specified point is intended to be appended to the curve, but it is not valid. |
Specify a valid point to be appended. msgcode: -16574 sqlstate: 38SSW |
|
SQL16575N |
Point not found. |
The specified point is intended to be changed or removed, but it does not exist in the curve. |
Specify a point that does exist in the curve. msgcode: -16575 sqlstate: 38SSX |
|
SQL16577N |
The specified spatial reference system srs-name cannot be dropped because a spatial column is registered with this spatial reference system. |
At least one spatial column exists that is associated with the specified spatial reference system srs-name. The spatial reference system cannot be dropped. |
Unregister all spatial columns that are associated with the specified spatial reference system. Then try to drop the spatial reference system again. msgcode: -16577 sqlstate: 38S69 |
|
SQL16578N |
The spatial column, schema-name.table-name.column-name, could not be registered. Reasoncode: reason_code. |
The geometry column cannot be registered with the spatial reference system
due to one of the following reasons:
|
msgcode: -16578 sqlstate: 38SP5 |
|
SQL16579W |
The coordinate system coordsys-name is predefined or user defined. Coordinate system parameters are corrected automatically. The operation completed successfully. |
If the specified coordinate system is predefined or user defined, coordinate system parameters that not matching the existing definition e.g. (organization_coordsys_id/ organization/ definition) are automatically corrected. The operation completed successfully otherwise. |
Review the coordinate system parameters in SYSCAT.ST_COORDINATE_SYSTEMS. msgcode: +16579 sqlstate: 01HS3 |
|
SQL16580N |
A spatial reference system named srs-name already exists. |
A spatial reference system named srs-name already exists. Another spatial reference system with the same name cannot be created. |
Specify a unique name for the spatial reference system to be created and retry the operation. msgcode: -16580 sqlstate: 38S5K |
|
SQL16581N |
A spatial reference system with the numeric identifier srs-id already exists. |
Your request to create a spatial reference system could not be met because the numeric identifier srs-id that you assigned to it already identifies another spatial reference system. A spatial reference system's identifier must be unique. |
Specify a unique numeric identifier for the spatial reference system. msgcode: -16581 sqlstate: 38S64 |