The Firebird SQLCODE error codes do not correlate with the standards-compliant codes. SQLCODE has been used for many years and should be considered as deprecated now. Support for SQLCODE is likely to be dropped in a future version.

    This table provides the error codes and message texts for the context variables.

    The structure of an SQLSTATE error code is five characters comprising the SQL error class (2 characters) and the SQL subclass (3 characters).

    Table 184. SQLSTATE Codes and Message Texts
    SQLSTATEMapped Message

    SQLCLASS 00 (Success)

    00000

    Success

    SQLCLASS 01 (Warning)

    01000

    General warning

    01001

    Cursor operation conflict

    01002

    Disconnect error

    01003

    NULL value eliminated in set function

    01004

    String data, right-truncated

    01005

    Insufficient item descriptor areas

    01006

    Privilege not revoked

    01007

    Privilege not granted

    01008

    Implicit zero-bit padding

    01100

    Statement reset to unprepared

    01101

    Ongoing transaction has been committed

    01102

    Ongoing transaction has been rolled back

    SQLCLASS 02 (No Data)

    02000

    No data found or no rows affected

    SQLCLASS 07 (Dynamic SQL error)

    07000

    Dynamic SQL error

    07001

    Wrong number of input parameters

    07002

    Wrong number of output parameters

    07003

    Cursor specification cannot be executed

    07004

    USING clause required for dynamic parameters

    07005

    Prepared statement not a cursor-specification

    07006

    Restricted data type attribute violation

    07007

    USING clause required for result fields

    07008

    Invalid descriptor count

    07009

    Invalid descriptor index

    SQLCLASS 08 (Connection Exception)

    08001

    Client unable to establish connection

    08002

    Connection name in use

    08003

    Connection does not exist

    08004

    Server rejected the connection

    08006

    Connection failure

    08007

    Transaction resolution unknown

    SQLCLASS 0A (Feature Not Supported)

    0A000

    Feature Not Supported

    SQLCLASS 0B (Invalid Transaction Initiation)

    0B000

    Invalid transaction initiation

    SQLCLASS 0L (Invalid Grantor)

    0L000

    Invalid grantor

    SQLCLASS 0P (Invalid Role Specification)

    0P000

    Invalid role specification

    SQLCLASS 0U (Attempt to Assign to Non-Updatable Column)

    0U000

    Attempt to assign to non-updatable column

    SQLCLASS 0V (Attempt to Assign to Ordering Column)

    0V000

    Attempt to assign to Ordering column

    SQLCLASS 20 (Case Not Found For Case Statement)

    20000

    Case not found for case statement

    SQLCLASS 21 (Cardinality Violation)

    21000

    Cardinality violation

    21S01

    Insert value list does not match column list

    21S02

    Degree of derived table does not match column list

    SQLCLASS 22 (Data Exception)

    22000

    Data exception

    22001

    String data, right truncation

    22002

    Null value, no indicator parameter

    22003

    Numeric value out of range

    22004

    Null value not allowed

    22005

    Error in assignment

    22006

    Null value in field reference

    22007

    Invalid datetime format

    22008

    Datetime field overflow

    22009

    Invalid time zone displacement value

    2200A

    Null value in reference target

    2200B

    Escape character conflict

    2200C

    Invalid use of escape character

    2200D

    Invalid escape octet

    2200E

    Null value in array target

    2200F

    Zero-length character string

    2200G

    Most specific type mismatch

    22010

    Invalid indicator parameter value

    22011

    Substring error

    22012

    Division by zero

    22014

    Invalid update value

    22015

    Interval field overflow

    22018

    Invalid character value for cast

    22019

    Invalid escape character

    2201B

    Invalid regular expression

    2201C

    Null row not permitted in table

    22012

    Division by zero

    22020

    Invalid limit value

    22021

    Character not in repertoire

    22022

    Indicator overflow

    22023

    Invalid parameter value

    22024

    Character string not properly terminated

    22025

    Invalid escape sequence

    22026

    String data, length mismatch

    22027

    Trim error

    22028

    Row already exists

    2202D

    Null instance used in mutator function

    2202E

    Array element error

    2202F

    Array data, right truncation

    SQLCLASS 23 (Integrity Constraint Violation)

    23000

    Integrity constraint violation

    SQLCLASS 24 (Invalid Cursor State)

    24000

    Invalid cursor state

    24504

    The cursor identified in the UPDATE, DELETE, SET, or GET statement is not positioned on a row

    SQLCLASS 25 (Invalid Transaction State)

    25000

    Invalid transaction state

    25S01

    Transaction state

    25S02

    Transaction is still active

    25S03

    Transaction is rolled back

    SQLCLASS 26 (Invalid SQL Statement Name)

    26000

    Invalid SQL statement name

    SQLCLASS 27 (Triggered Data Change Violation)

    27000

    Triggered data change violation

    SQLCLASS 28 (Invalid Authorization Specification)

    28000

    Invalid authorization specification

    SQLCLASS 2B (Dependent Privilege Descriptors Still Exist)

    2B000

    Dependent privilege descriptors still exist

    SQLCLASS 2C (Invalid Character Set Name)

    2C000

    Invalid character set name

    SQLCLASS 2D (Invalid Transaction Termination)

    2D000

    Invalid transaction termination

    SQLCLASS 2E (Invalid Connection Name)

    2E000

    Invalid connection name

    SQLCLASS 2F (SQL Routine Exception)

    2F000

    SQL routine exception

    2F002

    Modifying SQL-data not permitted

    2F003

    Prohibited SQL-statement attempted

    2F004

    Reading SQL-data not permitted

    2F005

    Function executed no return statement

    SQLCLASS 33 (Invalid SQL Descriptor Name)

    33000

    Invalid SQL descriptor name

    SQLCLASS 34 (Invalid Cursor Name)

    34000

    Invalid cursor name

    SQLCLASS 35 (Invalid Condition Number)

    35000

    Invalid condition number

    SQLCLASS 36 (Cursor Sensitivity Exception)

    36001

    Request rejected

    36002

    Request failed

    SQLCLASS 37 (Invalid Identifier)

    37000

    Invalid identifier

    37001

    Identifier too long

    SQLCLASS 38 (External Routine Exception)

    38000

    External routine exception

    SQLCLASS 39 (External Routine Invocation Exception)

    39000

    External routine invocation exception

    SQLCLASS 3B (Invalid Save Point)

    3B000

    Invalid save point

    SQLCLASS 3C (Ambiguous Cursor Name)

    3C000

    Ambiguous cursor name

    SQLCLASS 3D (Invalid Catalog Name)

    3D000

    Invalid catalog name

    3D001

    Catalog name not found

    SQLCLASS 3F (Invalid Schema Name)

    3F000

    Invalid schema name

    SQLCLASS 40 (Transaction Rollback)

    40000

    Ongoing transaction has been rolled back

    40001

    Serialization failure

    40002

    Transaction integrity constraint violation

    40003

    Statement completion unknown

    SQLCLASS 42 (Syntax Error or Access Violation)

    42000

    Syntax error or access violation

    42702

    Ambiguous column reference

    42725

    Ambiguous function reference

    42818

    The operands of an operator or function are not compatible

    42S01

    Base table or view already exists

    42S02

    Base table or view not found

    42S11

    Index already exists

    42S12

    Index not found

    42S21

    Column already exists

    42S22

    Column not found

    SQLCLASS 44 (With Check Option Violation)

    44000

    WITH CHECK OPTION Violation

    SQLCLASS 45 (Unhandled User-defined Exception)

    45000

    Unhandled user-defined exception

    SQLCLASS 54 (Program Limit Exceeded)

    54000

    Program limit exceeded

    54001

    Statement too complex

    54011

    Too many columns

    54023

    Too many arguments

    SQLCLASS HY (CLI-specific Condition)

    HY000

    CLI-specific condition

    HY001

    Memory allocation error

    HY003

    Invalid data type in application descriptor

    HY004

    Invalid data type

    HY007

    Associated statement is not prepared

    HY008

    Operation canceled

    HY009

    Invalid use of null pointer

    HY010

    Function sequence error

    HY011

    Attribute cannot be set now

    HY012

    Invalid transaction operation code

    HY013

    Memory management error

    HY014

    Limit on the number of handles exceeded

    HY015

    No cursor name available

    HY016

    Cannot modify an implementation row descriptor

    HY017

    Invalid use of an automatically allocated descriptor handle

    HY018

    Server declined the cancellation request

    HY019

    Non-string data cannot be sent in pieces

    HY020

    Attempt to concatenate a null value

    HY021

    Inconsistent descriptor information

    HY024

    Invalid attribute value

    HY055

    Non-string data cannot be used with string routine

    HY090

    Invalid string length or buffer length

    HY091

    Invalid descriptor field identifier

    HY092

    Invalid attribute identifier

    HY095

    Invalid Function ID specified

    HY096

    Invalid information type

    HY097

    Column type out of range

    HY098

    Scope out of range

    HY099

    Nullable type out of range

    HY100

    Uniqueness option type out of range

    HY101

    Accuracy option type out of range

    HY103

    Invalid retrieval code

    HY104

    Invalid Length/Precision value

    HY105

    Invalid parameter type

    HY106

    Invalid fetch orientation

    HY107

    Row value out of range

    HY109

    Invalid cursor position

    HY110

    Invalid driver completion

    HY111

    Invalid bookmark value

    HYC00

    Optional feature not implemented

    HYT00

    Timeout expired

    HYT01

    Connection timeout expired

    SQLCLASS XX (Internal Error)

    XX000

    Internal error

    XX001

    Data corrupted

    XX002

    Index corrupted

    SQLCODE and GDSCODE Error Codes and Descriptions

    The table provides the SQLCODE groupings, the numeric and symbolic values for the GDSCODE errors and the message texts.

    Table 185. SQLCODE and GDSCODE Error Codes and Message Texts (1)
    SQL­CODEGDSCODESymbolMessage Text

    101

    335544366

    Segment

    Segment buffer length shorter than expected

    100

    335544338

    fromno_match

    No match for first value expression

    100

    335544354

    no_record

    Invalid database key

    100

    335544367

    segstr_eof

    Attempted retrieval of more segments than exist

    100

    335544374

    stream_eof

    Attempt to fetch past the last record in a record stream

    0

    335741039

    gfix_opt_SQL_dialect

    -sql_dialect | set database dialect n

    0

    335544875

    bad_debug_format

    Bad debug info format

    -84

    335544554

    nonsql_security_rel

    Table/procedure has non-SQL security class defined

    -84

    335544555

    nonsql_security_fld

    Column has non-SQL security class defined

    -84

    335544668

    dsql_procedure_use_err

    Procedure @1 does not return any values

    -85

    335544747

    usrname_too_long

    The username entered is too long. Maximum length is 31 bytes

    -85

    335544748

    password_too_long

    The password specified is too long. Maximum length is @1 bytes

    -85

    335544749

    usrname_required

    A username is required for this operation

    -85

    335544750

    password_required

    A password is required for this operation

    -85

    335544751

    bad_protocol

    The network protocol specified is invalid

    -85

    335544752

    dup_usrname_found

    A duplicate user name was found in the security database

    -85

    335544753

    usrname_not_found

    The user name specified was not found in the security database

    -85

    335544754

    error_adding_sec_record

    An error occurred while attempting to add the user

    -85

    335544755

    error_modifying_sec_record

    An error occurred while attempting to modify the user record

    -85

    335544756

    error_deleting_sec_record

    An error occurred while attempting to delete the user record

    -85

    335544757

    error_updating_sec_db

    An error occurred while updating the security database

    -103

    335544571

    dsql_constant_err

    Data type for constant unknown

    -104

    336003075

    dsql_transitional_numeric

    Precision 10 to 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3

    -104

    336003077

    sql_db_dialect_dtype_unsupport

    Database SQL dialect @1 does not support reference to @2 datatype

    -104

    336003087

    dsql_invalid_label

    Label @1 @2 in the current scope

    -104

    336003088

    dsql_datatypes_not_comparable

    Datatypes @1are not comparable in expression @2

    -104

    335544343

    invalid_blr

    Invalid request BLR at offset @1

    -104

    335544390

    syntaxerr

    BLR syntax error: expected @1 at offset @2, encountered @3

    -104

    335544425

    ctxinuse

    Context already in use (BLR error)

    -104

    335544426

    ctxnotdef

    Context not defined (BLR error)

    -104

    335544429

    badparnum

    Bad parameter number

    -104

    335544440

    bad_msg_vec

    -

    -104

    335544456

    invalid_sdl

    Invalid slice description language at offset @1

    -104

    335544570

    dsql_command_err

    Invalid command

    -104

    335544579

    dsql_internal_err

    Internal error

    -104

    335544590

    dsql_dup_option

    Option specified more than once

    -104

    335544591

    dsql_tran_err

    Unknown transaction option

    -104

    335544592

    dsql_invalid_array

    Invalid array reference

    -104

    335544608

    command_end_err

    Unexpected end of command

    -104

    335544612

    token_err

    Token unknown

    -104

    335544634

    dsql_token_unk_err

    Token unknown - line @1, column @2

    -104

    335544709

    dsql_agg_ref_err

    Invalid aggregate reference

    -104

    335544714

    invalid_array_id

    Invalid blob id

    -104

    335544730

    cse_not_supported

    Client/Server Express not supported in this release

    -104

    335544743

    token_too_long

    Token size exceeds limit

    -104

    335544763

    invalid_string_constant

    A string constant is delimited by double quotes

    -104

    335544764

    transitional_date

    DATE must be changed to TIMESTAMP

    -104

    335544796

    sql_dialect_datatype_unsupport

    Client SQL dialect @1 does not support reference to @2 datatype

    -104

    335544798

    depend_on_uncommitted_rel

    You created an indirect dependency on uncommitted metadata. You must roll back the current transaction

    -104

    335544821

    dsql_column_pos_err

    Invalid column position used in the @1 clause

    -104

    335544822

    dsql_agg_where_err

    Cannot use an aggregate function in a WHERE clause, use HAVING instead

    -104

    335544823

    dsql_agg_group_err

    Cannot use an aggregate function in a GROUP BY clause

    -104

    335544824

    dsql_agg_column_err

    Invalid expression in the @1 (not contained in either an aggregate function or the GROUP BY clause)

    -104

    335544825

    dsql_agg_having_err

    Invalid expression in the @1 (neither an aggregate function nor a part of the GROUP BY clause)

    -104

    335544826

    dsql_agg_nested_err

    Nested aggregate functions are not allowed

    -104

    335544849

    malformed_string

    Malformed string

    -104

    335544851

    command_end_err2

    Unexpected end of command- line @1, column @2

    -104

    336397215

    dsql_max_sort_items

    Cannot sort on more than 255 items

    -104

    336397216

    dsql_max_group_items

    Cannot group on more than 255 items

    -104

    336397217

    dsql_conflicting_sort_field

    Cannot include the same field (@1.@2) twice in the ORDER BY clause with conflicting sorting options

    -104

    336397218

    dsql_derived_table_more_columns

    Column list from derived table @1 has more columns than the number of items in its SELECT statement

    -104

    336397219

    dsql_derived_table_less_columns

    Column list from derived table @1 has less columns than the number of items in its SELECT statement

    -104

    336397220

    dsql_derived_field_unnamed

    No column name specified for column number @1 in derived table @2

    -104

    336397221

    dsql_derived_field_dup_name

    Column @1 was specified multiple times for derived table @2

    -104

    336397222

    dsql_derived_alias_select

    Internal dsql error: alias type expected by pass1_expand_select_node

    -104

    336397223

    dsql_derived_alias_field

    Internal dsql error: alias type expected by pass1_field

    -104

    336397224

    dsql_auto_field_bad_pos

    Internal dsql error: column position out of range in pass1_union_auto_cast

    -104

    336397225

    dsql_cte_wrong_reference

    Recursive CTE member (@1) can refer itself only in FROM clause

    -104

    336397226

    dsql_cte_cycle

    CTE ‘@1’ has cyclic dependencies

    -104

    336397227

    dsql_cte_outer_join

    Recursive member of CTE can’t be member of an outer join

    -104

    336397228

    dsql_cte_mult_references

    Recursive member of CTE can’t reference itself more than once

    -104

    336397229

    dsql_cte_not_a_union

    Recursive CTE (@1) must be an UNION

    -104

    336397230

    dsql_cte_nonrecurs_after_recurs

    CTE ‘@1’ defined non-recursive member after recursive

    -104

    336397231

    dsql_cte_wrong_clause

    Recursive member of CTE ‘@1’ has @2 clause

    -104

    336397232

    dsql_cte_union_all

    Recursive members of CTE (@1) must be linked with another members via UNION ALL

    -104

    336397233

    dsql_cte_miss_nonrecursive

    Non-recursive member is missing in CTE ‘@1’

    -104

    336397234

    dsql_cte_nested_with

    WITH clause can’t be nested

    -104

    336397235

    dsql_col_more_than_once_using

    Column @1 appears more than once in USING clause

    -104

    336397237

    dsql_cte_not_used

    CTE “@1” is not used in query

    -105

    335544702

    like_escape_invalid

    Invalid ESCAPE sequence

    -105

    335544789

    extract_input_mismatch

    Specified EXTRACT part does not exist in input datatype

    -150

    335544360

    read_only_rel

    Attempted update of read-only table

    -150

    335544362

    read_only_view

    Cannot update read-only view @1

    -150

    335544446

    non_updatable

    Not updatable

    -150

    335544546

    constaint_on_view

    Cannot define constraints on views

    -151

    335544359

    read_only_field

    Attempted update of read - only column

    -155

    335544658

    dsql_base_table

    @1 is not a valid base table of the specified view

    -157

    335544598

    specify_field_err

    Must specify column name for view select expression

    -158

    335544599

    num_field_err

    Number of columns does not match select list

    -162

    335544685

    no_dbkey

    Dbkey not available for multi - table views

    -170

    335544512

    prcmismat

    Input parameter mismatch for procedure @1

    -170

    335544619

    extern_func_err

    External functions cannot have more than 10 parameters

    -170

    335544850

    prc_out_param_mismatch

    Output parameter mismatch for procedure @1

    -171

    335544439

    funmismat

    Function @1 could not be matched

    -171

    335544458

    invalid_dimension

    Column not array or invalid dimensions (expected @1, encountered @2)

    -171

    335544618

    return_mode_err

    Return mode by value not allowed for this data type

    -171

    335544873

    array_max_dimensions

    Array data type can use up to @1 dimensions

    -172

    335544438

    funnotdef

    Function @1 is not defined

    -203

    335544708

    dyn_fld_ambiguous

    Ambiguous column reference

    -204

    336003085

    dsql_ambiguous_field_name

    Ambiguous field name between @1 and @2

    -204

    335544463

    gennotdef

    Generator @1 is not defined

    -204

    335544502

    stream_not_defined

    Reference to invalid stream number

    -204

    335544509

    charset_not_found

    CHARACTER SET @1 is not defined

    -204

    335544511

    prcnotdef

    Procedure @1 is not defined

    -204

    335544515

    codnotdef

    Status code @1 unknown

    -204

    335544516

    xcpnotdef

    Exception @1 not defined

    -204

    335544532

    ref_cnstrnt_notfound

    Name of Referential Constraint not defined in constraints table

    -204

    335544551

    grant_obj_notfound

    Could not find table/procedure for GRANT

    -204

    335544568

    text_subtype

    Implementation of text subtype @1 not located

    -204

    335544573

    dsql_datatype_err

    Data type unknown

    -204

    335544580

    dsql_relation_err

    Table unknown

    -204

    335544581

    dsql_procedure_err

    Procedure unknown

    -204

    335544588

    collation_not_found

    COLLATION @1 for CHARACTER SET @2 is not defined

    -204

    335544589

    collation_not_for_charset

    COLLATION @1 is not valid for specified CHARACTER SET

    -204

    335544595

    dsql_trigger_err

    Trigger unknown

    -204

    335544620

    alias_conflict_err

    Alias @1 conflicts with an alias in the same statement

    -204

    335544621

    procedure_conflict_error

    Alias @1 conflicts with a procedure in the same statement

    -204

    335544622

    relation_conflict_err

    Alias @1 conflicts with a table in the same statement

    -204

    335544635

    dsql_no_relation_alias

    There is no alias or table named @1 at this scope level

    -204

    335544636

    indexname

    There is no index @1 for table @2

    -204

    335544640

    collation_requires_text

    Invalid use of CHARACTER SET or COLLATE

    -204

    335544662

    dsql_blob_type_unknown

    BLOB SUB_TYPE @1 is not defined

    -204

    335544759

    bad_default_value

    Can not define a not null column with NULL as default value

    -204

    335544760

    invalid_clause

    Invalid clause - ‘@1’

    -204

    335544800

    too_many_contexts

    Too many Contexts of Relation/Procedure/Views. Maximum allowed is 255

    -204

    335544817

    bad_limit_param

    Invalid parameter to FIRST.Only integers >= 0 are allowed

    -204

    335544818

    bad_skip_param

    Invalid parameter to SKIP. Only integers >= 0 are allowed

    -204

    335544837

    bad_substring_offset

    Invalid offset parameter @1 to SUBSTRING. Only positive integers are allowed

    -204

    335544853

    bad_substring_length

    Invalid length parameter @1 to SUBSTRING. Negative integers are not allowed

    -204

    335544854

    charset_not_installed

    CHARACTER SET @1 is not installed

    -204

    335544855

    collation_not_installed

    COLLATION @1 for CHARACTER SET @2 is not installed

    -204

    335544867

    subtype_for_internal_use

    Blob sub_types bigger than 1 (text) are for internal use only

    -205

    335544396

    fldnotdef

    Column @1 is not defined in table @2

    -205

    335544552

    grant_fld_notfound

    Could not find column for GRANT

    -205

    335544883

    fldnotdef2

    Column @1 is not defined in procedure @2

    -206

    335544578

    dsql_field_err

    Column unknown

    -206

    335544587

    dsql_blob_err

    Column is not a BLOB

    -206

    335544596

    dsql_subselect_err

    Subselect illegal in this context

    -206

    336397208

    dsql_line_col_error

    At line @1, column @2

    -206

    336397209

    dsql_unknown_pos

    At unknown line and column

    -206

    336397210

    dsql_no_dup_name

    Column @1 cannot be repeated in @2 statement

    -208

    335544617

    order_by_err

    Invalid ORDER BY clause

    -219

    335544395

    relnotdef

    Table @1 is not defined

    -219

    335544872

    domnotdef

    Domain @1 is not defined

    -230

    335544487

    walw_err

    WAL Writer error

    -231

    335544488

    logh_small

    Log file header of @1 too small

    -232

    335544489

    logh_inv_version

    Invalid version of log file @1

    -233

    335544490

    logh_open_flag

    Log file @1 not latest in the chain but open flag still set

    -234

    335544491

    logh_open_flag2

    Log file @1 not closed properly; database recovery may be required

    -235

    335544492

    logh_diff_dbname

    Database name in the log file @1 is different

    -236

    335544493

    logf_unexpected_eof

    Unexpected end of log file @1 at offset @2

    -237

    335544494

    logr_incomplete

    Incomplete log record at offset @1 in log file @2

    -238

    335544495

    logr_header_small2

    Log record header too small at offset @1 in log file @

    -239

    335544496

    logb_small

    Log block too small at offset @1 in log file @2

    -239

    335544691

    cache_too_small

    Insufficient memory to allocate page buffer cache

    -239

    335544693

    log_too_small

    Log size too small

    -239

    335544694

    partition_too_small

    Log partition size too small

    -243

    335544500

    no_wal

    Database does not use Write-ahead Log

    -257

    335544566

    start_cm_for_wal

    WAL defined; Cache Manager must be started first

    -260

    335544690

    cache_redef

    Cache redefined

    -260

    335544692

    log_redef

    Log redefined

    -261

    335544695

    partition_not_supp

    Partitions not supported in series of log file specification

    -261

    335544696

    log_length_spec

    Total length of a partitioned log must be specified

    -281

    335544637

    no_stream_plan

    Table @1 is not referenced in plan

    -282

    335544638

    stream_twice

    Table @1 is referenced more than once in plan; use aliases to distinguish

    -282

    335544643

    dsql_self_join

    The table @1 is referenced twice; use aliases to differentiate

    -282

    335544659

    duplicate_base_table

    Table @1 is referenced twice in view; use an alias to distinguish

    -282

    335544660

    view_alias

    View @1 has more than one base table; use aliases to distinguish

    -282

    335544710

    complex_view

    Navigational stream @1 references a view with more than one base table

    -283

    335544639

    stream_not_found

    Table @1 is referenced in the plan but not the from list

    -284

    335544642

    index_unused

    Index @1 cannot be used in the specified plan

    -291

    335544531

    primary_key_notnull

    Column used in a PRIMARY constraint must be NOT NULL

    -292

    335544534

    ref_cnstrnt_update

    Cannot update constraints (RDB$REF_CONSTRAINTS)

    -293

    335544535

    check_cnstrnt_update

    Cannot update constraints (RDB$CHECK_CONSTRAINTS)

    -294

    335544536

    check_cnstrnt_del

    Cannot delete CHECK constraint entry (RDB$CHECK_CONSTRAINTS)

    -295

    335544545

    rel_cnstrnt_update

    Cannot update constraints (RDB$RELATION_CONSTRAINTS)

    -296

    335544547

    invld_cnstrnt_type

    Internal gds software consistency check (invalid RDB$CONSTRAINT_TYPE)

    -297

    335544558

    check_constraint

    Operation violates check constraint @1 on view or table @2

    -313

    336003099

    upd_ins_doesnt_match_pk

    UPDATE OR INSERT field list does not match primary key of table @1

    -313

    336003100

    upd_ins_doesnt match _matching

    UPDATE OR INSERT field list does not match MATCHING clause

    -313

    335544669

    dsql_count_mismatch

    Count of column list and variable list do not match

    -314

    335544565

    transliteration_failed

    Cannot transliterate character between character sets

    -315

    336068815

    dyn_dtype_invalid

    Cannot change datatype for column @1.Changing datatype is not supported for BLOB or ARRAY columns

    -383

    336068814

    dyn_dependency_exists

    Column @1 from table @2 is referenced in @3

    -401

    invalid_operator

    Invalid comparison operator for find operation

    -402

    335544368

    segstr_no_op

    Attempted invalid operation on a BLOB

    -402

    335544414

    blobnotsup

    BLOB and array data types are not supported for @1 operation

    -402

    335544427

    datnotsup

    Data operation not supported

    -406

    335544457

    out_of_bounds

    Subscript out of bounds

    -407

    335544435

    nullsegkey

    Null segment of UNIQUE KEY

    -413

    335544334

    convert_error

    Conversion error from string “@1”

    Table 187. SQLCODE and GDSCODE Error Codes and Message Texts (3)
    SQL­CODEGDSCODESymbolMessage Text

    -901

    335544329

    badsegstr_id

    Invalid BLOB ID

    -901

    335740937

    gfix_trn_req

    Number of transactions per sweep required

    -901

    336330761

    gbak_multi_source_dest

    Multiple sources or destinations specified

    -901

    335544330

    bad_tpb_content

    Invalid parameter in transaction parameter block

    -901

    336330762

    gbak_filename_missing

    Requires both input and output filenames

    -901

    335544331

    bad_tpb_form

    Invalid format for transaction parameter block

    -901

    336330763

    gbak_dup_inout_names

    Input and output have the same name. Disallowed

    -901

    335740940

    gfix_full_req

    “full” or “reserve” required

    -901

    335544332

    bad_trans_handle

    Invalid transaction handle (expecting explicit transaction start)

    -901

    336330764

    gbak_inv_page_size

    Expected page size, encountered “@1”

    -901

    335740941

    gfix_usrname_req

    User name required

    -901

    336330765

    gbak_db_specified

    REPLACE specified, but the first file @1 is a database

    -901

    335740942

    gfix_pass_req

    Password required

    -901

    336330766

    gbak_db_exists

    Database @1 already exists.To replace it, use the -REP switch

    -901

    335740943

    gfix_subs_name

    Subsystem name

    -901

    336723983

    gsec_cant_open_db

    Unable to open database

    -901

    336330767

    gbak_unk_device

    Device type not specified

    -901

    336723984

    gsec_switches_error

    Error in switch specifications

    -901

    335740945

    gfix_sec_req

    Number of seconds required

    -901

    335544337

    excess_trans

    Attempt to start more than @1 transactions

    -901

    336723985

    gsec_no_op_spec

    No operation specified

    -901

    335740946

    gfix_nval_req

    Numeric value between 0 and 32767 inclusive required

    -901

    336723986

    gsec_no_usr_name

    No user name specified

    -901

    335740947

    gfix_type_shut

    Must specify type of shutdown

    -901

    335544339

    infinap

    Information type inappropriate for object specified

    -901

    335544340

    infona

    No information of this type available for object specified

    -901

    336723987

    gsec_err_add

    Add record error

    -901

    336723988

    gsec_err_modify

    Modify record error

    -901

    336330772

    gbak_blob_info_failed

    Gds$blobinfo failed

    -901

    335740948

    gfix_retry

    Please retry, specifying an option

    -901

    335544341

    infunk

    Unknown information item

    -901

    336723989

    gsec_err_find_mod

    Find / modify record error

    -901

    336330773

    gbak_unk_blob_item

    Do not understand BLOB INFO item @1

    -901

    335544342

    integ_fail

    Action cancelled by trigger (@1) to preserve data integrity

    -901

    336330774

    gbak_get_seg_failed

    Gds$getsegment failed

    -901

    336723990

    gsec_err_rec_not_found

    Record not found for user: @1

    -901

    336723991

    gsec_err_delete

    Delete record error

    -901

    336330775

    gbak_close_blob_failed

    Gds$closeblob failed

    -901

    335740951

    gfix_retry_db

    Please retry, giving a database name

    -901

    336330776

    gbak_open_blob_failed

    Gds$openblob failed

    -901

    336723992

    gsec_err_find_del

    Find / delete record error

    -901

    335544345

    lock_conflict

    Lock conflict on no wait transaction

    -901

    336330777

    gbak_put_blr_gen_id_failed

    Failed in put_blr_gen_id

    -901

    336330778

    gbak_unk_type

    Data type @1 not understood

    -901

    336330779

    gbak_comp_req_failed

    Gds$compilerequest failed

    -901

    336330780

    gbak_start_req_failed

    Gds$startrequest failed

    -901

    336723996

    gsec_err_find_disp

    Find / display record error

    -901

    336330781

    gbak_rec_failed

    gds$receive failed

    -901

    336920605

    gstatopen_err

    Can’t open database file @1

    -901

    336723997

    gsec_inv_param

    Invalid parameter, no switch defined

    -901

    335544350

    no_finish

    Program attempted to exit without finishing database

    -901

    336920606

    gstat_read_err

    Can’t read a database page

    -901

    336330782

    gbak_rel_req_failed

    Gds$releaserequest failed

    -901

    336723998

    gsec_op_specified

    Operation already specified

    -901

    336920607

    gstat_sysmemex

    System memory exhausted

    -901

    336330783

    gbak_db_info_failed

    gds$databaseinfo failed

    -901

    336723999

    gsec_pw_specified

    Password already specified

    -901

    336724000

    gsec_uid_specified

    Uid already specified

    -901

    336330784

    gbak_no_db_desc

    Expected database description record

    -901

    335544353

    no_recon

    Transaction is not in limbo

    -901

    336724001

    gsec_gid_specified

    Gid already specified

    -901

    336330785

    gbak_db_create_failed

    Failed to create database @1

    -901

    336724002

    gsec_proj_specified

    Project already specified

    -901

    336330786

    gbak_decomp_len_error

    RESTORE: decompression length error

    -901

    335544355

    no_segstr_close

    BLOB was not closed

    -901

    336330787

    gbak_tbl_missing

    Cannot find table @1

    -901

    336724003

    gsec_org_specified

    Organization already specified

    -901

    336330788

    gbak_blob_col_missing

    Cannot find column for BLOB

    -901

    336724004

    gsec_fname_specified

    First name already specified

    -901

    335544357

    open_trans

    Cannot disconnect database with open transactions (@1 active)

    -901

    336330789

    gbak_create_blob_failed

    Gds$createblob failed

    -901

    336724005

    gsec_mname_specified

    Middle name already specified

    -901

    335544358

    port_len

    Message length error ( encountered @1, expected @2)

    -901

    336330790

    gbak_put_seg_failed

    Gds$putsegment failed

    -901

    336724006

    gsec_lname_specified

    Last name already specified

    -901

    336330791

    gbak_rec_len_exp

    Expected record length

    -901

    336724008

    gsec_inv_switch

    Invalid switch specified

    -901

    336330792

    gbak_inv_rec_len

    Wrong length record, expected @1 encountered @2

    -901

    336330793

    gbak_exp_data_type

    Expected data attribute

    -901

    336724009

    gsec_amb_switch

    Ambiguous switch specified

    -901

    336330794

    gbak_gen_id_failed

    Failed in store_blr_gen_id

    -901

    336724010

    gsec_no_op_specified

    No operation specified for parameters

    -901

    335544363

    req_no_trans

    No transaction for request

    -901

    336330795

    gbak_unk_rec_type

    Do not recognize record type @1

    -901

    336724011

    gsec_params_not_allowed

    No parameters allowed for this operation

    -901

    335544364

    req_sync

    Request synchronization error

    -901

    336724012

    gsec_incompat_switch

    Incompatible switches specified

    -901

    336330796

    gbak_inv_bkup_ver

    Expected backup version 1..8. Found @1

    -901

    335544365

    req_wrong_db

    Request referenced an unavailable database

    336330797

    gbak_missing_bkup_desc

    Expected backup description record

    -901

    336330798

    gbak_string_trunc

    String truncated

    -901

    336330799

    gbak_cant_rest_record

    warning — record could not be restored

    -901

    336330800

    gbak_send_failed

    Gds$send failed

    -901

    335544369

    segstr_no_read

    Attempted read of a new, open BLOB

    -901

    336330801

    gbak_no_tbl_name

    No table name for data

    -901

    335544370

    segstr_no_trans

    Attempted action on blob outside transaction

    -901

    336330802

    gbak_unexp_eof

    Unexpected end of file on backup file

    -901

    336330803

    gbak_db_format_too_old

    Database format @1 is too old to restore to

    -901

    335544372

    segstr_wrong_db

    Attempted reference to BLOB in unavailable database

    -901

    336330804

    gbak_inv_array_dim

    Array dimension for column @1 is invalid

    -901

    336330807

    gbak_xdr_len_expected

    Expected XDR record length

    -901

    335544376

    unres_rel

    Table @1 was omitted from the transaction reserving list

    -901

    335544377

    uns_ext

    Request includes a DSRI extension not supported in this implementation

    -901

    335544378

    wish_list

    Feature is not supported

    -901

    335544382

    random

    @1

    -901

    335544383

    fatal_conflict

    Unrecoverable conflict with limbo transaction @1

    -901

    335740991

    gfix_exceed_max

    Internal block exceeds maximum size

    -901

    335740992

    gfix_corrupt_pool

    Corrupt pool

    -901

    335740993

    gfix_mem_exhausted

    Virtual memory exhausted

    -901

    336330817

    gbak_open_bkup_error

    Cannot open backup file @1

    -901

    335740994

    gfix_bad_pool

    Bad pool id.

    -901

    336330818

    gbak_open_error

    Cannot open status and error output file @1

    -901

    335740995

    gfix_trn_not_valid

    Transaction state @1 not in valid range

    -901

    335544392

    bdbincon

    Internal error

    -901

    336724044

    gsec_inv_username

    Invalid user name (maximum 31 bytes allowed)

    -901

    336724045

    gsec_inv_pw_length

    Warning - maximum 8 significant bytes of password used

    -901

    336724046

    gsec_db_specified

    Database already specified

    -901

    336724047

    gsec_db_admin_specified

    Database administrator name already specified

    -901

    336724048

    gsec_db_admin_pw_specified

    Database administrator password already specified

    -901

    336724049

    gsec_sql_role_specified

    SQL role name already specified

    -901

    335741012

    gfix_unexp_eoi

    Unexpected end of input

    -901

    335544407

    dbbnotzer

    Database handle not zero

    -901

    335544408

    tranotzer

    Transaction handle not zero

    -901

    335741018

    gfix_recon_fail

    Failed to reconnect to a transaction in database @1

    -901

    335544418

    trainlim

    Transaction in limbo

    -901

    335544419

    notinlim

    Transaction not in limbo

    -901

    335544420

    traoutsta

    Transaction outstanding

    -901

    335544428

    badmsgnum

    Undefined message number

    -901

    335741036

    gfix_trn_unknown

    Transaction description item unknown

    -901

    335741038

    gfix_mode_req

    “read_only” or “read_write” required

    -901

    335544431

    blocking_signal

    Blocking signal has been received

    -901

    335741042

    gfix_pzval_req

    Positive or zero numeric value required

    -901

    335544442

    noargacc_read

    Database system cannot read argument @1

    -901

    335544443

    noargacc_write

    Database system cannot write argument @1

    -901

    335544450

    misc_interpreted

    @1

    -901

    335544468

    tra_state

    Transaction @1 is @2

    -901

    335544485

    bad_stmt_handle

    Invalid statement handle

    -901

    336330934

    gbak_missing_block_fac

    Blocking factor parameter missing

    -901

    336330935

    gbak_inv_block_fac

    Expected blocking factor, encountered “@1”

    -901

    336330936

    gbak_block_fac_specified

    A blocking factor may not be used in conjunction with device CT

    -901

    336068796

    dyn_role_does_not_exist

    SQL role @1 does not exist

    -901

    336330940

    gbak_missing_username

    User name parameter missing

    -901

    336330941

    gbak_missing_password

    Password parameter missing

    -901

    336068797

    dyn_no_grant_admin_opt

    User @1 has no grant admin option on SQL role @2

    -901

    335544510

    lock_timeout

    Lock time-out on wait transaction

    -901

    336068798

    dyn_user_not_role_member

    User @1 is not a member of SQL role @2

    -901

    336068799

    dyn_delete_role_failed

    @1 is not the owner of SQL role @2

    -901

    336068800

    dyn_grant_role_to_user

    @1 is a SQL role and not a user

    -901

    336068801

    dyn_inv_sql_role_name

    User name @1 could not be used for SQL role

    -901

    336068802

    dyn_dup_sql_role

    SQL role @1 already exists

    -901

    336068803

    dyn_kywd_spec_for_role

    Keyword @1 can not be used as a SQL role name

    -901

    336068804

    dyn_roles_not_supported

    SQL roles are not supported in on older versions of the database. A backup and restore of the database is required

    -901

    336330952

    gbak_missing_skipped_bytes

    missing parameter for the number of bytes to be skipped

    -901

    336330953

    gbak_inv_skipped_bytes

    Expected number of bytes to be skipped, encountered “@1”

    -901

    336068820

    dyn_zero_len_id

    Zero length identifiers are not allowed

    -901

    336330965

    gbak_err_restore_charset

    Character set

    -901

    336330967

    gbak_err_restore_collation

    Collation

    -901

    336330972

    gbak_read_error

    Unexpected I/O error while reading from backup file

    -901

    336330973

    gbak_write_error

    Unexpected I/O error while writing to backup file

    -901

    336068840

    dyn_wrong_gtt_scope

    @1 cannot reference @2

    -901

    336330985

    gbak_db_in_use

    Could not drop database @1 (database might be in use)

    -901

    336330990

    gbak_sysmemex

    System memory exhausted

    -901

    335544559

    bad_svc_handle

    Invalid service handle

    -901

    335544561

    wrospbver

    Wrong version of service parameter block

    -901

    335544562

    bad_spb_form

    Unrecognized service parameter block

    -901

    335544563

    svcnotdef

    Service @1 is not defined

    -901

    336068856

    dyn_ods_not_supp_feature

    Feature ‘@1’ is not supported in ODS @2.@3

    -901

    336331002

    gbak_restore_role_failed

    SQL role

    -901

    336331005

    gbak_role_op_missing

    SQL role parameter missing

    -901

    336331010

    gbak_page_buffers_missing

    Page buffers parameter missing

    -901

    336331011

    gbak_page_buffers_wrong_param

    Expected page buffers, encountered “@1”

    -901

    336331012

    gbak_page_buffers_restore

    Page buffers is allowed only on restore or create

    -901

    336331014

    gbak_inv_size

    Size specification either missing or incorrect for file @1

    -901

    336331015

    gbak_file_outof_sequence

    File @1 out of sequence

    -901

    336331016

    gbak_join_file_missing

    Can’t join - one of the files missing

    -901

    336331017

    gbak_stdin_not_supptd

    standard input is not supported when using join operation

    -901

    336331018

    gbak_stdout_not_supptd

    Standard output is not supported when using split operation

    -901

    336331019

    gbak_bkup_corrupt

    Backup file @1 might be corrupt

    -901

    336331020

    gbak_unk_db_file_spec

    Database file specification missing

    -901

    336331021

    gbak_hdr_write_failed

    Can’t write a header record to file @1

    -901

    336331022

    gbak_disk_space_ex

    Free disk space exhausted

    -901

    336331023

    gbak_size_lt_min

    File size given (@1) is less than minimum allowed (@2)

    -901

    336331025

    gbak_svc_name_missing

    Service name parameter missing

    -901

    336331026

    gbak_not_ownr

    Cannot restore over current database, must be SYSDBA or owner of the existing database

    -901

    336331031

    gbak_mode_req

    “read_only” or “read_write” required

    -901

    336331033

    gbak_just_data

    Just data ignore all constraints etc.

    -901

    336331034

    gbak_data_only

    Restoring data only ignoring foreign key, unique, not null & other constraints

    -901

    335544609

    index_name

    INDEX @1

    -901

    335544610

    exception_name

    EXCEPTION @1

    -901

    335544611

    field_name

    COLUMN @1

    -901

    335544613

    union_err

    Union not supported