DB2 Versão 12 - SQLCodes positivos - Guia de referência - www.cadcobol.com.br


clique aqui para imprimir esta página

Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

DB2 Versão 12 - SQLCodes positivos - Guia de referência - www.cadcobol.com.br
  • +000  successful execution

  • +012  the unqualified column name column-name was interpreted as a correlated reference

  • +020  bind, rebind, or precompile option option-name is not supported by the target server and will be ignored.

  • +098  a dynamic sql statement ends with a semicolon.

  • +100  row not found for fetch, update or delete, or the result of a query is an empty table

  • +110  sql update to a data capture table not signaled to originating subsystem

  • +111  the subpages option is not supported for type 2 indexes

  • +117  the number of insert values is not the same as the number of object columns

  • +162  tablespace database-name.tablespace-name has been placed in check pending

  • +203  the qualified column name column-name was resolved using a non-unique or unexposed name

  • +204  name is an undefined name

  • +205  column-name is not a column of table table-name

  • +206  column-name is not a column of an inserted table, updated table, merged table, or any table identified in a from clause

  • +217  the statement was not executed as only explain information requests are being processed.

  • +218  the sql statement referencing a remote object cannot be explained

  • +219  the required explanation table table-name does not exist

  • +220  the column column-name in explanation table table-name is not defined properly

  • +222  hole detected using cursor cursor-name

  • +231  current position of cursor cursor-name is not valid for the specified fetch orientation of the current row or rowset

  • +236  sqlda includes integer1 sqlvar entries, but integer2 are required for integer3 columns

  • +237  sqlda includes integer1 sqlvar entries, but integer2 are required because at least one of the columns being described is a distinct type

  • +238  sqlda includes integer1 sqlvar entries, but integer2 sqlvar entries are needed for integer3 columns because at least one of the columns being described is a lob

  • +239  sqlda includes integer1 sqlvar entries, but integer2 are required for integer3 columns because at least one of the columns being described is a distinct type

  • +252  a non-atomic statement statement successfully processed all requested rows, with one or more warning conditions

  • +304  a value with data type data-type1 cannot be assigned to a host variable because the value is not within the range of the host variable in position position-number with data type data-type2

  • +331  the null value has been assigned to a host variable or parameter because the string cannot be converted from source-ccsid to target-ccsid. reason reason-code, position position-number

  • +335  db2 converted a host variable, parameter, or column number var-num var-name-or-num to column name, host variable, or expression number col-name-or-num from from ccsid to to-ccsid, and resulting in substitution characters.

  • +347   the recursive common table expression name may contain an infinite loop

  • +354  a rowset fetch statement may have returned one or more rows of data. however, one or more warning conditions were also encountered. use the get diagnostics statement for more information regarding the conditions that were encountered

  • +361  command was successful but resulted in the following: msg-token

  • +364  decfloat exception exception-type has occurred during operation-type operation, position position-number

  • +385  assignment to an sqlstate or sqlcode variable in an sql routine routine-name may be overwritten and does not activate any handler

  • +394  all user specified optimization hints used during access path selection

  • +395  a user specified optimization hint is invalid (reason code = reason-code)

  • +402  location location is unknown

  • +403  the local object referenced by the create alias statement does not exist

  • +434  clause is a deprecated clause

  • +438  application raised warning with diagnostic text: text

  • +440  no routine-type by the name routine-name having compatible arguments was found

  • +445  value value has been truncated

  • +462  external function or procedure name (specific name specific-name) has returned a warning sqlstate, with diagnostic text text

  • +464  procedure proc returned num query result sets, which exceeds the defined limit integer

  • +466  procedure proc returned num query results sets

  • +494  number of result sets is greater than number of locators

  • +495  estimated processor cost of estimate-amount1 processor seconds (estimate-amount2 service units) in cost category cost-category exceeds a resource limit warning threshold of limit- amount service units

  • +535  the result of the positioned update or delete may depend on the order of the rows

  • +541  the referential or unique constraint name has been ignored because it is a duplicate

  • +551  auth-id does not have the privilege to perform operation operation on object object-name

  • +552  auth-id does not have the privilege to perform operation operation

  • +558  the with grant option is ignored.

  • +562  a grant of a privilege was ignored because the grantee already has the privilege from the grantor

  • +585  the collection collection-id appears more than once when setting the special-register special register

  • +599  comparison functions are not created for a distinct type based on a long string data type

  • +610  a create/alter on object object-name has placed object in utility-name pending

  • +645  where not null is ignored because the index key cannot contain null values or the index is an xml index

  • +650  the table being created or altered cannot become a dependent table

  • +653  table table-name in partitioned tablespace tspace-name is not available because its partitioned index has not been created

  • +655  stogroup stogroup_name has both specific and non-specific volume ids. it will not be allowed in future releases

  • +658  the subpages value is ignored for the catalog index index-name

  • +664  the internal length of the limit-key fields specified in the partition clause of the statement-name statement exceeds the existing internal limit key length stored in catalog table table-name

  • +738  definition change of object object_name may require similar change on read-only systems

  • +799  the set statement set-stmt references a special register that does not exist at the server site

  • +802  exception error exception-type has occurred during operation-type operation on data-type data, position position-number

  • +806  bind isolation level rr conflicts with tablespace locksize page or locksize row and lockmax 0

  • +807  the result of decimal multiplication may cause overflow

  • +863  the connection was successful but only sbcs will be supported

  • +883  rollback to savepoint occurred when there were operations that cannot be undone, or an operation that cannot be undone occurred when there was a savepoint outstanding

  • +4726  the statement was successfully prepared, but it cannot be executed because authorization-id does not have privilege-name privilege on object object-name but has explain privilege

  • +4745  a section was bound successfully, but an error occurred when a statement in a related extended section was bound. information returned: section number section-number, sqlcode sqlcode, sqlstate sqlstate, and message tokens token-list

  • +4748  the statement statement for object object-name was successful on the db2 server. the object may not have been successfully processed on the accelerator server for reason reason-code.

  • +4751  bind-type warning for package  = package-name, the use of keyword resulted in unsuccessful completion for one or more statements.

  • +20002  the specification-source specification is ignored for object object-name

  • +20007  use of optimization hints is disallowed by a db2 subsystem parameter. the special register 'optimization hint' is set to an empty string.

  • +20122  define no option is not applicable in the context specified

  • +20141  truncation of value with length length occurred for hv-or-parm-number

  • +20187  rollback to savepoint caused a not logged table space to be placed in the lpl

  • +20224  encrypted data that was originally a binary string cannot be decrypted to a character string

  • +20237  fetch prior rowset for cursor cursor-name returned a partial rowset

  • +20245  not padded clause is ignored for indexes created on auxiliary tables

  • +20270  option not specified following alter partition clause

  • +20271  the name at ordinal position position-number in the statement, with name object-name, was truncated.

  • +20272  table space table-space-name has been converted to use table-controlled partitioning instead of index-controlled partitioning, additional information: old-limit-key-value

  • +20278  the view view-name may not be used to optimize the processing of queries

  • +20341  ownership transfer was ignored because auth-id is already the owner of the object.

  • +20348  the path value has been truncated.

  • +20360  trusted connection can not be established for system authid authorization-name

  • +20365  a signaling nan was encountered, or an exception occurred in an arithmetic operation or function involving a decfloat.

  • +20367  option clause is not supported in the context in which it was specified

  • +20368  trusted context context-name is no longer defined to be used by specific values for attribute attribute-name.

  • +20371  the ability to use trusted context context-name was removed from some, but not all authorization ids specified in the statement.

  • +20378  a non-atomic statement statement successfully completed for some of the requested rows, possibly with warnings, and one or more errors, and the cursor can be used

  • +20458  the procedure procedure-name has encountered an internal parameter processing error in parameter number1. the value for parameter number2 contains further information about the error.

  • +20459  the procedure procedure-name had encountered an internal processing error. the value for parameter number contains further information about the error.

  • +20460  the procedure procedure-name supports a higher version, version1. than the specified version, version2, for parameter number.

  • +20461  the procedure procedure-name returned output in the alternate locale, locale1, instead of the locale locale2, specified in parameter number.

  • +20468  the combination of target namespace target-namespace and schema location hint location-hint is not unique in the db2 xml schema repository.

  • +20520  attempt to use a deprecated feature on object object-name. reason code reason-code

  • +20543  a system parameter was overridden for object-name when processing the statement-name statement. reason reason-code

  • +30100  operation completed successfully but a distribution protocol violation has been detected. original sqlcode=original-sqlcode and original sqlstate=original-sqlstate


  • © Copyright IBM Corp.