TenFourFox (aka Firefox) V10.0 Beta 1 ready for Apple iMac PPC’s G3,G4 & G5

Posted by jnorthr on

The staff at Floodgap Software have worked overtime to keep us older Apple iMac people happy by reworking the Mozilla source code for Firefox. This allows them to produce a version of this famous browser for the PowerPC chipsets found in older Apple iMac, Powerbooks, etc. Supported chipsets include G3, G4 and G5 processors. You can look at their Floodgap Intro Page here: http://www.floodgap.com/software/tenfourfox/

Grab a download of TenFourFox Version 10.0 beta 1 (Firefox) for your iMac PowerPC Chipset system here: http://code.google.com/p/tenfourfox/downloads/list. You will need to know which processor your system has.

The release notes can be found here : http://code.google.com/p/tenfourfox/wiki/ReleaseNotes10Beta1

Developer notes can be found here: http://tenfourfox.blogspot.com/2012/01/100b1-stable-available.html

Derby SQL State Codes – 10.8.1

Posted by jnorthr on 
/*

   Derby - Class org.apache.derby.shared.common.reference.SQLState

   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.

 */

Got tired of looking for these SQL State Codes for my Derby problems. Perhaps the following list will help you too. The SQL codes are used in Derby 10.8.1.2 so may or may not change in more recent version. I have made them alphabetical, so you can look down the left-hand side for your code. Many codes also imply a severity level which i have done my best to decode, but take these levels as ‘suggested’ ones.

Some sql state codes are IBM specific :

Reserved for IBM Use: XQC00 - XQCZZ

which were introduced when IBM was in control of Derby before IBM made it open sourcce.

Not all state codes are shown or known.  The list was taken from http://javasourcecode.org/html/open-source/derby/derby-10.8.1.2/org/apache/derby/shared/common/reference/SQLState.java.htmlwhich you may want to read yourself for further details.

Remember that not all SQL state codes indicate a true failure as such. Codes beginning with ’01′ are only warnings of potential doom.

For example, on recent testing with sql inserts into a derby database 10.8.1, i found that if the insert statement failed due to a duplicate key condition, where the new row had data values that would conflict with an existing row, then i needed additional java warning (or groovy in this example) logic to catch that ‘partial’ failure.

import javax.sql.*
import java.sql.SQLException
import java.sql.SQLWarning
...
// stmt = "insert into A04 (USERID,USERNAME,PWID,SECURITY) values(?,?,?,?) "
           try {
                    switch(flag)
                    {
                        case 1:     sql.execute(stmt,parms)
                                    say "added row"
                                    return true;
                                    break;
                    }   // end of switch
                    say "row may have been added but did not return"
                    return false
            }
            catch(java.sql.SQLWarning w) 
            { 
                    String mess = w.getMessage(); 
                    String state = w.getSQLState(); 
                    msg = "SQLWarnings - insert failed : State:"+state+" : "+mess say msg return false 
            }
            catch (SQLException x)
            {
                msg = "SQLException - cannot add data "
                while (x != null)
                {
                    String mess = x.getMessage();
                    String state = x.getSQLState();
                    msg += "message:SQL failure:${mess} Sqlstate is ${state}"
                    x = x.getNextException();
                }
                say msg
                return false
                //x.printStackTrace();
            }
            catch(Exception e) {
                say "bad news !!!!"
                e.printStackTrace();
                return false;
        }   // end of sql access

Ok, forgot to suggest that if you are looking for a particular sql state code, it is easier to use your browser’s search facility to hunt down that code. On apple mac’s i use the apple key+F and on windows try the CTRL+F key combo. to open a search.

STATE Sub Category SEVERITY Further Info.
01001 Connectivity SYSTEM_SEVERITY CURSOR_OPERATION_CONFLICT
01003 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_NULL_ELIMINATED_IN_SET_FUNCTION
01006 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_PRIVILEGE_NOT_REVOKED
01007 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_ROLE_NOT_REVOKED
01008 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_WITH_ADMIN_OPTION_NOT_REVOKED
01009 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_GEN_COL_DROPPED
0100E LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_TOO_MANY_DYNAMIC_RESULTS_RETURNED
01500 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_CONSTRAINT_DROPPED
01501 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_VIEW_DROPPED
01502 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_TRIGGER_DROPPED
01503 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_COL_NOT_NULL
01504 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_INDEX_DUPLICATE
01505 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_VALUE_TRUNCATED
01522 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_SYNONYM_UNDEFINED
01J01 Connectivity SYSTEM_SEVERITY DATABASE_EXISTS
01J02 Connectivity SYSTEM_SEVERITY NO_SCROLL_SENSITIVE_CURSORS
01J04 Connectivity SYSTEM_SEVERITY LANG_TYPE_NOT_SERIALIZABLE
01J05 Connectivity SYSTEM_SEVERITY UPGRADE_SPSRECOMPILEFAILED
01J06 Connectivity SYSTEM_SEVERITY QUERY_NOT_QUALIFIED_FOR_UPDATABLE_RESULTSET
01J07 Connectivity SYSTEM_SEVERITY HOLDABLE_RESULT_SET_NOT_AVAILABLE
01J08 Connectivity SYSTEM_SEVERITY INVALID_RESULTSET_TYPE
01J10 Connectivity SYSTEM_SEVERITY SCROLL_SENSITIVE_NOT_SUPPORTED
01J12 Connectivity SYSTEM_SEVERITY UNABLE_TO_OBTAIN_MESSAGE_TEXT_FROM_SERVER
01J13 Connectivity SYSTEM_SEVERITY NUMBER_OF_ROWS_TOO_LARGE_FOR_INT
01J14 Connectivity SYSTEM_SEVERITY SQL_AUTHORIZATION_WITH_NO_AUTHENTICATION
02000 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_NO_ROW_FOUND
02502 Connectivity STATEMENT_SEVERITY ROW_DELETED
07000 SQL Data exceptions STATEMENT_SEVERITY LANG_MISSING_PARMS
07004 Connectivity STATEMENT_SEVERITY NEED_TO_REGISTER_PARAM
07009 Connectivity STATEMENT_SEVERITY NO_INPUT_PARAMETERS
08 Connectivity – Connection Exceptions: 08XXX STATEMENT_SEVERITY CONNECTIVITY_PREFIX
08000 ContextService DATABASE_SEVERITY CONN_INTERRUPT
08001 C.1 Connectivity SESSION_SEVERITY CONNECT_REQUIRED_PROPERTY_NOT_SET
08001 C.2 Connectivity SESSION_SEVERITY CONNECT_UNABLE_TO_CONNECT_TO_SERVER
08001 C.3 Connectivity SESSION_SEVERITY CONNECT_SOCKET_EXCEPTION
08001 C.4 Connectivity SESSION_SEVERITY CONNECT_UNABLE_TO_OPEN_SOCKET_STREAM
08001 C.5 Connectivity SESSION_SEVERITY CONNECT_USERID_LENGTH_OUT_OF_RANGE
08001 C.6 Connectivity SESSION_SEVERITY CONNECT_PASSWORD_LENGTH_OUT_OF_RANGE
08001 C.7 Connectivity SESSION_SEVERITY CONNECT_USERID_ISNULL
08001 C.8 Connectivity SESSION_SEVERITY CONNECT_PASSWORD_ISNULL
08001 C.9 Connectivity SESSION_SEVERITY NET_DBNAME_TOO_LONG
08001 C.10 Connectivity SESSION_SEVERITY NET_SECTKN_TOO_LONG
08001 C.11 Connectivity SESSION_SEVERITY NET_USERID_TOO_LONG
08001 C.12 Connectivity SESSION_SEVERITY NET_PASSWORD_TOO_LONG
08001 C.13 Connectivity SESSION_SEVERITY NET_EXTNAM_TOO_LONG
08001 C.14 Connectivity SESSION_SEVERITY NET_SRVNAM_TOO_LONG
08003 Connectivity SESSION_SEVERITY NO_CURRENT_CONNECTION
08003 C.1 Connectivity SESSION_SEVERITY NOGETCONN_ON_CLOSED_POOLED_CONNECTION
08003 C.2 Connectivity SESSION_SEVERITY LOB_METHOD_ON_CLOSED_CONNECTION
08003 C.3 Connectivity SESSION_SEVERITY PHYSICAL_CONNECTION_ALREADY_CLOSED
08004 Connectivity SESSION_SEVERITY LOGIN_FAILED
08004 C.1 Connectivity SESSION_SEVERITY NET_CONNECT_AUTH_FAILED
08004 C.2 Connectivity SESSION_SEVERITY NET_DATABASE_NOT_FOUND
08004 C.3 Connectivity SESSION_SEVERITY AUTH_DATABASE_CONNECTION_REFUSED
08004 C.4 Connectivity SESSION_SEVERITY AUTH_SHUTDOWN_NOT_DB_OWNER
08004 C.5 Connectivity SESSION_SEVERITY AUTH_ENCRYPT_NOT_DB_OWNER
08004 C.6 Connectivity SESSION_SEVERITY AUTH_HARD_UPGRADE_NOT_DB_OWNER
08004 C.7 Connectivity SESSION_SEVERITY CANNOT_CONNECT_TO_DB_IN_SLAVE_MODE
08004 C.8 Connectivity SESSION_SEVERITY AUTH_REPLICATION_NOT_DB_OWNER
08004 C.9 Connectivity SESSION_SEVERITY AUTH_SHUTDOWN_MISSING_PERMISSION
08004 C.10 Connectivity SESSION_SEVERITY AUTH_DATABASE_CREATE_EXCEPTION
08004 C.11 Connectivity SESSION_SEVERITY AUTH_DATABASE_CREATE_MISSING_PERMISSION
08004 C.12 Connectivity SESSION_SEVERITY NET_CONNECT_SECMEC_INCOMPATIBLE_SCHEME
08006 C Connectivity SESSION_SEVERITY DRDA_CONNECTION_TERMINATED
08006 C.1 Connectivity SESSION_SEVERITY CONNECTION_FAILED_ON_RESET
08006 C.2 Connectivity SESSION_SEVERITY SOCKET_EXCEPTION
08006 C.3 Connectivity SESSION_SEVERITY COMMUNICATION_ERROR
08006 C.4 Connectivity SESSION_SEVERITY CONNECTION_FAILED_ON_DEFERRED_RESET
08006 C.5 Connectivity SESSION_SEVERITY NET_INSUFFICIENT_DATA
08006 C.6 Connectivity SESSION_SEVERITY NET_LOB_DATA_TOO_LARGE_FOR_JVM
08006 D Connectivity DATABASE_SEVERITY SHUTDOWN_DATABASE
08006 D.1 Connectivity DATABASE_SEVERITY DROP_DATABASE
0A SQL standard 0A – feature not supported STATEMENT_SEVERITY UNSUPPORTED_PREFIX
0A000 S SQL standard 0A – feature not supported STATEMENT_SEVERITY NOT_IMPLEMENTED
0A000 S.1 SQL standard 0A – feature not supported STATEMENT_SEVERITY JDBC_METHOD_NOT_IMPLEMENTED
0A000 S.2 SQL standard 0A – feature not supported STATEMENT_SEVERITY JDBC_METHOD_NOT_SUPPORTED_BY_SERVER
0A000 S.3 SQL standard 0A – feature not supported STATEMENT_SEVERITY UNSUPPORTED_HOLDABILITY_PROPERTY
0A000 S.4 SQL standard 0A – feature not supported STATEMENT_SEVERITY CANCEL_NOT_SUPPORTED_BY_SERVER
0A000 S.5 SQL standard 0A – feature not supported STATEMENT_SEVERITY SECMECH_NOT_SUPPORTED
0A000 C.6 SQL standard 0A – feature not supported SESSION_SEVERITY DRDA_COMMAND_NOT_IMPLEMENTED
0A000 S.7 SQL standard 0A – feature not supported STATEMENT_SEVERITY DATA_TYPE_NOT_SUPPORTED
0P000 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY ROLE_INVALID_SPECIFICATION
0P000 S.1 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY ROLE_INVALID_SPECIFICATION_NOT_GRANTED
10000 Integrity violations. STATEMENT_SEVERITY LANG_XML_QUERY_ERROR
21000 SQL Data exceptions STATEMENT_SEVERITY LANG_SCALAR_SUBQUERY_CARDINALITY_VIOLATION
22 SQL Data exceptions STATEMENT_SEVERITY SQL_DATA_PREFIX
22001 SQL Data exceptions STATEMENT_SEVERITY LANG_STRING_TRUNCATION
22003 SQL Data exceptions STATEMENT_SEVERITY LANG_OUTSIDE_RANGE_FOR_DATATYPE
22003 S.1 SQL Data exceptions STATEMENT_SEVERITY YEAR_EXCEEDS_MAXIMUM
22003 S.2 SQL Data exceptions STATEMENT_SEVERITY DECIMAL_TOO_MANY_DIGITS
22003 S.3 SQL Data exceptions STATEMENT_SEVERITY NUMERIC_OVERFLOW
22003 S.4 SQL Data exceptions STATEMENT_SEVERITY CLIENT_LENGTH_OUTSIDE_RANGE_FOR_DATATYPE
22005 SQL Data exceptions STATEMENT_SEVERITY LANG_DATA_TYPE_GET_MISMATCH
22005 S.1 SQL Data exceptions STATEMENT_SEVERITY UNSUPPORTED_ENCODING
22005 S.2 SQL Data exceptions STATEMENT_SEVERITY CHARACTER_CONVERTER_NOT_AVAILABLE
22005 S.3 SQL Data exceptions STATEMENT_SEVERITY CANT_CONVERT_UNICODE_TO_EBCDIC
22005 S.4 SQL Data exceptions STATEMENT_SEVERITY NET_UNRECOGNIZED_JDBC_TYPE
22005 S.5 SQL Data exceptions STATEMENT_SEVERITY NET_INVALID_JDBC_TYPE_FOR_PARAM
22005 S.6 SQL Data exceptions STATEMENT_SEVERITY UNRECOGNIZED_JAVA_SQL_TYPE
22005 S.7 SQL Data exceptions STATEMENT_SEVERITY CANT_CONVERT_UNICODE_TO_UTF8
22007 S.180 SQL Data exceptions STATEMENT_SEVERITY LANG_DATE_RANGE_EXCEPTION
22007 S.181 SQL Data exceptions STATEMENT_SEVERITY LANG_DATE_SYNTAX_EXCEPTION
22008 S SQL Data exceptions STATEMENT_SEVERITY LANG_INVALID_FUNCTION_ARGUMENT
2200H S SQL Data exceptions STATEMENT_SEVERITY LANG_SEQUENCE_GENERATOR_EXHAUSTED
2200L Integrity violations. STATEMENT_SEVERITY LANG_NOT_AN_XML_DOCUMENT
2200M Integrity violations. STATEMENT_SEVERITY LANG_INVALID_XML_DOCUMENT
2200V Integrity violations. STATEMENT_SEVERITY LANG_INVALID_XML_CONTEXT_ITEM
2200W Integrity violations. STATEMENT_SEVERITY LANG_XQUERY_SERIALIZATION_ERROR
22011 SQL Data exceptions STATEMENT_SEVERITY LANG_SUBSTR_START_OR_LEN_OUT_OF_RANGE
22011 S.1 SQL Data exceptions STATEMENT_SEVERITY LANG_SUBSTR_START_ADDING_LEN_OUT_OF_RANGE
22012 SQL Data exceptions STATEMENT_SEVERITY LANG_DIVIDE_BY_ZERO
22013 SQL Data exceptions STATEMENT_SEVERITY LANG_SQRT_OF_NEG_NUMBER
22014 SQL Data exceptions STATEMENT_SEVERITY LANG_INVALID_PARAMETER_FOR_SEARCH_POSITION
22015 SQL Data exceptions STATEMENT_SEVERITY LANG_INVALID_TYPE_FOR_LOCATE_FUNCTION
22015 S.1 SQL Data exceptions STATEMENT_SEVERITY LOSS_OF_PRECISION_EXCEPTION
22018 SQL Data exceptions STATEMENT_SEVERITY LANG_FORMAT_EXCEPTION
22019 SQL Data exceptions STATEMENT_SEVERITY LANG_INVALID_ESCAPE_CHARACTER
2201W SQL Data exceptions STATEMENT_SEVERITY LANG_INVALID_ROW_COUNT_FIRST
2201X SQL Data exceptions STATEMENT_SEVERITY LANG_INVALID_ROW_COUNT_OFFSET
2201Z SQL Data exceptions STATEMENT_SEVERITY LANG_ROW_COUNT_OFFSET_FIRST_IS_NULL
22020 SQL Data exceptions STATEMENT_SEVERITY LANG_INVALID_TRIM_CHARACTER
22025 SQL Data exceptions STATEMENT_SEVERITY LANG_INVALID_ESCAPE_SEQUENCE
22027 SQL Data exceptions STATEMENT_SEVERITY LANG_INVALID_TRIM_SET
22028 SQL Data exceptions STATEMENT_SEVERITY LANG_STRING_TOO_LONG
22501 SQL Data exceptions STATEMENT_SEVERITY LANG_ESCAPE_IS_NULL
23 Integrity violations. STATEMENT_SEVERITY INTEGRITY_VIOLATION_PREFIX
23502 Integrity violations. STATEMENT_SEVERITY LANG_NULL_INTO_NON_NULL
23503 Integrity violations. STATEMENT_SEVERITY LANG_FK_VIOLATION
23505 Integrity violations. STATEMENT_SEVERITY LANG_DUPLICATE_KEY_CONSTRAINT
23513 Integrity violations. STATEMENT_SEVERITY LANG_CHECK_CONSTRAINT_VIOLATED
24000 Connectivity STATEMENT_SEVERITY NO_CURRENT_ROW
24501 S Messages whose SQL states are prescribed by DRDA STATEMENT_SEVERITY DRDA_CURSOR_NOT_OPEN
25001 Integrity violations. STATEMENT_SEVERITY CANNOT_CLOSE_ACTIVE_CONNECTION
25001 S.1 Integrity violations. STATEMENT_SEVERITY INVALID_TRANSACTION_STATE_ACTIVE_CONNECTION
25501 Authorization and Authentication STATEMENT_SEVERITY AUTH_SET_CONNECTION_READ_ONLY_IN_ACTIVE_XACT
25502 Authorization and Authentication STATEMENT_SEVERITY AUTH_WRITE_WITH_READ_ONLY_CONNECTION
25503 Authorization and Authentication STATEMENT_SEVERITY AUTH_DDL_WITH_READ_ONLY_CONNECTION
25505 Authorization and Authentication STATEMENT_SEVERITY AUTH_CANNOT_SET_READ_WRITE
28 Authorization and Authentication STATEMENT_SEVERITY AUTHORIZATION_SPEC_PREFIX
28502 Authorization and Authentication STATEMENT_SEVERITY AUTH_INVALID_USER_NAME
2D521 S.1 Messages whose SQL states are prescribed by DRDA STATEMENT_SEVERITY DRDA_NO_AUTOCOMMIT_UNDER_XA
2D521 S.2 Messages whose SQL states are prescribed by DRDA STATEMENT_SEVERITY DRDA_INVALID_XA_STATE_ON_COMMIT_OR_ROLLBACK
38000 Integrity violations. STATEMENT_SEVERITY LANG_UNEXPECTED_USER_EXCEPTION
38001 Integrity violations. STATEMENT_SEVERITY EXTERNAL_ROUTINE_NO_SQL
38002 Integrity violations. STATEMENT_SEVERITY EXTERNAL_ROUTINE_NO_MODIFIES_SQL
38004 Integrity violations. STATEMENT_SEVERITY EXTERNAL_ROUTINE_NO_READS_SQL
39004 Integrity violations. STATEMENT_SEVERITY LANG_NULL_TO_PRIMITIVE_PARAMETER
3B001 S RawStore – Transactions.Basic statement exceptions STATEMENT_SEVERITY XACT_SAVEPOINT_NOT_FOUND
3B002 S RawStore – Transactions.Basic statement exceptions STATEMENT_SEVERITY XACT_MAX_SAVEPOINT_LEVEL_REACHED
3B501 S RawStore – Transactions.Basic statement exceptions STATEMENT_SEVERITY XACT_SAVEPOINT_EXISTS
3B502 S RawStore – Transactions.Basic statement exceptions STATEMENT_SEVERITY XACT_SAVEPOINT_RELEASE_ROLLBACK_FAIL
40 RawStore – Transactions.Basic transaction exceptions STATEMENT_SEVERITY TRANSACTION_PREFIX
40001 LockManager STATEMENT_SEVERITY DEADLOCK
40XC0 LanguageThe entries in this file are sorted into groups. A STATEMENT_SEVERITY LANG_DEAD_STATEMENT
40XD0 InternalUtil – IO Errors(Range XCXD0-XCXDZ)InternalUtil – L STATEMENT_SEVERITY DATA_CONTAINER_CLOSED
40XD1 InternalUtil – IO Errors(Range XCXD0-XCXDZ)InternalUtil – L STATEMENT_SEVERITY DATA_CONTAINER_READ_ONLY
40XD2 InternalUtil – IO Errors(Range XCXD0-XCXDZ)InternalUtil – L STATEMENT_SEVERITY DATA_CONTAINER_VANISHED
40XL1 LockManager STATEMENT_SEVERITY LOCK_TIMEOUT
40XL2 LockManager STATEMENT_SEVERITY LOCK_TIMEOUT_LOG
40XT0 RawStore – Transactions.Basic transaction exceptions STATEMENT_SEVERITY XACT_PROTOCOL_VIOLATION
40XT1 RawStore – Transactions.Basic transaction exceptions STATEMENT_SEVERITY XACT_COMMIT_EXCEPTION
40XT2 RawStore – Transactions.Basic transaction exceptions STATEMENT_SEVERITY XACT_ROLLBACK_EXCEPTION
40XT4 RawStore – Transactions.Basic transaction exceptions STATEMENT_SEVERITY XACT_TRANSACTION_NOT_IDLE
40XT5 RawStore – Transactions.Basic transaction exceptions STATEMENT_SEVERITY XACT_INTERNAL_TRANSACTION_EXCEPTION
40XT6 RawStore – Transactions.Basic transaction exceptions STATEMENT_SEVERITY XACT_CANNOT_ACTIVATE_TRANSACTION
40XT7 RawStore – Transactions.Basic transaction exceptions STATEMENT_SEVERITY XACT_NOT_SUPPORTED_IN_INTERNAL_XACT
42 LanguageLanguage Statement Exception STATEMENT_SEVERITY LSE_COMPILATION_PREFIX
42000 Integrity violations. STATEMENT_SEVERITY LANG_SYNTAX_OR_ACCESS_VIOLATION
42500 Integrity violations. STATEMENT_SEVERITY AUTH_NO_TABLE_PERMISSION
42501 Integrity violations. STATEMENT_SEVERITY AUTH_NO_TABLE_PERMISSION_FOR_GRANT
42502 Integrity violations. STATEMENT_SEVERITY AUTH_NO_COLUMN_PERMISSION
42503 Integrity violations. STATEMENT_SEVERITY AUTH_NO_COLUMN_PERMISSION_FOR_GRANT
42504 Integrity violations. STATEMENT_SEVERITY AUTH_NO_GENERIC_PERMISSION
42505 Integrity violations. STATEMENT_SEVERITY AUTH_NO_GENERIC_PERMISSION_FOR_GRANT
42506 Integrity violations. STATEMENT_SEVERITY AUTH_NOT_OWNER
42507 Integrity violations. STATEMENT_SEVERITY AUTH_NO_ACCESS_NOT_OWNER
42508 Integrity violations. STATEMENT_SEVERITY AUTH_NOT_DATABASE_OWNER
42509 Integrity violations. STATEMENT_SEVERITY AUTH_GRANT_REVOKE_NOT_ALLOWED
4250A Integrity violations. STATEMENT_SEVERITY AUTH_NO_OBJECT_PERMISSION
4250B Integrity violations. STATEMENT_SEVERITY AUTH_INVALID_AUTHORIZATION_PROPERTY
4250C Integrity violations. STATEMENT_SEVERITY AUTH_USER_IN_READ_AND_WRITE_LISTS
4250D Integrity violations. STATEMENT_SEVERITY AUTH_DUPLICATE_USERS
4250E Integrity violations. STATEMENT_SEVERITY AUTH_INTERNAL_BAD_UUID
4251A Integrity violations. STATEMENT_SEVERITY AUTH_ROLE_DBO_ONLY
4251B Integrity violations. STATEMENT_SEVERITY AUTH_PUBLIC_ILLEGAL_AUTHORIZATION_ID
4251C Integrity violations. STATEMENT_SEVERITY AUTH_ROLE_GRANT_CIRCULARITY
42601 Integrity violations. STATEMENT_SEVERITY LANG_DB2_NOT_NULL_COLUMN_INVALID_DEFAULT
42601 S.372 Integrity violations. STATEMENT_SEVERITY LANG_ALTER_TABLE_AUTOINCREMENT_COLUMN_NOT_ALLOWED
42605 Integrity violations. STATEMENT_SEVERITY LANG_DB2_NUMBER_OF_ARGS_INVALID
42606 Integrity violations. STATEMENT_SEVERITY LANG_DB2_INVALID_HEXADECIMAL_CONSTANT
42610 Integrity violations. STATEMENT_SEVERITY LANG_DB2_COALESCE_FUNCTION_ALL_PARAMS
42611 Integrity violations. STATEMENT_SEVERITY LANG_DB2_LENGTH_PRECISION_SCALE_VIOLATION
42613 Integrity violations. STATEMENT_SEVERITY LANG_DB2_MULTIPLE_ELEMENTS
42621 Integrity violations. STATEMENT_SEVERITY LANG_DB2_INVALID_CHECK_CONSTRAINT
42622 Integrity violations. STATEMENT_SEVERITY LANG_IDENTIFIER_TOO_LONG
42734 Integrity violations. STATEMENT_SEVERITY LANG_DB2_DUPLICATE_NAMES
42802 Integrity violations. STATEMENT_SEVERITY LANG_DB2_INVALID_COLS_SPECIFIED
42803 Integrity violations. STATEMENT_SEVERITY LANG_DB2_INVALID_SELECT_COL_FOR_HAVING
42815 S.713 Integrity violations. STATEMENT_SEVERITY LANG_DB2_REPLACEMENT_ERROR
42815 S.171 Integrity violations. STATEMENT_SEVERITY LANG_DB2_COALESCE_DATATYPE_MISMATCH
42818 Integrity violations. STATEMENT_SEVERITY LANG_NOT_COMPARABLE
42820 Integrity violations. STATEMENT_SEVERITY LANG_DB2_TOO_LONG_FLOATING_POINT_LITERAL
42821 Integrity violations. STATEMENT_SEVERITY LANG_NOT_STORABLE
42824 Integrity violations. STATEMENT_SEVERITY LANG_DB2_LIKE_SYNTAX_ERROR
42831 Integrity violations. STATEMENT_SEVERITY LANG_DB2_ADD_UNIQUE_OR_PRIMARY_KEY_ON_NULL_COLS
42831 S.1 Integrity violations. STATEMENT_SEVERITY LANG_ADD_PRIMARY_KEY_ON_NULL_COLS
42834 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_FK_COL_FOR_SETNULL
42837 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_ALTER_TABLE_ATTRIBUTES
42846 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_CAST
42877 Integrity violations. STATEMENT_SEVERITY LANG_QUALIFIED_COLUMN_NAME_NOT_ALLOWED
42878 Integrity violations. STATEMENT_SEVERITY LANG_UNION_ORDER_BY
42879 Integrity violations. STATEMENT_SEVERITY LANG_DISTINCT_ORDER_BY
4287A Integrity violations. STATEMENT_SEVERITY LANG_DISTINCT_ORDER_BY_EXPRESSION
42884 Integrity violations. STATEMENT_SEVERITY LANG_DB2_FUNCTION_INCOMPATIBLE
42886 Integrity violations. STATEMENT_SEVERITY LANG_DB2_PARAMETER_NEEDS_MARKER
42894 Integrity violations. STATEMENT_SEVERITY LANG_DB2_INVALID_DEFAULT_VALUE
428C1 Integrity violations. STATEMENT_SEVERITY LANG_MULTIPLE_AUTOINCREMENT_COLUMNS
428EK Integrity violations. STATEMENT_SEVERITY LANG_DECLARED_GLOBAL_TEMP_TABLE_ONLY_IN_SESSION_SCHEMA
42903 Integrity violations. STATEMENT_SEVERITY LANG_NO_AGGREGATES_IN_WHERE_CLAUSE
42908 Integrity violations. STATEMENT_SEVERITY LANG_DB2_VIEW_REQUIRES_COLUMN_NAMES
42909 Integrity violations. STATEMENT_SEVERITY LANG_TABLE_REQUIRES_COLUMN_NAMES
42915 Integrity violations. STATEMENT_SEVERITY LANG_DELETE_RULE_VIOLATION
42916 Integrity violations. STATEMENT_SEVERITY LANG_SYNONYM_CIRCULAR
42939 Language errors that match DB2 STATEMENT_SEVERITY INVALID_SCHEMA_SYS
4293A Modelled on INVALID_SCHEMA_SYS, although not from DB2 STATEMENT_SEVERITY INVALID_ROLE_SYS
42962 Integrity violations. STATEMENT_SEVERITY LANG_LONG_DATA_TYPE_NOT_ALLOWED
42995 Integrity violations. STATEMENT_SEVERITY LANG_NOT_ALLOWED_FOR_DECLARED_GLOBAL_TEMP_TABLE
42X01 Integrity violations. STATEMENT_SEVERITY LANG_SYNTAX_ERROR
42X02 Integrity violations. STATEMENT_SEVERITY LANG_LEXICAL_ERROR
42X03 Integrity violations. STATEMENT_SEVERITY LANG_AMBIGUOUS_COLUMN_NAME
42X04 Integrity violations. STATEMENT_SEVERITY LANG_COLUMN_NOT_FOUND
42X05 Integrity violations. STATEMENT_SEVERITY LANG_TABLE_NOT_FOUND
42X06 Integrity violations. STATEMENT_SEVERITY LANG_TOO_MANY_RESULT_COLUMNS
42X07 Integrity violations. STATEMENT_SEVERITY LANG_NULL_IN_VALUES_CLAUSE
42X08 Integrity violations. STATEMENT_SEVERITY LANG_DOES_NOT_IMPLEMENT
42X09 Integrity violations. STATEMENT_SEVERITY LANG_FROM_LIST_DUPLICATE_TABLE_NAME
42X10 Integrity violations. STATEMENT_SEVERITY LANG_EXPOSED_NAME_NOT_FOUND
42X12 Integrity violations. STATEMENT_SEVERITY LANG_DUPLICATE_COLUMN_NAME_CREATE
42X13 Integrity violations. STATEMENT_SEVERITY LANG_DUPLICATE_COLUMN_NAME_INSERT
42X14 Integrity violations. STATEMENT_SEVERITY LANG_COLUMN_NOT_FOUND_IN_TABLE
42X15 Integrity violations. STATEMENT_SEVERITY LANG_ILLEGAL_COLUMN_REFERENCE
42X16 Integrity violations. STATEMENT_SEVERITY LANG_DUPLICATE_COLUMN_NAME_UPDATE
42X17 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_JOIN_ORDER_SPEC
42X19 Integrity violations. STATEMENT_SEVERITY LANG_NON_BOOLEAN_WHERE_CLAUSE
42X20 Integrity violations. STATEMENT_SEVERITY LANG_INTEGER_LITERAL_EXPECTED
42X23 Integrity violations. STATEMENT_SEVERITY LANG_CURSOR_NOT_UPDATABLE
42X24 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_COL_HAVING_CLAUSE
42X25 Integrity violations. STATEMENT_SEVERITY LANG_UNARY_FUNCTION_BAD_TYPE
42X26 Integrity violations. STATEMENT_SEVERITY LANG_TYPE_DOESNT_EXIST
42X28 Integrity violations. STATEMENT_SEVERITY LANG_CURSOR_DELETE_MISMATCH
42X29 Integrity violations. STATEMENT_SEVERITY LANG_CURSOR_UPDATE_MISMATCH
42X30 Integrity violations. STATEMENT_SEVERITY LANG_CURSOR_NOT_FOUND
42X31 Integrity violations. STATEMENT_SEVERITY LANG_COLUMN_NOT_UPDATABLE_IN_CURSOR
42X32 Integrity violations. STATEMENT_SEVERITY LANG_DERIVED_COLUMN_LIST_MISMATCH
42X33 Integrity violations. STATEMENT_SEVERITY LANG_DUPLICATE_COLUMN_NAME_DERIVED
42X34 Integrity violations. STATEMENT_SEVERITY LANG_PARAM_IN_SELECT_LIST
42X35 Integrity violations. STATEMENT_SEVERITY LANG_BINARY_OPERANDS_BOTH_PARMS
42X36 Integrity violations. STATEMENT_SEVERITY LANG_UNARY_OPERAND_PARM
42X37 Integrity violations. STATEMENT_SEVERITY LANG_UNARY_ARITHMETIC_BAD_TYPE
42X38 Integrity violations. STATEMENT_SEVERITY LANG_CANT_SELECT_STAR_SUBQUERY
42X39 Integrity violations. STATEMENT_SEVERITY LANG_NON_SINGLE_COLUMN_SUBQUERY
42X40 Integrity violations. STATEMENT_SEVERITY LANG_UNARY_LOGICAL_NON_BOOLEAN
42X41 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_FROM_LIST_PROPERTY
42X42 Integrity violations. STATEMENT_SEVERITY LANG_CORRELATION_NAME_FOR_UPDATABLE_COLUMN_DISALLOWED_IN_CURSOR
42X43 Integrity violations. STATEMENT_SEVERITY LANG_NULL_RESULT_SET_META_DATA
42X44 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_COLUMN_LENGTH
42X45 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_FUNCTION_ARG_TYPE
42X46 Integrity violations. STATEMENT_SEVERITY LANG_AMBIGUOUS_FUNCTION_NAME
42X47 Integrity violations. STATEMENT_SEVERITY LANG_AMBIGUOUS_PROCEDURE_NAME
42X48 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_PRECISION
42X49 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_INTEGER_LITERAL
42X50 Integrity violations. STATEMENT_SEVERITY LANG_NO_METHOD_FOUND
42X51 Integrity violations. STATEMENT_SEVERITY LANG_TYPE_DOESNT_EXIST2
42X52 Integrity violations. STATEMENT_SEVERITY LANG_PRIMITIVE_RECEIVER
42X53 Integrity violations. STATEMENT_SEVERITY LANG_LIKE_BAD_TYPE
42X54 Integrity violations. STATEMENT_SEVERITY LANG_PARAMETER_RECEIVER
42X55 Integrity violations. STATEMENT_SEVERITY LANG_TABLE_NAME_MISMATCH
42X56 Integrity violations. STATEMENT_SEVERITY LANG_VIEW_DEFINITION_R_C_L_MISMATCH
42X57 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_V_T_I_COLUMN_COUNT
42X58 Integrity violations. STATEMENT_SEVERITY LANG_UNION_UNMATCHED_COLUMNS
42X59 Integrity violations. STATEMENT_SEVERITY LANG_ROW_VALUE_CONSTRUCTOR_UNMATCHED_COLUMNS
42X60 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_INSERT_MODE
42X61 Integrity violations. STATEMENT_SEVERITY LANG_NOT_UNION_COMPATIBLE
42X62 Integrity violations. STATEMENT_SEVERITY LANG_NO_USER_DDL_IN_SYSTEM_SCHEMA
42X63 Integrity violations. STATEMENT_SEVERITY LANG_NO_ROWS_FROM_USING
42X64 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_STATISTICS_SPEC
42X65 Integrity violations. STATEMENT_SEVERITY LANG_INDEX_NOT_FOUND
42X66 Integrity violations. STATEMENT_SEVERITY LANG_DUPLICATE_COLUMN_NAME_CREATE_INDEX
42X68 Integrity violations. STATEMENT_SEVERITY LANG_NO_FIELD_FOUND
42X69 Integrity violations. STATEMENT_SEVERITY LANG_PRIMITIVE_REFERENCING_EXPRESSION
42X70 Integrity violations. STATEMENT_SEVERITY LANG_TABLE_DEFINITION_R_C_L_MISMATCH
42X71 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_COLUMN_TYPE_CREATE_TABLE
42X72 Integrity violations. STATEMENT_SEVERITY LANG_NO_STATIC_FIELD_FOUND
42X73 Integrity violations. STATEMENT_SEVERITY LANG_AMBIGUOUS_METHOD_INVOCATION
42X74 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_CALL_STATEMENT
42X75 Integrity violations. STATEMENT_SEVERITY LANG_NO_CONSTRUCTOR_FOUND
42X76 Integrity violations. STATEMENT_SEVERITY LANG_ADDING_PRIMARY_KEY_ON_EXPLICIT_NULLABLE_COLUMN
42X77 Integrity violations. STATEMENT_SEVERITY LANG_COLUMN_OUT_OF_RANGE
42X78 Integrity violations. STATEMENT_SEVERITY LANG_ORDER_BY_COLUMN_NOT_FOUND
42X79 Integrity violations. STATEMENT_SEVERITY LANG_DUPLICATE_COLUMN_FOR_ORDER_BY
42X80 Integrity violations. STATEMENT_SEVERITY LANG_EMPTY_VALUES_CLAUSE
42X81 Integrity violations. STATEMENT_SEVERITY LANG_EMPTY_COLUMN_LIST
42X82 Integrity violations. STATEMENT_SEVERITY LANG_USING_CARDINALITY_VIOLATION
42X83 Integrity violations. STATEMENT_SEVERITY LANG_ADDING_COLUMN_WITH_NULL_AND_NOT_NULL_CONSTRAINT
42X84 Integrity violations. STATEMENT_SEVERITY LANG_CANT_DROP_BACKING_INDEX
42X85 Integrity violations. STATEMENT_SEVERITY LANG_CONSTRAINT_SCHEMA_MISMATCH
42X86 Integrity violations. STATEMENT_SEVERITY LANG_DROP_NON_EXISTENT_CONSTRAINT
42X87 Integrity violations. STATEMENT_SEVERITY LANG_ALL_RESULT_EXPRESSIONS_PARAMS
42X88 Integrity violations. STATEMENT_SEVERITY LANG_CONDITIONAL_NON_BOOLEAN
42X89 Integrity violations. STATEMENT_SEVERITY LANG_NOT_TYPE_COMPATIBLE
42X90 Integrity violations. STATEMENT_SEVERITY LANG_TOO_MANY_PRIMARY_KEY_CONSTRAINTS
42X91 Integrity violations. STATEMENT_SEVERITY LANG_DUPLICATE_CONSTRAINT_NAME_CREATE
42X92 Integrity violations. STATEMENT_SEVERITY LANG_DUPLICATE_CONSTRAINT_COLUMN_NAME
42X93 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_CREATE_CONSTRAINT_COLUMN_LIST
42X94 Integrity violations. STATEMENT_SEVERITY LANG_OBJECT_NOT_FOUND
42X96 Integrity violations. STATEMENT_SEVERITY LANG_DB_CLASS_PATH_HAS_MISSING_JAR
42X98 Integrity violations. STATEMENT_SEVERITY LANG_NO_PARAMS_IN_VIEWS
42X99 Integrity violations. STATEMENT_SEVERITY LANG_NO_PARAMS_IN_TABLES
42XA0 Integrity violations. STATEMENT_SEVERITY LANG_UNASSIGNABLE_GENERATION_CLAUSE
42XA1 Integrity violations. STATEMENT_SEVERITY LANG_AGGREGATE_IN_GENERATION_CLAUSE
42XA2 Integrity violations. STATEMENT_SEVERITY LANG_NON_DETERMINISTIC_GENERATION_CLAUSE
42XA3 Integrity violations. STATEMENT_SEVERITY LANG_CANT_OVERRIDE_GENERATION_CLAUSE
42XA4 Integrity violations. STATEMENT_SEVERITY LANG_CANT_REFERENCE_GENERATED_COLUMN
42XA5 Integrity violations. STATEMENT_SEVERITY LANG_ROUTINE_CANT_PERMIT_SQL
42XA6 Integrity violations. STATEMENT_SEVERITY LANG_BAD_FK_ON_GENERATED_COLUMN
42XA7 Integrity violations. STATEMENT_SEVERITY LANG_GEN_COL_DEFAULT
42XA8 Integrity violations. STATEMENT_SEVERITY LANG_GEN_COL_BAD_RENAME
42XA9 Integrity violations. STATEMENT_SEVERITY LANG_NEEDS_DATATYPE
42XAA Integrity violations. STATEMENT_SEVERITY LANG_GEN_COL_BEFORE_TRIG
42XAB Integrity violations. STATEMENT_SEVERITY LANG_NOT_NULL_NEEDS_DATATYPE
42XAC Integrity violations. STATEMENT_SEVERITY LANG_SEQ_INCREMENT_ZERO
42XAE Integrity violations. STATEMENT_SEVERITY LANG_SEQ_ARG_OUT_OF_DATATYPE_RANGE
42XAF Integrity violations. STATEMENT_SEVERITY LANG_SEQ_MIN_EXCEEDS_MAX
42XAG Integrity violations. STATEMENT_SEVERITY LANG_SEQ_INVALID_START
42XAH Integrity violations. STATEMENT_SEVERITY LANG_NEXT_VALUE_FOR_ILLEGAL
42XAI Integrity violations. STATEMENT_SEVERITY LANG_SEQUENCE_REFERENCED_TWICE
42XAJ Integrity violations. STATEMENT_SEVERITY LANG_DUPLICATE_CS_CLAUSE
42Y00 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_USER_AGGREGATE_DEFINITION2
42Y01 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_CHECK_CONSTRAINT
42Y03 S.0 Integrity violations. STATEMENT_SEVERITY LANG_NO_SUCH_METHOD_ALIAS
42Y03 S.1 Integrity violations. STATEMENT_SEVERITY LANG_NO_SUCH_PROCEDURE
42Y03 S.2 Integrity violations. STATEMENT_SEVERITY LANG_NO_SUCH_FUNCTION
42Y04 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_FULL_STATIC_METHOD_NAME
42Y05 Integrity violations. STATEMENT_SEVERITY LANG_NO_SUCH_FOREIGN_KEY
42Y07 Integrity violations. STATEMENT_SEVERITY LANG_SCHEMA_DOES_NOT_EXIST
42Y08 Integrity violations. STATEMENT_SEVERITY LANG_NO_FK_ON_SYSTEM_SCHEMA
42Y09 Integrity violations. STATEMENT_SEVERITY LANG_VOID_METHOD_CALL
42Y10 Integrity violations. STATEMENT_SEVERITY LANG_TABLE_CONSTRUCTOR_ALL_PARAM_COLUMN
42Y11 Integrity violations. STATEMENT_SEVERITY LANG_MISSING_JOIN_SPECIFICATION
42Y12 Integrity violations. STATEMENT_SEVERITY LANG_NON_BOOLEAN_JOIN_CLAUSE
42Y13 Integrity violations. STATEMENT_SEVERITY LANG_DUPLICATE_COLUMN_NAME_CREATE_VIEW
42Y16 Integrity violations. STATEMENT_SEVERITY LANG_NO_METHOD_MATCHING_ALIAS
42Y22 Integrity violations. STATEMENT_SEVERITY LANG_USER_AGGREGATE_BAD_TYPE
42Y23 Integrity violations. STATEMENT_SEVERITY LANG_BAD_J_D_B_C_TYPE_INFO
42Y24 Integrity violations. STATEMENT_SEVERITY LANG_VIEW_NOT_UPDATEABLE
42Y25 Integrity violations. STATEMENT_SEVERITY LANG_UPDATE_SYSTEM_TABLE_ATTEMPTED
42Y26 Integrity violations. STATEMENT_SEVERITY LANG_AGGREGATE_IN_GROUPBY_LIST
42Y27 Integrity violations. STATEMENT_SEVERITY LANG_NO_PARAMS_IN_TRIGGER_ACTION
42Y29 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_NON_GROUPED_SELECT_LIST
42Y30 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_GROUPED_SELECT_LIST
42Y32 Integrity violations. STATEMENT_SEVERITY LANG_BAD_AGGREGATOR_CLASS2
42Y33 Integrity violations. STATEMENT_SEVERITY LANG_USER_AGGREGATE_CONTAINS_AGGREGATE
42Y34 Integrity violations. STATEMENT_SEVERITY LANG_AMBIGUOUS_COLUMN_NAME_IN_TABLE
42Y35 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_COL_REF_NON_GROUPED_SELECT_LIST
42Y36 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_COL_REF_GROUPED_SELECT_LIST
42Y37 Integrity violations. STATEMENT_SEVERITY LANG_TYPE_DOESNT_EXIST3
42Y38 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_BULK_INSERT_REPLACE
42Y39 Integrity violations. STATEMENT_SEVERITY LANG_UNRELIABLE_QUERY_FRAGMENT
42Y40 Integrity violations. STATEMENT_SEVERITY LANG_DUPLICATE_COLUMN_IN_TRIGGER_UPDATE
42Y41 Integrity violations. STATEMENT_SEVERITY LANG_TRIGGER_SPS_CANNOT_BE_EXECED
42Y42 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_DECIMAL_SCALE
42Y43 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_DECIMAL_PRECISION_SCALE
42Y44 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_FROM_TABLE_PROPERTY
42Y45 Integrity violations. STATEMENT_SEVERITY LANG_CANNOT_BIND_TRIGGER_V_T_I
42Y46 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_FORCED_INDEX1
42Y48 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_FORCED_INDEX2
42Y49 Integrity violations. STATEMENT_SEVERITY LANG_DUPLICATE_PROPERTY
42Y50 Integrity violations. STATEMENT_SEVERITY LANG_BOTH_FORCE_INDEX_AND_CONSTRAINT_SPECIFIED
42Y55 Integrity violations. STATEMENT_SEVERITY LANG_OBJECT_DOES_NOT_EXIST
42Y56 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_JOIN_STRATEGY
42Y58 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_NUMBER_FORMAT_FOR_OVERRIDE
42Y59 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_HASH_INITIAL_CAPACITY
42Y60 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_HASH_LOAD_FACTOR
42Y61 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_HASH_MAX_CAPACITY
42Y62 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_OPERATION_ON_VIEW
42Y63 Integrity violations. STATEMENT_SEVERITY LANG_HASH_NO_EQUIJOIN_FOUND
42Y64 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_BULK_FETCH_VALUE
42Y65 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_BULK_FETCH_WITH_JOIN_TYPE
42Y66 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_BULK_FETCH_UPDATEABLE
42Y67 Integrity violations. STATEMENT_SEVERITY LANG_CANNOT_DROP_SYSTEM_SCHEMAS
42Y69 Integrity violations. STATEMENT_SEVERITY LANG_NO_BEST_PLAN_FOUND
42Y70 Integrity violations. STATEMENT_SEVERITY LANG_ILLEGAL_FORCED_JOIN_ORDER
42Y71 Integrity violations. STATEMENT_SEVERITY LANG_CANNOT_DROP_SYSTEM_ALIASES
42Y82 Integrity violations. STATEMENT_SEVERITY LANG_CANNOT_DROP_TRIGGER_S_P_S
42Y83 Integrity violations. STATEMENT_SEVERITY LANG_USER_AGGREGATE_BAD_TYPE_NULL
42Y84 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_DEFAULT_DEFINITION
42Y85 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_USE_OF_DEFAULT
42Y90 Integrity violations. STATEMENT_SEVERITY LANG_STMT_NOT_UPDATABLE
42Y91 Integrity violations. STATEMENT_SEVERITY LANG_NO_SPS_USING_IN_TRIGGER
42Y92 Integrity violations. STATEMENT_SEVERITY LANG_TRIGGER_BAD_REF_MISMATCH
42Y93 Integrity violations. STATEMENT_SEVERITY LANG_TRIGGER_BAD_REF_CLAUSE_DUPS
42Y94 Integrity violations. STATEMENT_SEVERITY LANG_BINARY_LOGICAL_NON_BOOLEAN
42Y95 Integrity violations. STATEMENT_SEVERITY LANG_BINARY_OPERATOR_NOT_SUPPORTED
42Y96 U Integrity violations. UNKNOWN LANG_UNKNOWN
42Y97 Integrity violations. UNKNOWN LANG_INVALID_ESCAPE
42Y98 U Integrity violations. UNKNOWN LANG_JAVACC_SYNTAX
42Y99 U Integrity violations. UNKNOWN LANG_JAVACC_LEXICAL_ERROR
42Z00 U Integrity violations. UNKNOWN LANG_JAVA_METHOD_CALL_OR_FIELD_REF
42Z01 U Integrity violations. UNKNOWN LANG_UNTYPED
42Z02 Integrity violations. UNKNOWN LANG_USER_AGGREGATE_MULTIPLE_DISTINCTS
42Z07 Integrity violations. UNKNOWN LANG_NO_AGGREGATES_IN_ON_CLAUSE
42Z08 Integrity violations. UNKNOWN LANG_NO_BULK_INSERT_REPLACE_WITH_TRIGGER
42Z09 U Integrity violations. UNKNOWN LANG_COLUMN_DEFAULT
42Z10 Integrity violations. UNKNOWN LANG_UDT_BUILTIN_CONFLICT
42Z11 U Integrity violations. UNKNOWN LANG_STREAM
42Z12 U Integrity violations. UNKNOWN LANG_STREAM_INVALID_ACCESS
42Z15 Integrity violations. UNKNOWN LANG_MODIFY_COLUMN_CHANGE_TYPE
42Z16 Integrity violations. UNKNOWN LANG_MODIFY_COLUMN_INVALID_TYPE
42Z17 Integrity violations. UNKNOWN LANG_MODIFY_COLUMN_INVALID_LENGTH
42Z18 Integrity violations. UNKNOWN LANG_MODIFY_COLUMN_FKEY_CONSTRAINT
42Z19 Integrity violations. UNKNOWN LANG_MODIFY_COLUMN_REFERENCED
42Z20 Integrity violations. UNKNOWN LANG_MODIFY_COLUMN_EXISTING_CONSTRAINT
42Z20 S.1 Integrity violations. STATEMENT_SEVERITY LANG_MODIFY_COLUMN_EXISTING_PRIMARY_KEY
42Z21 Integrity violations. STATEMENT_SEVERITY LANG_AI_INVALID_INCREMENT
42Z22 Integrity violations. STATEMENT_SEVERITY LANG_AI_INVALID_TYPE
42Z23 Integrity violations. STATEMENT_SEVERITY LANG_AI_CANNOT_MODIFY_AI
42Z24 Integrity violations. STATEMENT_SEVERITY LANG_AI_OVERFLOW
42Z25 Integrity violations. STATEMENT_SEVERITY LANG_AI_COUNTER_ERROR
42Z26 Integrity violations. STATEMENT_SEVERITY LANG_AI_CANNOT_NULL_AI
42Z27 Integrity violations. STATEMENT_SEVERITY LANG_AI_CANNOT_ADD_AI_TO_NULLABLE
42Z30 U Integrity violations. UNKNOWN LANG_TIME_SPENT_THIS
42Z31 U Integrity violations. UNKNOWN LANG_TIME_SPENT_THIS_AND_BELOW
42Z32 U Integrity violations. UNKNOWN LANG_TOTAL_TIME_BREAKDOWN
42Z33 U Integrity violations. UNKNOWN LANG_CONSTRUCTOR_TIME
42Z34 U Integrity violations. UNKNOWN LANG_OPEN_TIME
42Z35 U Integrity violations. UNKNOWN LANG_NEXT_TIME
42Z36 U Integrity violations. UNKNOWN LANG_CLOSE_TIME
42Z37 U Integrity violations. UNKNOWN LANG_NONE
42Z38 U Integrity violations. UNKNOWN LANG_POSITION_NOT_AVAIL
42Z39 U Integrity violations. UNKNOWN LANG_UNEXPECTED_EXC_GETTING_POSITIONER
42Z40 U Integrity violations. UNKNOWN LANG_POSITIONER
42Z41 U Integrity violations. UNKNOWN LANG_ORDERED_NULL_SEMANTICS
42Z42 U Integrity violations. UNKNOWN LANG_COLUMN_ID
42Z43 U Integrity violations. UNKNOWN LANG_OPERATOR
42Z44 U Integrity violations. UNKNOWN LANG_ORDERED_NULLS
42Z45 U Integrity violations. UNKNOWN LANG_UNKNOWN_RETURN_VALUE
42Z46 U Integrity violations. UNKNOWN LANG_NEGATE_COMPARISON_RESULT
42Z47 U Integrity violations. UNKNOWN LANG_GQPT_NOT_SUPPORTED
42Z48 U Integrity violations. UNKNOWN LANG_COLUMN_ID_ARRAY
42Z50 Integrity violations. UNKNOWN LANG_UNABLE_TO_GENERATE
42Z53 Integrity violations. UNKNOWN LANG_UNAVAILABLE_ACTIVATION_NEED
42Z54 U Integrity violations. UNKNOWN LANG_PARSE_ONLY
42Z55 U Integrity violations. UNKNOWN LANG_STOP_AFTER_PARSING
42Z56 U Integrity violations. UNKNOWN LANG_STOP_AFTER_BINDING
42Z57 U Integrity violations. UNKNOWN LANG_STOP_AFTER_OPTIMIZING
42Z58 U Integrity violations. UNKNOWN LANG_STOP_AFTER_GENERATING
42Z60 Integrity violations. UNKNOWN LANG_GRANT_REVOKE_WITH_LEGACY_ACCESS
42Z70 Integrity violations. UNKNOWN LANG_ATTEMPT_TO_BIND_XML
42Z71 Integrity violations. UNKNOWN LANG_ATTEMPT_TO_SELECT_XML
42Z72 Integrity violations. UNKNOWN LANG_XML_KEYWORD_MISSING
42Z73 Integrity violations. UNKNOWN LANG_INVALID_XMLSERIALIZE_TYPE
42Z74 Integrity violations. UNKNOWN LANG_UNSUPPORTED_XML_FEATURE
42Z75 Integrity violations. UNKNOWN LANG_INVALID_XML_QUERY_EXPRESSION
42Z76 Integrity violations. UNKNOWN LANG_MULTIPLE_XML_CONTEXT_ITEMS
42Z77 Integrity violations. UNKNOWN LANG_INVALID_CONTEXT_ITEM_TYPE
42Z79 Integrity violations. UNKNOWN LANG_XMLPARSE_UNKNOWN_PARAM_TYPE
42Z80 U Integrity violations. UNKNOWN LANG_SERIALIZABLE
42Z81 U Integrity violations. UNKNOWN LANG_READ_COMMITTED
42Z82 U Integrity violations. UNKNOWN LANG_EXCLUSIVE
42Z83 U Integrity violations. UNKNOWN LANG_INSTANTANEOUS_SHARE
42Z84 U Integrity violations. UNKNOWN LANG_SHARE
42Z85 U Integrity violations. UNKNOWN LANG_TABLE
42Z86 U Integrity violations. UNKNOWN LANG_ROW
42Z87 U Integrity violations. UNKNOWN LANG_SHARE_TABLE
42Z88 U Integrity violations. UNKNOWN LANG_SHARE_ROW
42Z90 Integrity violations. UNKNOWN LANG_UPDATABLE_VTI_NON_UPDATABLE_RS
42Z91 Integrity violations. UNKNOWN LANG_SUBQUERY
42Z92 Integrity violations. UNKNOWN LANG_REPEATABLE_READ
42Z93 Integrity violations. UNKNOWN LANG_MULTIPLE_CONSTRAINTS_WITH_SAME_COLUMNS
42Z97 Integrity violations. UNKNOWN LANG_RENAME_COLUMN_WILL_BREAK_CHECK_CONSTRAINT
42Z99 Integrity violations. UNKNOWN LANG_INVALID_LITERAL_LENGTH
42Z9A Integrity violations. UNKNOWN LANG_READ_UNCOMMITTED
42Z9B Integrity violations. UNKNOWN LANG_VTI_BLOB_CLOB_UNSUPPORTED
42Z9D Integrity violations. UNKNOWN LANG_UNSUPPORTED_TRIGGER_STMT
42Z9D S.1 Integrity violations. STATEMENT_SEVERITY LANG_UNSUPPORTED_TRIGGER_PROC
42Z9E Integrity violations. STATEMENT_SEVERITY LANG_DROP_CONSTRAINT_TYPE
42Z9F Integrity violations. STATEMENT_SEVERITY LANG_TOO_MANY_INDEXES_ON_TABLE
42ZA0 Integrity violations. STATEMENT_SEVERITY LANG_QUERY_TOO_COMPLEX
42ZA1 Integrity violations. STATEMENT_SEVERITY LANG_INVALID_SQL_IN_BATCH
42ZA2 Integrity violations. STATEMENT_SEVERITY LANG_LIKE_COLLATION_MISMATCH
42ZA3 Integrity violations. STATEMENT_SEVERITY LANG_CAN_NOT_CREATE_TABLE
42ZB1 Integrity violations. STATEMENT_SEVERITY LANG_NO_DJRS
42ZB2 Integrity violations. STATEMENT_SEVERITY LANG_MUST_BE_DJRS
42ZB3 Integrity violations. STATEMENT_SEVERITY LANG_XML_NOT_ALLOWED_DJRS
42ZB4 Integrity violations. STATEMENT_SEVERITY LANG_NOT_TABLE_FUNCTION
42ZB5 Integrity violations. STATEMENT_SEVERITY LANG_NO_COSTING_CONSTRUCTOR
42ZB6 Integrity violations. STATEMENT_SEVERITY LANG_TABLE_FUNCTION_NOT_ALLOWED
42ZC0 Integrity violations. STATEMENT_SEVERITY LANG_NO_SUCH_WINDOW
42ZC1 Integrity violations. STATEMENT_SEVERITY LANG_WINDOW_LIMIT_EXCEEDED
42ZC2 Integrity violations. STATEMENT_SEVERITY LANG_WINDOW_FUNCTION_CONTEXT_ERROR
43X00 U Integrity violations. UNKNOWN RTS_ATTACHED_TO
43X01 U Integrity violations. UNKNOWN RTS_BEGIN_SQ_NUMBER
43X02 U Integrity violations. UNKNOWN RTS_ANY_RS
43X03 U Integrity violations. UNKNOWN RTS_NUM_OPENS
43X04 U Integrity violations. UNKNOWN RTS_ROWS_SEEN
43X05 U Integrity violations. UNKNOWN RTS_SOURCE_RS
43X06 U Integrity violations. UNKNOWN RTS_END_SQ_NUMBER
43X07 U Integrity violations. UNKNOWN RTS_OPT_EST_RC
43X08 U Integrity violations. UNKNOWN RTS_OPT_EST_COST
43X09 U Integrity violations. UNKNOWN RTS_SECONDS
43X10 U Integrity violations. UNKNOWN RTS_TOTAL
43X11 U Integrity violations. UNKNOWN RTS_NODE
43X12 U Integrity violations. UNKNOWN RTS_NOT_IMPL
43X13 U Integrity violations. UNKNOWN RTS_DELETE_RS_USING
43X14 U Integrity violations. UNKNOWN RTS_TABLE_LOCKING
43X15 U Integrity violations. UNKNOWN RTS_ROW_LOCKING
43X16 U Integrity violations. UNKNOWN RTS_DEFERRED
43X17 U Integrity violations. UNKNOWN RTS_ROWS_DELETED
43X18 U Integrity violations. UNKNOWN RTS_INDEXES_UPDATED
43X19 U Integrity violations. UNKNOWN RTS_DELETE
43X20 U Integrity violations. UNKNOWN RTS_DSARS
43X21 U Integrity violations. UNKNOWN RTS_ROWS_INPUT
43X22 U Integrity violations. UNKNOWN RTS_DISTINCT_SCALAR_AGG
43X23 U Integrity violations. UNKNOWN RTS_DISTINCT_SCAN_RS_USING
43X24 U Integrity violations. UNKNOWN RTS_CONSTRAINT
43X25 U Integrity violations. UNKNOWN RTS_INDEX
43X26 U Integrity violations. UNKNOWN RTS_DISTINCT_SCAN_RS
43X27 U Integrity violations. UNKNOWN RTS_LOCKING
43X28 U Integrity violations. UNKNOWN RTS_SCAN_INFO
43X29 U Integrity violations. UNKNOWN RTS_DISTINCT_COL
43X30 U Integrity violations. UNKNOWN RTS_DISTINCT_COLS
43X31 U Integrity violations. UNKNOWN RTS_HASH_TABLE_SIZE
43X32 U Integrity violations. UNKNOWN RTS_ROWS_FILTERED
43X33 U Integrity violations. UNKNOWN RTS_NEXT_TIME
43X34 U Integrity violations. UNKNOWN RTS_START_POSITION
43X35 U Integrity violations. UNKNOWN RTS_STOP_POSITION
43X36 U Integrity violations. UNKNOWN RTS_SCAN_QUALS
43X37 U Integrity violations. UNKNOWN RTS_NEXT_QUALS
43X38 U Integrity violations. UNKNOWN RTS_ON_USING
43X39 U Integrity violations. UNKNOWN RTS_DISTINCT_SCAN
43X40 U Integrity violations. UNKNOWN RTS_SORT_INFO
43X41 U Integrity violations. UNKNOWN RTS_GROUPED_AGG_RS
43X42 U Integrity violations. UNKNOWN RTS_HAS_DISTINCT_AGG
43X43 U Integrity violations. UNKNOWN RTS_IN_SORTED_ORDER
43X44 U Integrity violations. UNKNOWN RTS_GROUPED_AGG
43X45 U Integrity violations. UNKNOWN RTS_HASH_EXISTS_JOIN
43X46 U Integrity violations. UNKNOWN RTS_HASH_EXISTS_JOIN_RS
43X47 U Integrity violations. UNKNOWN RTS_HASH_JOIN
43X48 U Integrity violations. UNKNOWN RTS_HASH_JOIN_RS
43X49 U Integrity violations. UNKNOWN RTS_HASH_LEFT_OJ
43X50 U Integrity violations. UNKNOWN RTS_HASH_LEFT_OJ_RS
43X51 U Integrity violations. UNKNOWN RTS_HASH_SCAN_RS_USING
43X52 U Integrity violations. UNKNOWN RTS_HASH_SCAN_RS
43X53 U Integrity violations. UNKNOWN RTS_HASH_KEY
43X54 U Integrity violations. UNKNOWN RTS_HASH_KEYS
43X55 U Integrity violations. UNKNOWN RTS_HASH_SCAN
43X56 U Integrity violations. UNKNOWN RTS_ATTACHED_SQS
43X57 U Integrity violations. UNKNOWN RTS_HASH_TABLE_RS
43X58 U Integrity violations. UNKNOWN RTS_HASH_TABLE
43X59 U Integrity violations. UNKNOWN RTS_ALL
43X60 U Integrity violations. UNKNOWN RTS_IRTBR_RS
43X61 U Integrity violations. UNKNOWN RTS_COLS_ACCESSED_FROM_HEAP
43X62 U Integrity violations. UNKNOWN RTS_FOR_TAB_NAME
43X63 U Integrity violations. UNKNOWN RTS_IRTBR
43X64 U Integrity violations. UNKNOWN RTS_INSERT_MODE_BULK
43X65 U Integrity violations. UNKNOWN RTS_INSERT_MODE_NOT_BULK
43X66 U Integrity violations. UNKNOWN RTS_INSERT_MODE_NORMAL
43X67 U Integrity violations. UNKNOWN RTS_INSERT_USING
43X68 U Integrity violations. UNKNOWN RTS_ROWS_INSERTED
43X69 U Integrity violations. UNKNOWN RTS_INSERT
43X70 U Integrity violations. UNKNOWN RTS_JOIN
43X71 U Integrity violations. UNKNOWN RTS_LKIS_RS
43X72 U Integrity violations. UNKNOWN RTS_LOCKING_OPTIMIZER
43X73 U Integrity violations. UNKNOWN RTS_TABLE_SCAN
43X74 U Integrity violations. UNKNOWN RTS_INDEX_SCAN
43X75 U Integrity violations. UNKNOWN RTS_ON
43X76 U Integrity violations. UNKNOWN RTS_MATERIALIZED_RS
43X77 U Integrity violations. UNKNOWN RTS_TEMP_CONGLOM_CREATE_TIME
43X78 U Integrity violations. UNKNOWN RTS_TEMP_CONGLOM_FETCH_TIME
43X79 U Integrity violations. UNKNOWN RTS_ROWS_SEEN_LEFT
43X80 U Integrity violations. UNKNOWN RTS_ROWS_SEEN_RIGHT
43X81 U Integrity violations. UNKNOWN RTS_ROWS_RETURNED
43X82 U Integrity violations. UNKNOWN RTS_LEFT_RS
43X83 U Integrity violations. UNKNOWN RTS_RIGHT_RS
43X84 U Integrity violations. UNKNOWN RTS_NESTED_LOOP_EXISTS_JOIN
43X85 U Integrity violations. UNKNOWN RTS_NESTED_LOOP_EXISTS_JOIN_RS
43X86 U Integrity violations. UNKNOWN RTS_NESTED_LOOP_JOIN
43X87 U Integrity violations. UNKNOWN RTS_NESTED_LOOP_JOIN_RS
43X88 U Integrity violations. UNKNOWN RTS_EMPTY_RIGHT_ROWS
43X89 U Integrity violations. UNKNOWN RTS_NESTED_LOOP_LEFT_OJ
43X90 U Integrity violations. UNKNOWN RTS_NESTED_LOOP_LEFT_OJ_RS
43X91 U Integrity violations. UNKNOWN RTS_NORMALIZE_RS
43X92 U Integrity violations. UNKNOWN RTS_ONCE_RS
43X93 U Integrity violations. UNKNOWN RTS_PR_RS
43X94 U Integrity violations. UNKNOWN RTS_RESTRICTION
43X95 U Integrity violations. UNKNOWN RTS_PROJECTION
43X96 U Integrity violations. UNKNOWN RTS_RESTRICTION_TIME
43X97 U Integrity violations. UNKNOWN RTS_PROJECTION_TIME
43X98 U Integrity violations. UNKNOWN RTS_PR
43X99 U Integrity violations. UNKNOWN RTS_ROW_RS
43X9A U Integrity violations. UNKNOWN RTS_RC
43X9B U Integrity violations. UNKNOWN RTS_RC_RS
43X9C U Integrity violations. UNKNOWN RTS_WINDOW_RS
43Y00 U Integrity violations. UNKNOWN RTS_SCALAR_AGG_RS
43Y01 U Integrity violations. UNKNOWN RTS_INDEX_KEY_OPT
43Y02 U Integrity violations. UNKNOWN RTS_SCALAR_AGG
43Y03 U Integrity violations. UNKNOWN RTS_SCROLL_INSENSITIVE_RS
43Y04 U Integrity violations. UNKNOWN RTS_READS_FROM_HASH
43Y05 U Integrity violations. UNKNOWN RTS_WRITES_TO_HASH
43Y06 U Integrity violations. UNKNOWN RTS_SORT_RS
43Y07 U Integrity violations. UNKNOWN RTS_ELIMINATE_DUPS
43Y08 U Integrity violations. UNKNOWN RTS_SORT
43Y09 U Integrity violations. UNKNOWN RTS_IS_RS_USING
43Y10 U Integrity violations. UNKNOWN RTS_TS_RS_FOR
43Y11 U Integrity violations. UNKNOWN RTS_ACTUAL_TABLE
43Y12 U Integrity violations. UNKNOWN RTS_FETCH_SIZE
43Y13 U Integrity violations. UNKNOWN RTS_QUALS
43Y14 U Integrity violations. UNKNOWN RTS_UNION_RS
43Y15 U Integrity violations. UNKNOWN RTS_UNION
43Y16 U Integrity violations. UNKNOWN RTS_UPDATE_RS_USING
43Y17 U Integrity violations. UNKNOWN RTS_ROWS_UPDATED
43Y18 U Integrity violations. UNKNOWN RTS_UPDATE
43Y19 U Integrity violations. UNKNOWN RTS_VTI_RS
43Y20 U Integrity violations. UNKNOWN RTS_VTI
43Y21 U Integrity violations. UNKNOWN RTS_MATERIALIZED_SUBQS
43Y22 U Integrity violations. UNKNOWN RTS_STATEMENT_NAME
43Y23 U Integrity violations. UNKNOWN RTS_STATEMENT_TEXT
43Y24 U Integrity violations. UNKNOWN RTS_PARSE_TIME
43Y25 U Integrity violations. UNKNOWN RTS_BIND_TIME
43Y26 U Integrity violations. UNKNOWN RTS_OPTIMIZE_TIME
43Y27 U Integrity violations. UNKNOWN RTS_GENERATE_TIME
43Y28 U Integrity violations. UNKNOWN RTS_COMPILE_TIME
43Y29 U Integrity violations. UNKNOWN RTS_EXECUTE_TIME
43Y30 U Integrity violations. UNKNOWN RTS_BEGIN_COMP_TS
43Y31 U Integrity violations. UNKNOWN RTS_END_COMP_TS
43Y32 U Integrity violations. UNKNOWN RTS_BEGIN_EXE_TS
43Y33 U Integrity violations. UNKNOWN RTS_END_EXE_TS
43Y44 U Integrity violations. UNKNOWN RTS_STMT_EXE_PLAN_TXT
43Y45 U Integrity violations. UNKNOWN RTS_RUN_TIME
43Y46 U Integrity violations. UNKNOWN RTS_INSERT_VTI_RESULT_SET
43Y47 U Integrity violations. UNKNOWN RTS_DELETE_VTI_RESULT_SET
43Y49 U Integrity violations. UNKNOWN RTS_INSERT_VTI
43Y50 U Integrity violations. UNKNOWN RTS_DELETE_VTI
43Y51 U Integrity violations. UNKNOWN RTS_DELETE_CASCADE
43Y52 U Integrity violations. UNKNOWN RTS_DELETE_CASCADE_RS_USING
43Y53 U Integrity violations. UNKNOWN RTS_REFACTION_DEPENDENT
43Y54 U Integrity violations. UNKNOWN RTS_BEGIN_DEPENDENT_NUMBER
43Y55 U Integrity violations. UNKNOWN RTS_END_DEPENDENT_NUMBER
43Y56 U Integrity violations. UNKNOWN RTS_USER_SUPPLIED_OPTIMIZER_OVERRIDES_FOR_TABLE
43Y57 U Integrity violations. UNKNOWN RTS_USER_SUPPLIED_OPTIMIZER_OVERRIDES_FOR_JOIN
43Y58 U Integrity violations. UNKNOWN RTS_INTERSECT_RS
43Y59 U Integrity violations. UNKNOWN RTS_INTERSECT
43Y60 U Integrity violations. UNKNOWN RTS_EXCEPT_RS
43Y61 U Integrity violations. UNKNOWN RTS_EXCEPT
44X00 U Integrity violations. UNKNOWN TI_SQL_TYPE_NAME
44X05 U Integrity violations. UNKNOWN TI_NEXT_ERROR
46001 SQL Java DDL 46xxxSQLJ jar file support STATEMENT_SEVERITY SQLJ_INVALID_JAR
46J01 SQL Java DDL 46xxxSQLJ jar file support STATEMENT_SEVERITY SQLJ_SIGNATURE_INVALID
46J02 SQL Java DDL 46xxxSQLJ jar file support STATEMENT_SEVERITY SQLJ_SIGNATURE_PARAMETER_COUNT
54002 Integrity violations. STATEMENT_SEVERITY LANG_DB2_STRING_CONSTANT_TOO_LONG
54004 Integrity violations. STATEMENT_SEVERITY LANG_TOO_MANY_ELEMENTS
54006 SQL Data exceptions STATEMENT_SEVERITY LANG_CONCAT_STRING_OVERFLOW
54008 Integrity violations. STATEMENT_SEVERITY LANG_TOO_MANY_INDEX_KEY_COLS
54011 Integrity violations. STATEMENT_SEVERITY LANG_TOO_MANY_COLUMNS_IN_TABLE_OR_VIEW
54023 Integrity violations. STATEMENT_SEVERITY LANG_TOO_MANY_PARAMETERS_FOR_STORED_PROC
54038 Integrity violations. STATEMENT_SEVERITY LANG_TRIGGER_RECURSION_EXCEEDED
57017 C Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY DRDA_NO_AVAIL_CODEPAGE_CONVERSION
58009 C.7 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_SQLCDTA_INVALID_FOR_RDBCOLID
58009 C.8 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_SQLCDTA_INVALID_FOR_PKGID
58009 C.9 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_PGNAMCSN_INVALID_AT_SQLAM
58009 C.10 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_VCM_VCS_LENGTHS_INVALID
58009 C.11 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_ENCODING_NOT_SUPPORTED
58009 C.12 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_NOT_EXPECTED_CODEPOINT
58009 C.13 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_DDM_COLLECTION_TOO_SMALL
58009 C.14 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_COLLECTION_STACK_NOT_EMPTY
58009 C.15 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_DSS_NOT_ZERO
58009 C.16 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_DSS_CHAINED_WITH_SAME_ID
58009 C.17 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_PREMATURE_EOS_DISCONNECT
58009 C.18 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_INVALID_FDOCA_ID
58009 C.19 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_SECTKN_NOT_RETURNED
58009 C.20 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_NVCM_NVCS_BOTH_NON_NULL
58009 C.21 Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY NET_SQLCDTA_INVALID_FOR_RDBNAM
58010 C Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY DRDA_MGRLVLRM
58014 C Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY DRDA_DDM_COMMAND_NOT_SUPPORTED
58015 C Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY DRDA_DDM_OBJECT_NOT_SUPPORTED
58016 C Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY DRDA_DDM_PARAM_NOT_SUPPORTED
58017 C Messages whose SQL states are prescribed by DRDA SESSION_SEVERITY DRDA_DDM_PARAMVAL_NOT_SUPPORTED
S0022 Connectivity STATEMENT_SEVERITY COLUMN_NOT_FOUND
X0A00 S Integrity violations. STATEMENT_SEVERITY LANG_UNBINDABLE_REWRITE
X0X02 S Integrity violations. STATEMENT_SEVERITY LANG_CANT_LOCK_TABLE
X0X03 S Integrity violations. STATEMENT_SEVERITY LANG_CANT_CHANGE_ISOLATION_HOLD_CURSOR
X0X05 S Integrity violations. STATEMENT_SEVERITY LANG_TABLE_NOT_FOUND_DURING_EXECUTION
X0X07 S Integrity violations. STATEMENT_SEVERITY LANG_CANT_DROP_JAR_ON_DB_CLASS_PATH_DURING_EXECUTION
X0X0D S Integrity violations. STATEMENT_SEVERITY INVALID_COLUMN_ARRAY_LENGTH
X0X0E S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_AUTOGEN_COLUMN_POSITION
X0X0F S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_AUTOGEN_COLUMN_NAME
X0X10 S Integrity violations. STATEMENT_SEVERITY LANG_USING_CARDINALITY_VIOLATION_DURING_EXECUTION
X0X11 S Integrity violations. STATEMENT_SEVERITY LANG_NO_ROWS_FROM_USING_DURING_EXECUTION
X0X13 S Integrity violations. STATEMENT_SEVERITY LANG_FILE_DOES_NOT_EXIST
X0X57 S Integrity violations. STATEMENT_SEVERITY LANG_NO_CORRESPONDING_S_Q_L_TYPE
X0X60 S Integrity violations. STATEMENT_SEVERITY LANG_CURSOR_ALREADY_EXISTS
X0X61 S Integrity violations. STATEMENT_SEVERITY LANG_INDEX_COLUMN_NOT_EQUAL
X0X62 S Integrity violations. STATEMENT_SEVERITY LANG_INCONSISTENT_ROW_LOCATION
X0X63 S Integrity violations. STATEMENT_SEVERITY LANG_FILE_ERROR
X0X67 S Integrity violations. STATEMENT_SEVERITY LANG_COLUMN_NOT_ORDERABLE_DURING_EXECUTION
X0X81 S Integrity violations. STATEMENT_SEVERITY LANG_OBJECT_NOT_FOUND_DURING_EXECUTION
X0X85 S Integrity violations. STATEMENT_SEVERITY LANG_NON_KEYED_INDEX
X0X86 S Integrity violations. STATEMENT_SEVERITY LANG_ZERO_INVALID_FOR_R_S_ABSOLUTE
X0X87 S Integrity violations. STATEMENT_SEVERITY LANG_NO_CURRENT_ROW_FOR_RELATIVE
X0X95 S Integrity violations. STATEMENT_SEVERITY LANG_CANT_INVALIDATE_OPEN_RESULT_SET
X0X99 S Integrity violations. STATEMENT_SEVERITY LANG_INDEX_NOT_FOUND_DURING_EXECUTION
X0Y16 S Integrity violations. STATEMENT_SEVERITY LANG_DROP_VIEW_ON_NON_VIEW
X0Y23 S Integrity violations. STATEMENT_SEVERITY LANG_PROVIDER_HAS_DEPENDENT_VIEW
X0Y24 S Integrity violations. STATEMENT_SEVERITY LANG_PROVIDER_HAS_DEPENDENT_S_P_S
X0Y25 S Integrity violations. STATEMENT_SEVERITY LANG_PROVIDER_HAS_DEPENDENT_OBJECT
X0Y26 S Integrity violations. STATEMENT_SEVERITY LANG_INDEX_AND_TABLE_IN_DIFFERENT_SCHEMAS
X0Y28 S Integrity violations. STATEMENT_SEVERITY LANG_CREATE_SYSTEM_INDEX_ATTEMPTED
X0Y29 S Integrity violations. STATEMENT_SEVERITY LANG_PROVIDER_HAS_DEPENDENT_TABLE
X0Y30 S Integrity violations. STATEMENT_SEVERITY LANG_PROVIDER_HAS_DEPENDENT_ALIAS
X0Y32 S Integrity violations. STATEMENT_SEVERITY LANG_OBJECT_ALREADY_EXISTS_IN_OBJECT
X0Y38 S Integrity violations. STATEMENT_SEVERITY LANG_CREATE_INDEX_NO_TABLE
X0Y41 S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_FK_NO_PK
X0Y42 S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_FK_COL_TYPES_DO_NOT_MATCH
X0Y43 S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_FK_DIFFERENT_COL_COUNT
X0Y44 S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_FK_NO_REF_KEY
X0Y45 S Integrity violations. STATEMENT_SEVERITY LANG_ADD_FK_CONSTRAINT_VIOLATION
X0Y46 S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_FK_NO_REF_TAB
X0Y54 S Integrity violations. STATEMENT_SEVERITY LANG_SCHEMA_NOT_EMPTY
X0Y55 S Integrity violations. STATEMENT_SEVERITY LANG_INDEX_ROW_COUNT_MISMATCH
X0Y56 S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_OPERATION_ON_SYSTEM_TABLE
X0Y57 S Integrity violations. STATEMENT_SEVERITY LANG_ADDING_NON_NULL_COLUMN_TO_NON_EMPTY_TABLE
X0Y58 S Integrity violations. STATEMENT_SEVERITY LANG_ADD_PRIMARY_KEY_FAILED1
X0Y59 S Integrity violations. STATEMENT_SEVERITY LANG_ADD_CHECK_CONSTRAINT_FAILED
X0Y63 S Integrity violations. STATEMENT_SEVERITY LANG_NULL_DATA_IN_PRIMARY_KEY_OR_UNIQUE_CONSTRAINT
X0Y63 S.1 Integrity violations. STATEMENT_SEVERITY LANG_NULL_DATA_IN_PRIMARY_KEY
X0Y66 S Integrity violations. STATEMENT_SEVERITY LANG_NO_COMMIT_IN_NESTED_CONNECTION
X0Y67 S Integrity violations. STATEMENT_SEVERITY LANG_NO_ROLLBACK_IN_NESTED_CONNECTION
X0Y68 S Integrity violations. STATEMENT_SEVERITY LANG_OBJECT_ALREADY_EXISTS
X0Y69 S Integrity violations. STATEMENT_SEVERITY LANG_NO_DDL_IN_TRIGGER
X0Y70 S Integrity violations. STATEMENT_SEVERITY LANG_NO_DML_IN_TRIGGER
X0Y71 S Integrity violations. STATEMENT_SEVERITY LANG_NO_XACT_IN_TRIGGER
X0Y72 S Integrity violations. STATEMENT_SEVERITY LANG_NO_BULK_INSERT_REPLACE_WITH_TRIGGER_DURING_EXECUTION
X0Y77 S Integrity violations. STATEMENT_SEVERITY LANG_NO_SET_TRAN_ISO_IN_GLOBAL_CONNECTION
X0Y78 S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_CALL_TO_EXECUTE_QUERY
X0Y78 S.1 Integrity violations. STATEMENT_SEVERITY MULTIPLE_RESULTS_ON_EXECUTE_QUERY
X0Y78 S.2 Integrity violations. STATEMENT_SEVERITY USE_EXECUTE_UPDATE_WITH_NO_RESULTS
X0Y79 S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_CALL_TO_EXECUTE_UPDATE
X0Y80 S Integrity violations. STATEMENT_SEVERITY LANG_NULL_DATA_IN_NON_NULL_COLUMN
X0Y83 S Integrity violations. STATEMENT_SEVERITY LANG_IGNORE_MISSING_INDEX_ROW_DURING_DELETE
X0Y84 S Integrity violations. STATEMENT_SEVERITY LANG_TOO_MUCH_CONTENTION_ON_SEQUENCE
XBCA0 S Cache Service STATEMENT_SEVERITY OBJECT_EXISTS_IN_CACHE
XBCM1 S ClassManager STATEMENT_SEVERITY GENERATED_CLASS_LINKAGE_ERROR
XBCM2 S ClassManager STATEMENT_SEVERITY GENERATED_CLASS_INSTANCE_ERROR
XBCM3 S ClassManager STATEMENT_SEVERITY GENERATED_CLASS_NO_SUCH_METHOD
XBCM4 S ClassManager STATEMENT_SEVERITY GENERATED_CLASS_LIMIT_EXCEEDED
XBCX0 S Cryptography STATEMENT_SEVERITY CRYPTO_EXCEPTION
XBCX1 S Cryptography STATEMENT_SEVERITY ILLEGAL_CIPHER_MODE
XBCX2 S Cryptography STATEMENT_SEVERITY ILLEGAL_BP_LENGTH
XBCX5 S Cryptography STATEMENT_SEVERITY NULL_BOOT_PASSWORD
XBCX6 S Cryptography STATEMENT_SEVERITY NON_STRING_BP
XBCX7 S Cryptography STATEMENT_SEVERITY WRONG_PASSWORD_CHANGE_FORMAT
XBCX8 S Cryptography STATEMENT_SEVERITY DATABASE_NOT_ENCRYPTED
XBCX9 S Cryptography STATEMENT_SEVERITY DATABASE_READ_ONLY
XBCXA S Cryptography STATEMENT_SEVERITY WRONG_BOOT_PASSWORD
XBCXB S Cryptography STATEMENT_SEVERITY ENCRYPTION_BAD_PADDING
XBCXC S Cryptography STATEMENT_SEVERITY ENCRYPTION_NOSUCH_ALGORITHM
XBCXD S Cryptography STATEMENT_SEVERITY ENCRYPTION_NOCHANGE_ALGORITHM
XBCXE S Cryptography STATEMENT_SEVERITY ENCRYPTION_NOCHANGE_PROVIDER
XBCXF S Cryptography STATEMENT_SEVERITY ENCRYPTION_NO_PROVIDER_CLASS
XBCXG S Cryptography STATEMENT_SEVERITY ENCRYPTION_BAD_PROVIDER
XBCXH S Cryptography STATEMENT_SEVERITY ENCRYPTION_BAD_ALG_FORMAT
XBCXI S Cryptography STATEMENT_SEVERITY ENCRYPTION_BAD_FEEDBACKMODE
XBCXJ S Cryptography STATEMENT_SEVERITY ENCRYPTION_BAD_JCE
XBCXK S Cryptography STATEMENT_SEVERITY ENCRYPTION_BAD_EXTERNAL_KEY
XBCXL S Cryptography STATEMENT_SEVERITY ENCRYPTION_UNABLE_KEY_VERIFICATION
XBCXM S Cryptography STATEMENT_SEVERITY ENCRYPTION_INVALID_EXKEY_LENGTH
XBCXN S Cryptography STATEMENT_SEVERITY ENCRYPTION_ILLEGAL_EXKEY_CHARS
XBCXO S Cryptography STATEMENT_SEVERITY ENCRYPTION_PREPARED_XACT_EXIST
XBCXP S Cryptography STATEMENT_SEVERITY REENCRYPTION_PREPARED_XACT_EXIST
XBCXQ S Cryptography STATEMENT_SEVERITY CANNOT_ENCRYPT_READONLY_DATABASE
XBCXR S Cryptography STATEMENT_SEVERITY CANNOT_REENCRYPT_READONLY_DATABASE
XBCXS S Cryptography STATEMENT_SEVERITY CANNOT_ENCRYPT_LOG_ARCHIVED_DATABASE
XBCXT S Cryptography STATEMENT_SEVERITY CANNOT_REENCRYPT_LOG_ARCHIVED_DATABASE
XBCXU S Cryptography STATEMENT_SEVERITY DATABASE_ENCRYPTION_FAILED
XBCXV S Cryptography STATEMENT_SEVERITY DATABASE_REENCRYPTION_FAILED
XBCXW S Cryptography STATEMENT_SEVERITY DIGEST_NO_SUCH_ALGORITHM
XBM01 D BasicServicesMonitor DATABASE_SEVERITY SERVICE_STARTUP_EXCEPTION
XBM02 D BasicServicesMonitor DATABASE_SEVERITY SERVICE_MISSING_IMPLEMENTATION
XBM03 D BasicServicesMonitor DATABASE_SEVERITY INVALID_COLLATION
XBM04 D BasicServicesMonitor DATABASE_SEVERITY COLLATOR_NOT_FOUND_FOR_LOCALE
XBM05 D BasicServicesMonitor DATABASE_SEVERITY MISSING_PRODUCT_VERSION
XBM06 D BasicServicesMonitor DATABASE_SEVERITY SERVICE_WRONG_BOOT_PASSWORD
XBM07 D BasicServicesMonitor DATABASE_SEVERITY SERVICE_BOOT_PASSWORD_TOO_SHORT
XBM08 D BasicServicesMonitor DATABASE_SEVERITY INSTANTIATE_STORAGE_FACTORY_ERROR
XBM0A D BasicServicesMonitor DATABASE_SEVERITY MISSING_SERVICE_PROPERTIES
XBM0G D BasicServicesMonitor DATABASE_SEVERITY MISSING_ENCRYPTION_PROVIDER
XBM0H D BasicServicesMonitor DATABASE_SEVERITY SERVICE_DIRECTORY_CREATE_ERROR
XBM0I D BasicServicesMonitor DATABASE_SEVERITY SERVICE_DIRECTORY_REMOVE_ERROR
XBM0J D BasicServicesMonitor DATABASE_SEVERITY SERVICE_DIRECTORY_EXISTS_ERROR
XBM0K D BasicServicesMonitor DATABASE_SEVERITY PROTOCOL_UNKNOWN
XBM0L D BasicServicesMonitor DATABASE_SEVERITY AUTHENTICATION_NOT_IMPLEMENTED
XBM0M D BasicServicesMonitor DATABASE_SEVERITY AUTHENTICATION_SCHEME_ERROR
XBM0N D BasicServicesMonitor DATABASE_SEVERITY JDBC_DRIVER_REGISTER
XBM0P D BasicServicesMonitor DATABASE_SEVERITY READ_ONLY_SERVICE
XBM0Q D BasicServicesMonitor DATABASE_SEVERITY PROPERTY_FILE_NOT_FOUND_IN_BACKUP
XBM0R D BasicServicesMonitor DATABASE_SEVERITY UNABLE_TO_DELETE_FILE
XBM0S D BasicServicesMonitor DATABASE_SEVERITY UNABLE_TO_RENAME_FILE
XBM0T D BasicServicesMonitor DATABASE_SEVERITY AMBIGIOUS_PROTOCOL
XBM0U S BasicServicesMonitor STATEMENT_SEVERITY REGISTERED_CLASS_NONE
XBM0V S BasicServicesMonitor STATEMENT_SEVERITY REGISTERED_CLASS_LINAKGE_ERROR
XBM0W S BasicServicesMonitor STATEMENT_SEVERITY REGISTERED_CLASS_INSTANCE_ERROR
XBM0X D BasicServicesMonitor DATABASE_SEVERITY INVALID_LOCALE_DESCRIPTION
XBM0Y D BasicServicesMonitor DATABASE_SEVERITY SERVICE_DIRECTORY_NOT_IN_BACKUP
XBM0Z D BasicServicesMonitor DATABASE_SEVERITY UNABLE_TO_COPY_FILE_FROM_BACKUP
XCL01 S Integrity violations. STATEMENT_SEVERITY LANG_DOES_NOT_RETURN_ROWS
XCL05 S Integrity violations. STATEMENT_SEVERITY LANG_ACTIVATION_CLOSED
XCL07 S Integrity violations. STATEMENT_SEVERITY LANG_CURSOR_CLOSED
XCL08 S Integrity violations. STATEMENT_SEVERITY LANG_NO_CURRENT_ROW
XCL09 S Integrity violations. STATEMENT_SEVERITY LANG_WRONG_ACTIVATION
XCL10 S Integrity violations. STATEMENT_SEVERITY LANG_OBSOLETE_PARAMETERS
XCL12 S Integrity violations. STATEMENT_SEVERITY LANG_DATA_TYPE_SET_MISMATCH
XCL13 S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_PARAM_POSITION
XCL14 S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_COLUMN_POSITION
XCL15 S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_COMPARE_TO
XCL16 S Integrity violations. STATEMENT_SEVERITY LANG_RESULT_SET_NOT_OPEN
XCL18 S Integrity violations. STATEMENT_SEVERITY LANG_STREAM_RETRIEVED_ALREADY
XCL19 S Integrity violations. STATEMENT_SEVERITY LANG_MISSING_ROW
XCL20 S Integrity violations. STATEMENT_SEVERITY LANG_CANT_UPGRADE_CATALOGS
XCL21 S Integrity violations. STATEMENT_SEVERITY LANG_DDL_IN_BIND
XCL22 S Integrity violations. STATEMENT_SEVERITY LANG_NOT_OUT_PARAM
XCL23 S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_S_Q_L_TYPE
XCL24 S Integrity violations. STATEMENT_SEVERITY LANG_PARAMETER_MUST_BE_OUTPUT
XCL25 S Integrity violations. STATEMENT_SEVERITY LANG_INVALID_OUT_PARAM_MAP
XCL26 S Integrity violations. STATEMENT_SEVERITY LANG_NOT_OUTPUT_PARAMETER
XCL27 S Integrity violations. STATEMENT_SEVERITY LANG_RETURN_OUTPUT_PARAM_CANNOT_BE_SET
XCL30 S Integrity violations. STATEMENT_SEVERITY LANG_STREAMING_COLUMN_I_O_EXCEPTION
XCL31 S Integrity violations. STATEMENT_SEVERITY LANG_STATEMENT_CLOSED_NO_REASON
XCL32 S Integrity violations. STATEMENT_SEVERITY LANG_STATEMENT_NEEDS_RECOMPILE
XCL33 S Integrity violations. STATEMENT_SEVERITY LANG_CANT_BE_DEPENDENT_ESELF
XCL34 S Integrity violations. STATEMENT_SEVERITY LANG_CANT_BE_DEPENDENT_ECYCLE
XCL35 S Integrity violations. STATEMENT_SEVERITY LANG_CANT_BE_DEPENDENT_MPATH
XCL36 S Integrity violations. STATEMENT_SEVERITY LANG_DELETE_RULE_MUSTBE_ESELF
XCL37 S Integrity violations. STATEMENT_SEVERITY LANG_DELETE_RULE_MUSTBE_ECASCADE
XCL38 S Integrity violations. STATEMENT_SEVERITY LANG_DELETE_RULE_MUSTBE_MPATH
XCL39 S Integrity violations. STATEMENT_SEVERITY LANG_DELETE_RULE_CANT_BE_CASCADE_ESELF
XCL40 S Integrity violations. STATEMENT_SEVERITY LANG_DELETE_RULE_CANT_BE_CASCADE_ECYCLE
XCL41 S Integrity violations. STATEMENT_SEVERITY LANG_DELETE_RULE_CANT_BE_CASCADE_MPATH
XCL42 S Integrity violations. STATEMENT_SEVERITY LANG_DELETE_RULE_CASCADE
XCL43 S Integrity violations. STATEMENT_SEVERITY LANG_DELETE_RULE_SETNULL
XCL44 S Integrity violations. STATEMENT_SEVERITY LANG_DELETE_RULE_RESTRICT
XCL45 S Integrity violations. STATEMENT_SEVERITY LANG_DELETE_RULE_NOACTION
XCL46 S Integrity violations. STATEMENT_SEVERITY LANG_DELETE_RULE_SETDEFAULT
XCL47 S Integrity violations. STATEMENT_SEVERITY LANG_STATEMENT_UPGRADE_REQUIRED
XCL48 S Integrity violations. STATEMENT_SEVERITY LANG_NO_TRUNCATE_ON_FK_REFERENCE_TABLE
XCL49 S Integrity violations. STATEMENT_SEVERITY LANG_NO_TRUNCATE_ON_ENABLED_DELETE_TRIGGERS
XCL50 S Integrity violations. STATEMENT_SEVERITY LANG_CANT_UPGRADE_DATABASE
XCL51 S Integrity violations. STATEMENT_SEVERITY LANG_OPERATION_NOT_ALLOWED_ON_SESSION_SCHEMA_TABLES
XCL52 S Integrity violations. STATEMENT_SEVERITY LANG_STATEMENT_CANCELLED_OR_TIMED_OUT
XCL53 Integrity violations. STATEMENT_SEVERITY LANG_STREAM_CLOSED
XCW00 D Upgrade DATABASE_SEVERITY UPGRADE_UNSUPPORTED
XCXA0 S InternalUtil – Id ParsingNote that the code catches ID pars STATEMENT_SEVERITY ID_PARSE_ERROR
XCXB0 S InternalUtil – Database Class Path ParsingNote that the cod STATEMENT_SEVERITY DB_CLASS_PATH_PARSE_ERROR
XCXC0 S InternalUtil – Id List ParsingNote that the code catches id STATEMENT_SEVERITY ID_LIST_PARSE_ERROR
XCXE0 S InternalUtil – IO Errors(Range XCXD0-XCXDZ)InternalUtil – L STATEMENT_SEVERITY NO_LOCALE
XCY00 S Properties STATEMENT_SEVERITY PROPERTY_INVALID_VALUE
XCY02 S Properties STATEMENT_SEVERITY PROPERTY_UNSUPPORTED_CHANGE
XCY03 S Properties STATEMENT_SEVERITY PROPERTY_MISSING
XCY04 S Properties STATEMENT_SEVERITY PROPERTY_SYNTAX_INVALID
XCZ00 S org.apache.derby.database.UserUtility STATEMENT_SEVERITY UU_UNKNOWN_PERMISSION
XCZ01 S org.apache.derby.database.UserUtility STATEMENT_SEVERITY UU_UNKNOWN_USER
XCZ02 S org.apache.derby.database.UserUtility STATEMENT_SEVERITY UU_INVALID_PARAMETER
XD003 S Dependency manager STATEMENT_SEVERITY DEP_UNABLE_TO_RESTORE
XD004 S Dependency manager STATEMENT_SEVERITY DEP_UNABLE_TO_STORE
XIE01 S Import/Export STATEMENT_SEVERITY CONNECTION_NULL
XIE03 S Import/Export STATEMENT_SEVERITY DATA_AFTER_STOP_DELIMITER
XIE04 S Import/Export STATEMENT_SEVERITY DATA_FILE_NOT_FOUND
XIE05 S Import/Export STATEMENT_SEVERITY DATA_FILE_NULL
XIE06 S Import/Export STATEMENT_SEVERITY ENTITY_NAME_MISSING
XIE07 S Import/Export STATEMENT_SEVERITY FIELD_IS_RECORD_SEPERATOR_SUBSET
XIE08 S Import/Export STATEMENT_SEVERITY INVALID_COLUMN_NAME
XIE09 S Import/Export STATEMENT_SEVERITY INVALID_COLUMN_NUMBER
XIE0B S Import/Export STATEMENT_SEVERITY UNSUPPORTED_COLUMN_TYPE
XIE0D S Import/Export STATEMENT_SEVERITY RECORD_SEPERATOR_MISSING
XIE0E S Import/Export STATEMENT_SEVERITY UNEXPECTED_END_OF_FILE
XIE0I S Import/Export STATEMENT_SEVERITY ERROR_WRITING_DATA
XIE0J S Import/Export STATEMENT_SEVERITY DELIMITERS_ARE_NOT_MUTUALLY_EXCLUSIVE
XIE0K S Import/Export STATEMENT_SEVERITY PERIOD_AS_CHAR_DELIMITER_NOT_ALLOWED
XIE0M S Import/Export STATEMENT_SEVERITY TABLE_NOT_FOUND
XIE0N S Import/Export STATEMENT_SEVERITY IMPORTFILE_HAS_INVALID_HEXSTRING
XIE0P S Import/Export STATEMENT_SEVERITY LOB_DATA_FILE_NOT_FOUND
XIE0Q S Import/Export STATEMENT_SEVERITY LOB_DATA_FILE_NULL
XIE0R S Import/Export STATEMENT_SEVERITY UNEXPECTED_IMPORT_ERROR
XIE0S S Import/Export STATEMENT_SEVERITY DATA_FILE_EXISTS
XIE0T S Import/Export STATEMENT_SEVERITY LOB_DATA_FILE_EXISTS
XJ001 U Connectivity UNKNOWN JAVA_EXCEPTION
XJ004 C Connectivity SESSION_SEVERITY DATABASE_NOT_FOUND
XJ008 S Connectivity STATEMENT_SEVERITY NO_SAVEPOINT_ROLLBACK_OR_RELEASE_WHEN_AUTO
XJ009 S Connectivity STATEMENT_SEVERITY REQUIRES_CALLABLE_STATEMENT
XJ010 S Connectivity STATEMENT_SEVERITY NO_SAVEPOINT_WHEN_AUTO
XJ011 S Connectivity STATEMENT_SEVERITY NULL_NAME_FOR_SAVEPOINT
XJ012 S Connectivity STATEMENT_SEVERITY ALREADY_CLOSED
XJ013 S Connectivity STATEMENT_SEVERITY NO_ID_FOR_NAMED_SAVEPOINT
XJ014 S Connectivity STATEMENT_SEVERITY NO_NAME_FOR_UNNAMED_SAVEPOINT
XJ015 M Connectivity SYSTEM_SEVERITY CLOUDSCAPE_SYSTEM_SHUTDOWN
XJ016 S Connectivity STATEMENT_SEVERITY NOT_FOR_PREPARED_STATEMENT
XJ017 S Connectivity STATEMENT_SEVERITY NO_SAVEPOINT_IN_TRIGGER
XJ018 S Connectivity STATEMENT_SEVERITY NULL_COLUMN_NAME
XJ020 S Connectivity STATEMENT_SEVERITY TYPE_MISMATCH
XJ021 S Connectivity STATEMENT_SEVERITY UNSUPPORTED_TYPE
XJ022 S Connectivity STATEMENT_SEVERITY SET_STREAM_FAILURE
XJ023 S Connectivity STATEMENT_SEVERITY SET_STREAM_INEXACT_LENGTH_DATA
XJ025 S Connectivity STATEMENT_SEVERITY NEGATIVE_STREAM_LENGTH
XJ028 C Connectivity SESSION_SEVERITY MALFORMED_URL
XJ030 S Connectivity STATEMENT_SEVERITY NO_AUTO_COMMIT_ON
XJ040 C Connectivity SESSION_SEVERITY BOOT_DATABASE_FAILED
XJ041 C Connectivity SESSION_SEVERITY CREATE_DATABASE_FAILED
XJ042 S Connectivity STATEMENT_SEVERITY BAD_PROPERTY_VALUE
XJ044 S Connectivity STATEMENT_SEVERITY BAD_SCALE_VALUE
XJ045 S Connectivity STATEMENT_SEVERITY UNIMPLEMENTED_ISOLATION_LEVEL
XJ048 C Connectivity SESSION_SEVERITY CONFLICTING_BOOT_ATTRIBUTES
XJ049 C Connectivity SESSION_SEVERITY CONFLICTING_CREATE_ATTRIBUTES
XJ04B S Connectivity STATEMENT_SEVERITY RESULTSET_RETURN_NOT_ALLOWED
XJ04C S Connectivity STATEMENT_SEVERITY OUTPUT_PARAMS_NOT_ALLOWED
XJ050 U Connectivity UNKNOWN NO_UPGRADE
XJ056 S Connectivity STATEMENT_SEVERITY CANNOT_AUTOCOMMIT_XA
XJ057 S Connectivity STATEMENT_SEVERITY CANNOT_COMMIT_XA
XJ058 S Connectivity STATEMENT_SEVERITY CANNOT_ROLLBACK_XA
XJ059 S Connectivity STATEMENT_SEVERITY CANNOT_CLOSE_ACTIVE_XA_CONNECTION
XJ05B C Connectivity SESSION_SEVERITY INVALID_ATTRIBUTE
XJ05C S Connectivity STATEMENT_SEVERITY CANNOT_HOLD_CURSOR_XA
XJ061 S Connectivity STATEMENT_SEVERITY NOT_ON_FORWARD_ONLY_CURSOR
XJ062 S Connectivity STATEMENT_SEVERITY INVALID_FETCH_SIZE
XJ063 S Connectivity STATEMENT_SEVERITY INVALID_MAX_ROWS_VALUE
XJ064 S Connectivity STATEMENT_SEVERITY INVALID_FETCH_DIRECTION
XJ065 S Connectivity STATEMENT_SEVERITY INVALID_ST_FETCH_SIZE
XJ066 S Connectivity STATEMENT_SEVERITY INVALID_MAXFIELD_SIZE
XJ067 S Connectivity STATEMENT_SEVERITY NULL_SQL_TEXT
XJ068 S Connectivity STATEMENT_SEVERITY MIDDLE_OF_BATCH
XJ069 S Connectivity STATEMENT_SEVERITY NO_SETXXX_FOR_EXEC_USING
XJ070 S Connectivity STATEMENT_SEVERITY BLOB_BAD_POSITION
XJ071 S Connectivity STATEMENT_SEVERITY BLOB_NONPOSITIVE_LENGTH
XJ072 S Connectivity STATEMENT_SEVERITY BLOB_NULL_PATTERN_OR_SEARCH_STR
XJ073 S Connectivity STATEMENT_SEVERITY BLOB_ACCESSED_AFTER_COMMIT
XJ074 S Connectivity STATEMENT_SEVERITY INVALID_QUERYTIMEOUT_VALUE
XJ076 S Connectivity STATEMENT_SEVERITY BLOB_POSITION_TOO_LARGE
XJ077 S Connectivity STATEMENT_SEVERITY BLOB_UNABLE_TO_READ_PATTERN
XJ078 S Connectivity STATEMENT_SEVERITY BLOB_INVALID_OFFSET
XJ079 S Connectivity STATEMENT_SEVERITY BLOB_LENGTH_TOO_LONG
XJ080 S Connectivity STATEMENT_SEVERITY LANG_NUM_PARAMS_INCORRECT
XJ081 S Connectivity STATEMENT_SEVERITY INVALID_API_PARAMETER
XJ081 C Connectivity SESSION_SEVERITY CONFLICTING_RESTORE_ATTRIBUTES
XJ082 U Connectivity UNKNOWN LOB_AS_METHOD_ARGUMENT_OR_RECEIVER
XJ083 U Connectivity UNKNOWN UPDATABLE_RESULTSET_API_DISALLOWED
XJ084 U Connectivity UNKNOWN COLUMN_NOT_FROM_BASE_TABLE
XJ085 S Connectivity STATEMENT_SEVERITY STREAM_EOF
XJ086 S Connectivity STATEMENT_SEVERITY CURSOR_NOT_POSITIONED_ON_INSERT_ROW
XJ087 S Connectivity STATEMENT_SEVERITY POS_AND_LENGTH_GREATER_THAN_LOB
XJ088 S Connectivity STATEMENT_SEVERITY WASNULL_INVALID
XJ090 S Connectivity STATEMENT_SEVERITY CALENDAR_IS_NULL
XJ091 S Connectivity STATEMENT_SEVERITY PARAM_NOT_OUT_OR_INOUT
XJ093 S Connectivity STATEMENT_SEVERITY BLOB_TOO_LARGE_FOR_CLIENT
XJ094 S Connectivity STATEMENT_SEVERITY OBJECT_ALREADY_CLOSED
XJ095 S Connectivity STATEMENT_SEVERITY ERROR_PRIVILEGED_ACTION
XJ096 S Connectivity STATEMENT_SEVERITY MISSING_RESOURCE_BUNDLE
XJ097 S Connectivity STATEMENT_SEVERITY SAVEPOINT_NOT_CREATED_BY_CONNECTION
XJ098 S Connectivity STATEMENT_SEVERITY BAD_AUTO_GEN_KEY_VALUE
XJ099 S Connectivity STATEMENT_SEVERITY READER_UNDER_RUN
XJ100 S Connectivity STATEMENT_SEVERITY REGOUTPARAM_SCALE_DOESNT_MATCH_SETTER
XJ103 S Connectivity STATEMENT_SEVERITY TABLE_NAME_CANNOT_BE_NULL
XJ104 S Connectivity STATEMENT_SEVERITY SHARED_KEY_LENGTH_ERROR
XJ105 S Connectivity STATEMENT_SEVERITY DES_KEY_HAS_WRONG_LENGTH
XJ106 S Connectivity STATEMENT_SEVERITY CRYPTO_NO_SUCH_PADDING
XJ107 S Connectivity STATEMENT_SEVERITY CRYPTO_BAD_PADDING
XJ108 S Connectivity STATEMENT_SEVERITY CRYPTO_ILLEGAL_BLOCK_SIZE
XJ110 S Connectivity STATEMENT_SEVERITY PRIMARY_TABLE_NAME_IS_NULL
XJ111 S Connectivity STATEMENT_SEVERITY FOREIGN_TABLE_NAME_IS_NULL
XJ112 S Connectivity STATEMENT_SEVERITY SECURITY_EXCEPTION_ENCOUNTERED
XJ113 S Connectivity STATEMENT_SEVERITY UNABLE_TO_OPEN_FILE
XJ114 S Connectivity STATEMENT_SEVERITY CURSOR_INVALID_CURSOR_NAME
XJ115 S Connectivity STATEMENT_SEVERITY UNABLE_TO_OPEN_RESULTSET_WITH_REQUESTED_HOLDABILTY
XJ116 S Connectivity STATEMENT_SEVERITY TOO_MANY_COMMANDS_FOR_BATCH
XJ117 S Connectivity STATEMENT_SEVERITY CANNOT_BATCH_QUERIES
XJ118 S Connectivity STATEMENT_SEVERITY QUERY_BATCH_ON_NON_QUERY_STATEMENT
XJ121 S Connectivity STATEMENT_SEVERITY CURSOR_INVALID_OPERATION_AT_CURRENT_POSITION
XJ122 S Connectivity STATEMENT_SEVERITY CURSOR_NO_UPDATE_CALLS_ON_CURRENT_ROW
XJ123 S Connectivity STATEMENT_SEVERITY CURSOR_NOT_ON_CURRENT_OR_INSERT_ROW
XJ124 S Connectivity STATEMENT_SEVERITY CURSOR_COLUMN_NOT_UPDATABLE
XJ125 S Connectivity STATEMENT_SEVERITY CURSOR_MUST_BE_SCROLLABLE
XJ126 S Connectivity STATEMENT_SEVERITY CURSOR_INVALID_FOR_SENSITIVE_DYNAMIC
XJ128 S Connectivity STATEMENT_SEVERITY UNABLE_TO_UNWRAP
XJ200 S Connectivity STATEMENT_SEVERITY EXCEEDED_MAX_SECTIONS
XJ202 S Connectivity STATEMENT_SEVERITY CURSOR_INVALID_NAME
XJ203 S Connectivity STATEMENT_SEVERITY CURSOR_DUPLICATE_NAME
XJ204 S Connectivity STATEMENT_SEVERITY UNABLE_TO_OPEN_RS_WITH_REQUESTED_HOLDABILITY
XJ206 S Connectivity STATEMENT_SEVERITY NO_TOKENS_IN_SQL_TEXT
XJ207 S Connectivity STATEMENT_SEVERITY CANT_USE_EXEC_QUERY_FOR_UPDATE
XJ208 S Connectivity STATEMENT_SEVERITY BATCH_NON_ATOMIC_FAILURE
XJ209 S Connectivity STATEMENT_SEVERITY STORED_PROC_NOT_INSTALLED
XJ210 S Connectivity STATEMENT_SEVERITY STORED_PROC_LOAD_MODULE_NOT_FOUND
XJ211 S Connectivity STATEMENT_SEVERITY BATCH_CHAIN_BREAKING_EXCEPTION
XJ212 S Connectivity STATEMENT_SEVERITY INVALID_ATTRIBUTE_SYNTAX
XJ213 C Connectivity SESSION_SEVERITY TRACELEVEL_FORMAT_INVALID
XJ214 S Connectivity STATEMENT_SEVERITY IO_ERROR_UPON_LOB_FREE
XJ215 S Connectivity STATEMENT_SEVERITY LOB_OBJECT_INVALID
XJ216 S Connectivity STATEMENT_SEVERITY LOB_OBJECT_LENGTH_UNKNOWN_YET
XJ217 S Connectivity STATEMENT_SEVERITY LOB_LOCATOR_INVALID
XK000 S Security XK… STATEMENT_SEVERITY POLICY_NOT_RELOADED
XML00 Connectivity STATEMENT_SEVERITY LANG_MISSING_XML_CLASSES
XML01 Connectivity STATEMENT_SEVERITY LANG_UNEXPECTED_XML_EXCEPTION
XN001 S Connectivity STATEMENT_SEVERITY NET_CONNECTION_RESET_NOT_ALLOWED_IN_UNIT_OF_WORK
XN002 U Connectivity UNKNOWN NET_SECKTKN_NOT_RETURNED
XN008 S Connectivity STATEMENT_SEVERITY NET_QUERY_PROCESSING_TERMINATED
XN009 S Connectivity STATEMENT_SEVERITY NET_ERROR_GETTING_BLOB_LENGTH
XN010 S Connectivity STATEMENT_SEVERITY NET_NULL_PROCEDURE_NAME
XN011 S Connectivity STATEMENT_SEVERITY NET_PROCEDURE_NAME_LENGTH_OUT_OF_RANGE
XN012 S Connectivity STATEMENT_SEVERITY NET_WRONG_XA_VERSION
XN013 S Connectivity STATEMENT_SEVERITY NET_INVALID_SCROLL_ORIENTATION
XN014 S Connectivity STATEMENT_SEVERITY NET_EXCEPTION_ON_READ
XN015 S Connectivity STATEMENT_SEVERITY NET_INPUTSTREAM_LENGTH_TOO_SMALL
XN016 S Connectivity STATEMENT_SEVERITY NET_EXCEPTION_ON_STREAMLEN_VERIFICATION
XN017 S Connectivity STATEMENT_SEVERITY NET_PREMATURE_EOS
XN018 S Connectivity STATEMENT_SEVERITY NET_READER_LENGTH_TOO_SMALL
XN019 S Connectivity STATEMENT_SEVERITY NET_XARETVAL_ERROR
XN020 S Connectivity STATEMENT_SEVERITY NET_MARSHALLING_UDT_ERROR
XN021 S Connectivity STATEMENT_SEVERITY NET_UDT_COERCION_ERROR
XRE00 Replication XRExx STATEMENT_SEVERITY LOGMODULE_DOES_NOT_SUPPORT_REPLICATION
XRE01 Replication XRExx STATEMENT_SEVERITY REPLICATION_LOG_CORRUPTED
XRE02 Replication XRExx STATEMENT_SEVERITY REPLICATION_MASTER_SLAVE_VERSION_MISMATCH
XRE03 Replication XRExx STATEMENT_SEVERITY REPLICATION_UNEXPECTED_EXCEPTION
XRE04 C.1 Replication XRExx SESSION_SEVERITY REPLICATION_CONNECTION_EXCEPTION
XRE04 C.2 Replication XRExx SESSION_SEVERITY REPLICATION_CONNECTION_LOST
XRE05 C Replication XRExx SESSION_SEVERITY REPLICATION_LOG_OUT_OF_SYNCH
XRE06 Replication XRExx SESSION_SEVERITY REPLICATION_MASTER_TIMED_OUT
XRE07 Replication XRExx SESSION_SEVERITY REPLICATION_NOT_IN_MASTER_MODE
XRE08 Replication XRExx SESSION_SEVERITY REPLICATION_SLAVE_STARTED_OK
XRE09 C Replication XRExx SESSION_SEVERITY CANNOT_START_SLAVE_ALREADY_BOOTED
XRE10 Replication XRExx SESSION_SEVERITY REPLICATION_CONFLICTING_ATTRIBUTES
XRE11 C Replication XRExx SESSION_SEVERITY REPLICATION_DB_NOT_BOOTED
XRE12 Replication XRExx SESSION_SEVERITY REPLICATION_UNEXPECTED_MESSAGEID
XRE20 D Replication XRExx DATABASE_SEVERITY REPLICATION_FAILOVER_SUCCESSFUL
XRE21 C Replication XRExx SESSION_SEVERITY REPLICATION_FAILOVER_UNSUCCESSFUL
XRE22 C Replication XRExx SESSION_SEVERITY REPLICATION_MASTER_ALREADY_BOOTED
XRE23 Replication XRExx SESSION_SEVERITY REPLICATION_UNLOGGED_OPERATIONS_IN_PROGRESS
XRE40 Replication XRExx SESSION_SEVERITY REPLICATION_NOT_IN_SLAVE_MODE
XRE41 C Replication XRExx SESSION_SEVERITY SLAVE_OPERATION_DENIED_WHILE_CONNECTED
XRE42 C Replication XRExx SESSION_SEVERITY REPLICATION_SLAVE_SHUTDOWN_OK
XRE43 Replication XRExx SESSION_SEVERITY REPLICATION_STOPSLAVE_NOT_INITIATED
XSAI2 S Store – access.protocol.Interface statement exceptions STATEMENT_SEVERITY STORE_CONGLOMERATE_DOES_NOT_EXIST
XSAI3 S Store – access.protocol.Interface statement exceptions STATEMENT_SEVERITY STORE_FEATURE_NOT_IMPLEMENTED
XSAJ0 U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_SCAN_TYPE
XSAJ1 U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_NUM_PAGES_VISITED
XSAJ2 U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_NUM_ROWS_VISITED
XSAJ3 U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_NUM_DELETED_ROWS_VISITED
XSAJ4 U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_NUM_ROWS_QUALIFIED
XSAJ5 U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_NUM_COLUMNS_FETCHED
XSAJ6 U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_COLUMNS_FETCHED_BIT_SET
XSAJ7 U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_TREE_HEIGHT
XSAJ8 U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_SORT_TYPE
XSAJA U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_NUM_ROWS_INPUT
XSAJB U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_NUM_ROWS_OUTPUT
XSAJC U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_NUM_MERGE_RUNS
XSAJD U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_MERGE_RUNS_SIZE
XSAJE U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_ALL
XSAJF U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_BTREE
XSAJG U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_HEAP
XSAJH U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_SORT
XSAJI U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_EXTERNAL
XSAJJ U Store – access.protocol.Interface RunTimeStatistics propert UNKNOWN STORE_RTS_INTERNAL
XSAM0 S Store – AccessManager STATEMENT_SEVERITY AM_NO_FACTORY_FOR_IMPLEMENTATION
XSAM2 S Store – AccessManager STATEMENT_SEVERITY AM_NO_SUCH_CONGLOMERATE_DROP
XSAM3 S Store – AccessManager STATEMENT_SEVERITY AM_NO_SUCH_CONGLOMERATE_TYPE
XSAM4 S Store – AccessManager STATEMENT_SEVERITY AM_NO_SUCH_SORT
XSAM5 S Store – AccessManager STATEMENT_SEVERITY AM_SCAN_NOT_POSITIONED
XSAM6 S Store – AccessManager STATEMENT_SEVERITY AM_RECORD_NOT_FOUND
XSAS0 S Store – Sort STATEMENT_SEVERITY SORT_IMPROPER_SCAN_METHOD
XSAS1 S Store – Sort STATEMENT_SEVERITY SORT_SCAN_NOT_POSITIONED
XSAS3 S Store – Sort STATEMENT_SEVERITY SORT_TYPE_MISMATCH
XSAS6 S Store – Sort STATEMENT_SEVERITY SORT_COULD_NOT_INIT
XSAX0 S Store – access.protocol.XA statement exceptions STATEMENT_SEVERITY STORE_XA_PROTOCOL_VIOLATION
XSAX0 Store – access.protocol.XA statement exceptions STATEMENT_SEVERITY STORE_XA_PROTOCOL_VIOLATION_SQLSTATE
XSAX1 S Store – access.protocol.XA statement exceptions STATEMENT_SEVERITY STORE_XA_XAER_DUPID
XSAX1 Store – access.protocol.XA statement exceptions STATEMENT_SEVERITY STORE_XA_XAER_DUPID_SQLSTATE
XSCB0 S Store – BTree STATEMENT_SEVERITY BTREE_CANT_CREATE_CONTAINER
XSCB1 S Store – BTree STATEMENT_SEVERITY BTREE_CONTAINER_NOT_FOUND
XSCB2 S Store – BTree STATEMENT_SEVERITY BTREE_PROPERTY_NOT_FOUND
XSCB3 S Store – BTree STATEMENT_SEVERITY BTREE_UNIMPLEMENTED_FEATURE
XSCB4 S Store – BTree STATEMENT_SEVERITY BTREE_SCAN_NOT_POSITIONED
XSCB5 S Store – BTree STATEMENT_SEVERITY BTREE_ROW_NOT_FOUND_DURING_UNDO
XSCB6 S Store – BTree STATEMENT_SEVERITY BTREE_NO_SPACE_FOR_KEY
XSCB7 S Store – BTree STATEMENT_SEVERITY BTREE_SCAN_INTERNAL_ERROR
XSCB8 S Store – BTree STATEMENT_SEVERITY BTREE_IS_CLOSED
XSCB9 S Store – BTree STATEMENT_SEVERITY BTREE_ABORT_THROUGH_TRACE
XSCG0 S Store – Conglomerate STATEMENT_SEVERITY CONGLOMERATE_TEMPLATE_CREATE_ERROR
XSCH0 S Store – Heap STATEMENT_SEVERITY HEAP_CANT_CREATE_CONTAINER
XSCH1 S Store – Heap STATEMENT_SEVERITY HEAP_CONTAINER_NOT_FOUND
XSCH4 S Store – Heap STATEMENT_SEVERITY HEAP_COULD_NOT_CREATE_CONGLOMERATE
XSCH5 S Store – Heap STATEMENT_SEVERITY HEAP_TEMPLATE_MISMATCH
XSCH6 S Store – Heap STATEMENT_SEVERITY HEAP_IS_CLOSED
XSCH7 S Store – Heap STATEMENT_SEVERITY HEAP_SCAN_NOT_POSITIONED
XSCH8 S Store – Heap STATEMENT_SEVERITY HEAP_UNIMPLEMENTED_FEATURE
XSDA1 S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_SLOT_NOT_ON_PAGE
XSDA2 S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_UPDATE_DELETED_RECORD
XSDA3 S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_NO_SPACE_FOR_RECORD
XSDA4 S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_UNEXPECTED_EXCEPTION
XSDA5 S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_UNDELETE_RECORD
XSDA6 S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_NULL_STORABLE_COLUMN
XSDA7 S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_STORABLE_READ_MISMATCH
XSDA8 S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_STORABLE_READ_EXCEPTION
XSDA9 S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_STORABLE_READ_MISSING_CLASS
XSDAA S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_TIME_STAMP_ILLEGAL
XSDAB S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_TIME_STAMP_NULL
XSDAC S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_DIFFERENT_CONTAINER
XSDAD S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_NO_ROW_COPIED
XSDAE S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_CANNOT_MAKE_RECORD_HANDLE
XSDAF S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_INVALID_RECORD_HANDLE
XSDAG S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_ALLOC_NTT_CANT_OPEN
XSDAI S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_CANNOT_GET_DEALLOC_LOCK
XSDAJ S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_STORABLE_WRITE_EXCEPTION
XSDAK S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_WRONG_PAGE_FOR_HANDLE
XSDAL S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_UNEXPECTED_OVERFLOW_PAGE
XSDAM S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_SQLDATA_READ_INSTANTIATION_EXCEPTION
XSDAN S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_SQLDATA_READ_ILLEGAL_ACCESS_EXCEPTION
XSDAO S RawStore – Data.Generic statement exceptions STATEMENT_SEVERITY DATA_DOUBLE_LATCH_INTERNAL_ERROR
XSDB0 D RawStore – Data.Generic transaction exceptions DATABASE_SEVERITY DATA_CORRUPT_PAGE
XSDB1 D RawStore – Data.Generic transaction exceptions DATABASE_SEVERITY DATA_UNKNOWN_PAGE_FORMAT
XSDB2 D RawStore – Data.Generic transaction exceptions DATABASE_SEVERITY DATA_UNKNOWN_CONTAINER_FORMAT
XSDB3 D RawStore – Data.Generic transaction exceptions DATABASE_SEVERITY DATA_CHANGING_CONTAINER_INFO
XSDB4 D RawStore – Data.Generic transaction exceptions DATABASE_SEVERITY DATA_MISSING_LOG
XSDB5 D RawStore – Data.Generic transaction exceptions DATABASE_SEVERITY DATA_MISSING_PAGE
XSDB6 D RawStore – Data.Generic transaction exceptions DATABASE_SEVERITY DATA_MULTIPLE_JBMS_ON_DB
XSDB7 D RawStore – Data.Generic transaction exceptions DATABASE_SEVERITY DATA_MULTIPLE_JBMS_WARNING
XSDB8 D RawStore – Data.Generic transaction exceptions DATABASE_SEVERITY DATA_MULTIPLE_JBMS_FORCE_LOCK
XSDB9 D RawStore – Data.Generic transaction exceptions DATABASE_SEVERITY DATA_CORRUPT_STREAM_CONTAINER
XSDBA D RawStore – Data.Generic transaction exceptions DATABASE_SEVERITY DATA_OBJECT_ALLOCATION_FAILED
XSDBB D RawStore – Data.Generic transaction exceptions DATABASE_SEVERITY DATA_UNKNOWN_PAGE_FORMAT_2
XSDBC D RawStore – Data.Generic transaction exceptions DATABASE_SEVERITY DATA_BAD_CONTAINERINFO_WRITE
XSDF0 S RawStore – Data.Filesystem statement exceptions STATEMENT_SEVERITY FILE_EXISTS
XSDF1 S RawStore – Data.Filesystem statement exceptions STATEMENT_SEVERITY FILE_CREATE
XSDF2 S RawStore – Data.Filesystem statement exceptions STATEMENT_SEVERITY FILE_CREATE_NO_CLEANUP
XSDF3 S RawStore – Data.Filesystem statement exceptions STATEMENT_SEVERITY FILE_CANNOT_CREATE_SEGMENT
XSDF4 S RawStore – Data.Filesystem statement exceptions STATEMENT_SEVERITY FILE_CANNOT_REMOVE_FILE
XSDF6 S RawStore – Data.Filesystem statement exceptions STATEMENT_SEVERITY FILE_NO_ALLOC_PAGE
XSDF7 S RawStore – Data.Filesystem statement exceptions STATEMENT_SEVERITY FILE_NEW_PAGE_NOT_LATCHED
XSDF8 S RawStore – Data.Filesystem statement exceptions STATEMENT_SEVERITY FILE_REUSE_PAGE_NOT_FOUND
XSDFB S RawStore – Data.Filesystem statement exceptions STATEMENT_SEVERITY FILE_READ_ONLY
XSDFD S RawStore – Data.Filesystem statement exceptions STATEMENT_SEVERITY FILE_IO_GARBLED
XSDFF S RawStore – Data.Filesystem statement exceptions STATEMENT_SEVERITY FILE_UNEXPECTED_EXCEPTION
XSDFH S RawStore – Data.Filesystem statement exceptions STATEMENT_SEVERITY BACKUP_FILE_IO_ERROR
XSDFI S RawStore – Data.Filesystem statement exceptions STATEMENT_SEVERITY FILE_NEW_PAGE_DURING_RECOVERY
XSDG0 D RawStore – Data.FSLDemo transaction exceptionsRawStore – Da DATABASE_SEVERITY FILE_READ_PAGE_EXCEPTION
XSDG1 D RawStore – Data.FSLDemo transaction exceptionsRawStore – Da DATABASE_SEVERITY FILE_WRITE_PAGE_EXCEPTION
XSDG2 D RawStore – Data.FSLDemo transaction exceptionsRawStore – Da DATABASE_SEVERITY FILE_BAD_CHECKSUM
XSDG3 D RawStore – Data.FSLDemo transaction exceptionsRawStore – Da DATABASE_SEVERITY FILE_CONTAINER_EXCEPTION
XSDG5 D RawStore – Data.FSLDemo transaction exceptionsRawStore – Da DATABASE_SEVERITY FILE_DATABASE_NOT_IN_CREATE
XSDG6 D RawStore – Data.FSLDemo transaction exceptionsRawStore – Da DATABASE_SEVERITY DATA_DIRECTORY_NOT_FOUND_IN_BACKUP
XSDG7 D RawStore – Data.FSLDemo transaction exceptionsRawStore – Da DATABASE_SEVERITY UNABLE_TO_REMOVE_DATA_DIRECTORY
XSDG8 D RawStore – Data.FSLDemo transaction exceptionsRawStore – Da DATABASE_SEVERITY UNABLE_TO_COPY_DATA_DIRECTORY
XSDG9 D RawStore – Data.FSLDemo transaction exceptionsRawStore – Da DATABASE_SEVERITY FILE_IO_INTERRUPTED
XSLA0 D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_CANNOT_FLUSH
XSLA1 D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_DO_ME_FAIL
XSLA2 D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_IO_ERROR
XSLA3 D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_CORRUPTED
XSLA4 D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_FULL
XSLA5 D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_READ_LOG_FOR_UNDO
XSLA6 D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_RECOVERY_FAILED
XSLA7 D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_REDO_FAILED
XSLA8 D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_UNDO_FAILED
XSLAA D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_STORE_CORRUPT
XSLAB D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_FILE_NOT_FOUND
XSLAC D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_INCOMPATIBLE_FORMAT
XSLAD D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_RECORD_CORRUPTED
XSLAE D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_CONTROL_FILE
XSLAF D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_READ_ONLY_DB_NEEDS_UNDO
XSLAH D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_READ_ONLY_DB_UPDATE
XSLAI D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_CANNOT_LOG_CHECKPOINT
XSLAJ D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_NULL
XSLAK D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_EXCEED_MAX_LOG_FILE_NUMBER
XSLAL D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_EXCEED_MAX_LOG_FILE_SIZE
XSLAM D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_CANNOT_VERIFY_LOG_FORMAT
XSLAN D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_INCOMPATIBLE_VERSION
XSLAO D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_UNEXPECTED_RECOVERY_PROBLEM
XSLAP D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_CANNOT_UPGRADE_BETA
XSLAQ D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_SEGMENT_NOT_EXIST
XSLAR D RawStore – Log.Generic database exceptions DATABASE_SEVERITY UNABLE_TO_COPY_LOG_FILE
XSLAS D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_DIRECTORY_NOT_FOUND_IN_BACKUP
XSLAT D RawStore – Log.Generic database exceptions DATABASE_SEVERITY LOG_SEGMENT_EXIST
XSLB1 S RawStore – Log.Generic statement exceptions STATEMENT_SEVERITY LOG_WRITE_LOG_RECORD
XSLB2 S RawStore – Log.Generic statement exceptions STATEMENT_SEVERITY LOG_BUFFER_FULL
XSLB4 S RawStore – Log.Generic statement exceptions STATEMENT_SEVERITY LOG_TRUNC_LWM_NULL
XSLB5 S RawStore – Log.Generic statement exceptions STATEMENT_SEVERITY LOG_TRUNC_LWM_ILLEGAL
XSLB6 S RawStore – Log.Generic statement exceptions STATEMENT_SEVERITY LOG_ZERO_LENGTH_LOG_RECORD
XSLB8 S RawStore – Log.Generic statement exceptions STATEMENT_SEVERITY LOG_RESET_BEYOND_SCAN_LIMIT
XSLB9 S RawStore – Log.Generic statement exceptions STATEMENT_SEVERITY LOG_FACTORY_STOPPED
XSRS0 S RawStoreRawStore – protocol.Interface statement exceptions STATEMENT_SEVERITY RAWSTORE_NESTED_FREEZE
XSRS1 S RawStoreRawStore – protocol.Interface statement exceptions STATEMENT_SEVERITY RAWSTORE_CANNOT_BACKUP_TO_NONDIRECTORY
XSRS4 S RawStoreRawStore – protocol.Interface statement exceptions STATEMENT_SEVERITY RAWSTORE_ERROR_RENAMING_FILE
XSRS5 S RawStoreRawStore – protocol.Interface statement exceptions STATEMENT_SEVERITY RAWSTORE_ERROR_COPYING_FILE
XSRS6 S RawStoreRawStore – protocol.Interface statement exceptions STATEMENT_SEVERITY RAWSTORE_CANNOT_CREATE_BACKUP_DIRECTORY
XSRS7 S RawStoreRawStore – protocol.Interface statement exceptions STATEMENT_SEVERITY RAWSTORE_UNEXPECTED_EXCEPTION
XSRS8 S RawStoreRawStore – protocol.Interface statement exceptions STATEMENT_SEVERITY RAWSTORE_CANNOT_CHANGE_LOGDEVICE
XSRS9 S RawStoreRawStore – protocol.Interface statement exceptions STATEMENT_SEVERITY RAWSTORE_RECORD_VANISHED
XSRSA S RawStoreRawStore – protocol.Interface statement exceptions STATEMENT_SEVERITY BACKUP_BLOCKING_OPERATIONS_IN_PROGRESS
XSRSB S RawStoreRawStore – protocol.Interface statement exceptions STATEMENT_SEVERITY BACKUP_OPERATIONS_NOT_ALLOWED
XSRSC S RawStoreRawStore – protocol.Interface statement exceptions STATEMENT_SEVERITY RAWSTORE_CANNOT_BACKUP_INTO_DATABASE_DIRECTORY
XSTA2 S RawStore – Transactions.Basic statement exceptions STATEMENT_SEVERITY XACT_TRANSACTION_ACTIVE
XSTB0 M RawStore – Transactions.Basic system exceptions SYSTEM_SEVERITY XACT_ABORT_EXCEPTION
XSTB2 M RawStore – Transactions.Basic system exceptions SYSTEM_SEVERITY XACT_CANNOT_LOG_CHANGE
XSTB3 M RawStore – Transactions.Basic system exceptions SYSTEM_SEVERITY XACT_CANNOT_ABORT_NULL_LOGGER
XSTB5 M RawStore – Transactions.Basic system exceptions SYSTEM_SEVERITY XACT_CREATE_NO_LOG
XSTB6 M RawStore – Transactions.Basic system exceptions SYSTEM_SEVERITY XACT_TRANSACTION_TABLE_IN_USE
XXXXX C.6 Connectivity SESSION_SEVERITY NORMAL_CLOSE
close C.1 Connectivity SESSION_SEVERITY CLOSE_REQUEST
rwupd Connectivity STATEMENT_SEVERITY ROW_UPDATED

TenFourFox (Mozilla Firefox 10.01b) for Apple PPC iMac / Macbook G3, G4 and G5

Posted by jnorthr on

3D CSS transforms and properties arrive as do transformable objects, so the objects we see moving are not images, but canvas transforms ! Multithreading now works and TenFourFox supports that on multiprocessor Power Macs, so marginal resource starved G4′s etc should be nippy !
Look here for details : http://tenfourfox.blogspot.com/2012/01/100b1-stable-available.html

In the meantime, release notes and architecture builds:

Thought provoking letter sent to a bank by an 86 year old lady

Posted by jnorthr on

Shown below is an actual letter that was sent to a bank by an 86 year old woman. The bank manager thought it amusing enough to have it published in the New York Times :

Dear Sir:

I am writing to thank you for bouncing my check with which I endeavored to pay my plumber last month.

By my calculations, three nanoseconds must have elapsed between his presenting the check and the arrival in my account of the funds needed to honor it…  I refer, of course, to the automatic monthly deposit of my entire pension, an arrangement which, I admit, has been in place for only eight years.

 

You are to be commended for seizing that brief window of opportunity, and also for debiting my account $30 by way of penalty for the inconvenience caused to your bank.

My thankfulness springs from the manner in which this incident has caused me to rethink my errant financial ways.  I noticed that whereas I personally answer your telephone calls and letters, but when I try to contact you, I am confronted by the impersonal, overcharging, pre-recorded, faceless entity which your bank has become.

>From now on, I, like you, choose only to deal with a flesh-and-blood person.

My mortgage and loan repayments will therefore and hereafter no longer be automatic, but will arrive at your bank, by check, addressed personally and confidentially to an employee at your bank whom you must nominate.

Be aware that it is an OFFENSE under the Postal Act for any other person to open such an envelope.

Please find attached an Application Contact which I require your chosen employee to complete.

I am sorry it runs to eight pages, but in order that I know as much about him or her as your bank knows about me, there is no alternative.

Please note that all copies of his or her medical history must be countersigned by a Notary Public, and the mandatory details of his/her financial situation (income, debts, assets and liabilities) must be accompanied by documented proof.

In due course, at MY convenience, I will issue your employee with a PIN number which he/she must quote in dealings with me.


I regret that it cannot be shorter than 28 digits but, again, I have modeled it on the number of button presses required of me to access my account balance on your phone bank service.

As they say, imitation is the sincerest form of flattery.

Let me level the playing field even further. When you call me, press buttons as follows:

IMMEDIATELY AFTER DIALLING, PRESS THE STAR (*) BUTTON FOR ENGLISH

#1. To make an appointment to see me

#2. To query a missing payment.

# 3. To transfer the call to my living room in case I am there.

#4 To transfer the call to my bedroom in case I am sleeping

#5. To transfer the call to my toilet in case I am attending to nature.

#6. To transfer the call to my mobile phone if I am not at home.

#7. To leave a message on my computer, a password to access my computer is required. Password will be communicated to you at a later date to that Authorized Contact mentioned earlier.

#8. To return to the main menu and to listen to options 1 through 7.

#9. To make a general complaint or inquiry. The contact will then be put on hold, pending the attention of my automated answering service.

#10. This is a second reminder to press* for English.


While this may, on occasion, involve a lengthy wait, uplifting music will play for the duration of the call.

Regrettably, but again following your example, I must also levy an establishment fee to cover the setting up of this new arrangement.

May I wish you a happy, if ever so slightly less prosperous New Year?

Your Humble Client

And remember: Don’t make old People mad. We don’t like being old in the first place, so it doesn’t take much to piss us off and we have more time on our hands than you do

New Domain Purchase from Godaddy.com

Posted by jnorthr on

Did a recent purchase of a new domain name of http://www.domail.info from godaddy.com and they provide one email address for free. Was lucky enough to capture this domain name for the relatively new .info suffix for the amazing sum of €1.62 for one year. So thought i’d try this one for a year and if it works, can renew it later.

The email address can be any choice you like. For my test purposes, i created a single email address of forwardto and therefore all mail traffic for this new site goes into and from forwardto@domail.info and this choice allowed godaddy to set up the domain name server ( DNS ) control records. These control records govern where/when/how various programs in the wild can talk to a domain website.

After using paypal to complete the purchase, the new domain became active with a few minutes. Godaddy also offered to construct a place holder page for my new website until i have time to build one myself. I tend to choose my new web site template from http://www.freecsstemplates.org/ and will do so again.

What i did want to note is that since we are in europe, the dns control records are not setup correctly for the C and MX record types. Instructions on how to fix MX records to do that can be found here. These values typically hold the american choices.

If you read this http://help.godaddy.com/article/4228 you will find that both the C and MX records need to be corrected to point to the european name and dns servers, if you are not in the american zones.

If you need to check the email account for your new domain, you should log on to your godaddy account. Your display shouuld look like this, so to check your mail, click the EMAIL tab and at the bottom of that is the clickable link to maintain mail for your new domain.

Godaddy menu to review website emails

Godaddy menu to review website emails

Code Fragment Syntax Highlighter – Part Two

Posted by jnorthr on

Read part one here : Syntax Highlighter Part One

Ok, here is a screen snippet of what our test2.html page looks like when rendered by a browser. Notice each color fragment has it’s code keywords colored according to the language of the fragment. Also note that the ‘Midnight’ theme is used for all code fragment displays. Click to grow.

Code Fragment Test Page

Code Fragment Test Page

Image of Example Folder Layout

Image of Example Folder Layout

Here is my test folder with a ‘styles’ sub-folder for the test2.html file. The HTML for our example test page follows. As Alex explains in his installation page, there are two approaches to markup of code fragments :

  1. Use the html <pre> tag
  2. Use the html <script> tag witha CDATA extension

Again, there are several javascript files we need to declare in our test2.html page. A core j/s file with overall logic plus three j/s brushes for the three code fragments, each in a different programming language.

For overall color control, five CSS files declare 1) the core colors 2) a theme default if no override theme has been chosen and 3) in this case we do use an overriding theme called ‘Midnight’. There are several other themes you can try.

Points to note in the following html document – both styles of highlighting are used. The <pre> element needs a class declaration for the brush (programming language) contained within the fragment. You can see class=’brush: groovy’ in the first fragment to color groovy keywords. The <script type=”syntaxhighlighter” class=”brush: js”><![CDATA[ declaration is the alternative approach to present code fragments. We can place any < or > characters within the CDATA of a script declaration otherwise if we use the pre approach, we need to manually change each < and > for their &lt; and &gt; equivalents.

 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html class="no-js">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<link rel="stylesheet" href="./styles/shCore.css" type="text/css" />
<link rel="stylesheet" href="./styles/shCoreDefault.css" type="text/css" />
<link rel="stylesheet" href="./styles/shCoreMidnight.css" type="text/css" />
<link rel="stylesheet" href="./styles/shThemeDefault.css" type="text/css" />
<link rel="stylesheet" href="./styles/shThemeMidnight.css" type="text/css" />

<title>Technology Page To Check Muliple Column text Features</title>
<script src='https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js' type='text/javascript'></script>
<script type="text/javascript" src="./scripts/shCore.js"></script>
<script type="text/javascript" src="./scripts/shBrushJScript.js"></script>
<script type="text/javascript" src="./scripts/shBrushJava.js"></script>
<script type="text/javascript" src="./scripts/shBrushGroovy.js"></script>
</head>
<body >
<h2>Code Examples Using Midnight Theme</h2>
<div><h3>Groovy Code Fragment</h3>
<p>
<pre class='brush: groovy'>
println 'Hi kids'
def cats=[]
cats.each{cat -> println cat}
</pre>
</p></div>
<h3>Javascript Code Fragment</h3>
<p>
<script type=”syntaxhighlighter” class=”brush: js”><![CDATA[
var setArray = function(elems) {
this.length = 0;
push.apply(this, elems);
return this;
}
]]></script>
</p>

<h3>Java Code Fragment</h3>

<script type=”syntaxhighlighter” class=”brush: java”><![CDATA[
// require(url:'https://scripting.dev.java.net', jar:'groovy-engine.jar')
// this runs in groovy 1.8 using java 1.6 to run the script engine

import javax.script.ScriptEngine;
import javax.script.ScriptEngineManager;

public class CalcMain {
public static void main(String[] args) throws Exception {
System.out.println(“Starting …”);

ScriptEngineManager factory = new ScriptEngineManager();
ScriptEngine engine = factory.getEngineByName(“groovy”);

// basic example
System.out.println(engine.eval(“(1..10).sum()”));

// example showing scripting variables
engine.put(“first”, “HELLO”);
engine.put(“second”, “world”);
System.out.println(engine.eval(“first.toLowerCase() + second.toUpperCase()”));
System.out.println(“Ending …”);
}
}
]]></script>
</p>

<script type=”text/javascript”>
$(document).ready(function()
{
SyntaxHighlighter.highlight();
});
</script>
</body>
</html>

Finally, look at the bottom of the html to see how we invoke syntax highlighter. We can invoke it only after the page has loaded completely. Here is a nice use of JQuery as it has a convenient function of $(document).ready(); which is called upon page load completion. It's a nice place to insert our call to fire up the highlighter engine. Copy the code above into a textfile named test2.html and then use your favorite browser to open this file. If you've done it all correctly, you'll be rewarded with a display like the screen snippet shown at the top of this post.

It look quite a while to figure out all these bits and pieces. The website documentation is sparse hence a steep lerning curve. Hope this helps you a bit. :)