DB2 Versão 12 - SQLCodes positivos - Guia de referência - www.cadcobol.com.br
Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - firstname.lastname@example.org
DB2 Versão 12 - SQLCodes positivos - Guia de referência - www.cadcobol.com.br
the unqualified column name column-name was interpreted as a correlated reference
bind, rebind, or precompile option option-name is not supported by the target server and will be ignored.
a dynamic sql statement ends with a semicolon.
row not found for fetch, update or delete, or the result of a query is an empty table
sql update to a data capture table not signaled to originating subsystem
the subpages option is not supported for type 2 indexes
the number of insert values is not the same as the number of object columns
tablespace database-name.tablespace-name has been placed in check pending
the qualified column name column-name was resolved using a non-unique or unexposed name
name is an undefined name
column-name is not a column of table table-name
column-name is not a column of an inserted table, updated table, merged table, or any table identified in a from clause
the statement was not executed as only explain information requests are being processed.
the sql statement referencing a remote object cannot be explained
the required explanation table table-name does not exist
the column column-name in explanation table table-name is not defined properly
hole detected using cursor cursor-name
current position of cursor cursor-name is not valid for the specified fetch orientation of the current row or rowset
sqlda includes integer1 sqlvar entries, but integer2 are required for integer3 columns
sqlda includes integer1 sqlvar entries, but integer2 are required because at least one of the columns being described is a distinct type
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
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
a non-atomic statement statement successfully processed all requested rows, with one or more warning conditions
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
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
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.
the recursive common table expression name may contain an infinite loop
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
command was successful but resulted in the following: msg-token
decfloat exception exception-type has occurred during operation-type operation, position position-number
assignment to an sqlstate or sqlcode variable in an sql routine routine-name may be overwritten and does not activate any handler
all user specified optimization hints used during access path selection
a user specified optimization hint is invalid (reason code = reason-code)
location location is unknown
the local object referenced by the create alias statement does not exist
clause is a deprecated clause
application raised warning with diagnostic text: text
no routine-type by the name routine-name having compatible arguments was found
value value has been truncated
external function or procedure name (specific name specific-name) has returned a warning sqlstate, with diagnostic text text
procedure proc returned num query result sets, which exceeds the defined limit integer
procedure proc returned num query results sets
number of result sets is greater than number of locators
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
the result of the positioned update or delete may depend on the order of the rows
the referential or unique constraint name has been ignored because it is a duplicate
auth-id does not have the privilege to perform operation operation on object object-name
auth-id does not have the privilege to perform operation operation
the with grant option is ignored.
a grant of a privilege was ignored because the grantee already has the privilege from the grantor
the collection collection-id appears more than once when setting the special-register special register
comparison functions are not created for a distinct type based on a long string data type
a create/alter on object object-name has placed object in utility-name pending
where not null is ignored because the index key cannot contain null values or the index is an xml index
the table being created or altered cannot become a dependent table
table table-name in partitioned tablespace tspace-name is not available because its partitioned index has not been created
stogroup stogroup_name has both specific and non-specific volume ids. it will not be allowed in future releases
the subpages value is ignored for the catalog index index-name
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
definition change of object object_name may require similar change on read-only systems
the set statement set-stmt references a special register that does not exist at the server site
exception error exception-type has occurred during operation-type operation on data-type data, position position-number
bind isolation level rr conflicts with tablespace locksize page or locksize row and lockmax 0
the result of decimal multiplication may cause overflow
the connection was successful but only sbcs will be supported
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
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
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
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.
bind-type warning for package = package-name, the use of keyword resulted in unsuccessful completion for one or more statements.
the specification-source specification is ignored for object object-name
use of optimization hints is disallowed by a db2 subsystem parameter. the special register 'optimization hint' is set to an empty string.
define no option is not applicable in the context specified
truncation of value with length length occurred for hv-or-parm-number
rollback to savepoint caused a not logged table space to be placed in the lpl
encrypted data that was originally a binary string cannot be decrypted to a character string
fetch prior rowset for cursor cursor-name returned a partial rowset
not padded clause is ignored for indexes created on auxiliary tables
option not specified following alter partition clause
the name at ordinal position position-number in the statement, with name object-name, was truncated.
table space table-space-name has been converted to use table-controlled partitioning instead of index-controlled partitioning, additional information: old-limit-key-value
the view view-name may not be used to optimize the processing of queries
ownership transfer was ignored because auth-id is already the owner of the object.
the path value has been truncated.
trusted connection can not be established for system authid authorization-name
a signaling nan was encountered, or an exception occurred in an arithmetic operation or function involving a decfloat.
option clause is not supported in the context in which it was specified
trusted context context-name is no longer defined to be used by specific values for attribute attribute-name.
the ability to use trusted context context-name was removed from some, but not all authorization ids specified in the statement.
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
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.
the procedure procedure-name had encountered an internal processing error. the value for parameter number contains further information about the error.
the procedure procedure-name supports a higher version, version1. than the specified version, version2, for parameter number.
the procedure procedure-name returned output in the alternate locale, locale1, instead of the locale locale2, specified in parameter number.
the combination of target namespace target-namespace and schema location hint location-hint is not unique in the db2 xml schema repository.
attempt to use a deprecated feature on object object-name. reason code reason-code
a system parameter was overridden for object-name when processing the statement-name statement. reason reason-code
operation completed successfully but a distribution protocol violation has been detected. original sqlcode=original-sqlcode and original sqlstate=original-sqlstate
© Copyright IBM Corp.