WRITE "SQLCODE=",SQLCODE," -- ",$SYSTEM.SQL.SQLCODE(SQLCODE)
This method can also be called as a stored procedure from ODBC or JDBC: %SYSTEM.SQL_SQLCODE(-nnn).
SQL Error Codes
|
SQLCODE
Error Code
|
Meaning
|
|
-11002
|
WinSock: Nonauthoritative
host not found
|
|
-11001
|
WinSock: Host not found
|
|
-10093
|
WinSock: Successful
WSASTARTUP not yet performed
|
|
-10092
|
WinSock: WINSOCK DLL
version out of range
|
|
-10091
|
WinSock: Network
subsystem is unavailable
|
|
-10070
|
WinSock: Stale NFS file
handle
|
|
-10065
|
WinSock: No route to host
|
|
-10064
|
WinSock: Host is down
|
|
-10061
|
WinSock: Connection
refused
|
|
-10060
|
WinSock: Connection timed
out
|
|
-10058
|
WinSock: Cannot send
after socket shutdown
|
|
-10057
|
WinSock: Socket is not
connected
|
|
-10056
|
WinSock: Socket is
already connected
|
|
-10055
|
WinSock: No buffer space
available
|
|
-10054
|
WinSock: Connection reset
by peer (due to timeout or reboot)
|
|
-10052
|
WinSock: Net dropped
connection or reset
|
|
-10051
|
WinSock: Network is
unreachable
|
|
-10050
|
WinSock: Network is down
|
|
-500
|
Fetch row count limit
reached
|
|
-471
|
Duplicate cursor name
|
|
-470
|
Option value changed
|
|
-469
|
Driver not capable
|
|
-468
|
Fetch type out of range
|
|
-467
|
Column type out of range
|
|
-466
|
Invalid parameter number
|
|
-465
|
Invalid string or buffer
length
|
|
-464
|
Function sequence error
|
|
-463
|
Invalid column number
|
|
-462
|
Memory allocation failure
|
|
-461
|
Communication link
failure
|
|
-460
|
General error
|
|
-453
|
Error in User
Initialization Code
|
|
-452
|
Message sequencing error
|
|
-451
|
Unable to receive server
message
|
|
-450
|
Unable to send client
message
|
|
-430
|
Cannot initialize
procedure context
|
|
-429
|
Invalid number of
input/output parameters for Stored Procedure
|
|
-428
|
Stored Procedure Not
Found
|
|
-427
|
Invalid Stored Procedure
Name
|
|
-426
|
Error preparing Stored
Procedure
|
|
-425
|
Error processing Stored
Procedure request
|
|
-422
|
SELECT request processed
via ODBC, JDBC, or Dynamic SQL cannot contain an INTO clause
|
|
-421
|
Warning: UPDATE or DELETE
statement does not contain a WHERE clause
|
|
-415
|
Fatal error occurred
within the SQL filer
|
|
-411
|
No stream object defined
for field
|
|
-410
|
Invalid Directory
|
|
-409
|
Invalid server function
|
|
-408
|
Unable to start server
|
|
-407
|
Unable to Write to Server
Master
|
|
-406
|
Unable to Write to Server
|
|
-405
|
Unable to read from
communication device
|
|
-402
|
Invalid Username/Password
|
|
-401
|
Fatal Connection error
|
|
-400
|
Fatal error occurred
|
|
-374
|
Cannot alter the datatype
of a field to/from a stream type when the table contains data
|
|
-373
|
An extrinsic function
call may not call a % routine
|
|
-372
|
Support for extrinsic
function calls are disabled
|
|
-371
|
:HVar = CALL ...
Specified for a Procedure which does not return a value
|
|
-370
|
Embedded SQL CALL
Statement can only be used for Method Procedures
|
|
-366
|
Schema name mismatch
between trigger name and table name
|
|
-365
|
Trigger name not unique
|
|
-364
|
Trigger with same EVENT,
TIME, and ORDER already defined
|
|
-363
|
Trigger not found
|
|
-362
|
Specified query or stored
procedure not found
|
|
-361
|
More than one query or
stored procedure found that matches your specification
|
|
-359
|
SQL Function (function
Stored Procedure) not found
|
|
-358
|
SQL Function (function
Stored Procedure) name not unique
|
|
-333
|
No such index defined
|
|
-325
|
Index cannot be dropped
because it is the IDKEY index and the table has data
|
|
-324
|
Index with this name
already defined for this table
|
|
-320
|
Cannot DROP table — One
or more Foreign Key constraints reference this table
|
|
-319
|
Referenced table has no
primary key defined
|
|
-317
|
Cannot DROP Constraint —
One or more Foreign Key constraints reference this Unique constraint
|
|
-315
|
Constraint or Key not
found
|
|
-314
|
Foreign key references
non-unique key/column collection
|
|
-311
|
Foreign key with same
name already defined for this table
|
|
-310
|
Foreign key references
non-existent table
|
|
-307
|
Primary key already
defined for this table
|
|
-306
|
Column with this name
already exists
|
|
-305
|
Attempt to make field
required when the table has one or more rows where the column value is NULL
|
|
-304
|
Attempt to add a NOT NULL
field with no default value to a table which contains data
|
|
-300
|
DDL not allowed on this
table definition
|
|
-201
|
Table or View name not
unique
|
|
-137
|
View's WITH CHECK OPTION
validation failed in UPDATE
|
|
-136
|
View's WITH CHECK OPTION
validation failed in INSERT
|
|
-135
|
After Delete trigger
failed
|
|
-134
|
Before Delete trigger
failed
|
|
-133
|
After Update trigger
failed
|
|
-132
|
Before Update trigger
failed
|
|
-131
|
Before Insert trigger
failed
|
|
-130
|
Before Insert trigger
failed
|
|
-127
|
FOREIGN KEY Constraint
failed referential check upon creation of the constraint
|
|
-125
|
UNIQUE or PRIMARY KEY
Constraint failed uniqueness check upon creation of the constraint
|
|
-124
|
FOREIGN KEY Constraint
failed referential check upon DELETE of row in referenced table
|
|
-123
|
FOREIGN KEY Constraint
failed referential check upon UPDATE of row in referenced table
|
|
-122
|
FOREIGN KEY Constraint
failed referential check upon UPDATE of row in referencing table
|
|
-121
|
FOREIGN KEY Constraint
failed referential check upon INSERT of row in referencing table
|
|
-120
|
UNIQUE or PRIMARY KEY
Constraint failed uniqueness check upon UPDATE
|
|
-119
|
UNIQUE or PRIMARY KEY
Constraint failed uniqueness check upon INSERT
|
|
-118
|
Unknown or non-unique
User or Role
|
|
-115
|
Cannot
INSERT/UPDATE/DELETE on a read only table
|
|
-114
|
One or more matching rows
is locked by another user
|
|
-113
|
%THRESHOLD Violation
|
|
-112
|
Access violation
|
|
-111
|
Cannot INSERT into a
'Default Only' RowID or RowID based on field
|
|
-110
|
Locking conflict in
filing
|
|
-109
|
Cannot find the row
designated for UPDATE
|
|
-108
|
Required field missing;
INSERT or UPDATE not allowed
|
|
-107
|
Cannot UPDATE RowID or
RowID based on Fields
|
|
-106
|
Row to DELETE not found
|
|
-105
|
Field validation failed
in UPDATE
|
|
-104
|
Field validation failed
in INSERT
|
|
-103
|
Positioned UPDATE or
DELETE attempted, but the cursor is not positioned on any row
|
|
-102
|
Operation
(FETCH/CLOSE/UPDATE/DELETE/...) attempted on an unopened cursor
|
|
-101
|
Attempt to open a cursor
that is already open
|
|
-99
|
Privilege Violation
|
|
-97
|
Duplicate select-list
names found
|
|
-96
|
Specified level of
isolation is not supported
|
|
-95
|
Operation Disallowed by
Operation Table
|
|
-94
|
Multi-Conditional OUTER
JOINs are not supported
|
|
-93
|
Number of conditions for
the DIAGNOSTICS SIZE must be exact numeric
|
|
-92
|
Level of isolation cannot
be READ UNCOMMITTED if READ WRITE specified
|
|
-91
|
Transaction mode cannot
be specified more than once
|
|
-90
|
Invalid view name
|
|
-89
|
Invalid index name
|
|
-88
|
Invalid field name
|
|
-87
|
Invalid table name
|
|
-86
|
Invalid field definition,
no datatype defined
|
|
-85
|
Multiple table %ROUTINE
definitions found
|
|
-84
|
Multiple table %NUMROWS
definitions found
|
|
-83
|
Multiple table %FILE
definitions found
|
|
-82
|
Multiple table
%DESCRIPTION definitions found
|
|
-81
|
Column Constraint
expected
|
|
-80
|
Integer expected
|
|
-79
|
Referencing key and
referenced key must be the same size
|
|
-78
|
Invalid transaction state
|
|
-77
|
Qualified column
reference not allowed in this JOIN context
|
|
-76
|
Cardinality mismatch
between the SELECT-list and INTO-list
|
|
-75
|
Trim spec and/or trim
char required before FROM in TRIM function
|
|
-74
|
Duplicate select-list
alias names found
|
|
-73
|
Aggregates not supported
in ORDER BY clause
|
|
-72
|
Multi-Line Field not
valid in ORDER BY clause
|
|
-71
|
Multi-Line Field must be
the Left operand of the Comparison
|
|
-70
|
Multi-Line Field only
valid for LIKE, Contains ([), or NULL Comparison
|
|
-69
|
SET file =
value-expression not allowed with WHERE CURRENT OF cursor
|
|
-68
|
DISTINCT not valid in
subquery of FROM clause
|
|
-67
|
Aggregate not valid in
subquery of FROM clause
|
|
-66
|
Redundant Fields Found in
SELECT list
|
|
-65
|
Positive integer constant
or variable expected
|
|
-64
|
Incompatible SELECT list
is used in INSERT
|
|
-63
|
Data Exception - invalid
escape character
|
|
-62
|
Additional new values
expected for INSERT/UPDATE
|
|
-61
|
Cursor not updateable
|
|
-60
|
An action (%ALTER,
SELECT, UPDATE, etc.) expected
|
|
-59
|
Cannot have more than one
field
|
|
-58
|
Duplicate field found in
trigger UPDATE of <fieldlist> clause
|
|
-57
|
Trigger specifies WHEN
clause when trigger language not SQL
|
|
-56
|
Action not applicable to
an object of this type
|
|
-55
|
Invalid GRANT role TO or
REVOKE role FROM
|
|
-54
|
Array designator (last
subscript omitted) expected after VALUES
|
|
-53
|
Constant or variable
expected as new value
|
|
-52
|
Cursor (Already/Was Not)
DECLAREd
|
|
-51
|
SQL statement expected
|
|
-50
|
Trigger specifies UPDATE
OF <fieldlist> clause when trigger language not SQL
|
|
-49
|
Trigger REFERENCING
clause cannot be specified when trigger language not SQL
|
|
-48
|
Invalid trigger
REFERENCING clause for the trigger's event
|
|
-47
|
Illegal characteristic
keyword for this type of create operation
|
|
-46
|
Missing EXECUTE or FETCH
|
|
-45
|
Duplicate query methods
within the same statement
|
|
-44
|
Duplicate characteristics
when creating a query, method, or procedure
|
|
-42
|
Closing quotes
("") missing following pattern match
|
|
-41
|
An extrinsic function
call must have the form '$$tag^routine(...)'
|
|
-39
|
No RowID field for table
|
|
-38
|
No master map for table
|
|
-37
|
SQL
Scalar/Aggregate/Unary function not supported for Stream fields
|
|
-36
|
WITH CHECK OPTION
(CHECKOPTION class parameter) not allowed for a non-updatable view
|
|
-35
|
INSERT/UPDATE/DELETE not
allowed for non-updatable view
|
|
-34
|
%INORDER: FROM order
inconsistent with outer join order
|
|
-33
|
No field(s) found for
table
|
|
-32
|
Outer-join symbol ( =* or
*= ) must be between two fields
|
|
-31
|
Field not
(Found/Mapped/Unique) in Table(s)
|
|
-30
|
Table or View not found
|
|
-29
|
Field ambiguous/not found
|
|
-28
|
Host variable name must
begin with either % or a letter
|
|
-27
|
Ambiguous labels for
field
|
|
-26
|
Missing FROM clause
|
|
-25
|
Input encountered after
end of query
|
|
-24
|
Table or View not found
|
|
-23
|
Label is not listed in
FROM
|
|
-22
|
ORDER must specify column
names, not numbers, when after 'SELECT *'
|
|
-20
|
Name conflict in the FROM
list over label
|
|
-19
|
An aggregate function
cannot be used in a WHERE clause
|
|
-18
|
IS (or IS NOT) NULL
predicate can be applied only to a field
|
|
-17
|
A for-condition expected
after the ( in the for-expression
|
|
-16
|
A qualifier SOME or ALL
expected after the FOR in the for-expression
|
|
-15
|
A condition expected
after NOT
|
|
-14
|
A comparison operator is
required here
|
|
-13
|
An expression other than
a subquery expected here
|
|
-12
|
A term expected,
beginning with one of the following: identifier, constant, aggregate, $$, :,
(, +, -, %ALPHAUP, %UPPER, %STRING, or %EXACT
|
|
-11
|
A scalar expression
expected, not a condition
|
|
-10
|
The SELECT list of the
subquery must have exactly one item
|
|
-9
|
Incompatible SELECT lists
used in UNION
|
|
-8
|
Invalid DATEPART code for
DATEPART(), DATENAME(), DATEADD(), or DATEDIFF()
|
|
-7
|
ORDER column is not in
the SELECT list
|
|
-6
|
ORDER must specify column
number, not names, when after UNION
|
|
-5
|
Column number specified
in ORDER does not match SELECT list
|
|
-4
|
A term expected,
beginning with one of the following: identifier, constant, aggregate,
%ALPHAUP, %UPPER, %STRING, %EXACT, $$, :, +, -, (, NOT, EXISTS, or FOR
|
|
-3
|
Closing quote (")
missing
|
|
-2
|
Exponent digits missing
after 'E'
|
|
-1
|
Invalid SQL statement
|
|
0
|
Successful Completion
|
|
100
|
No (more) data
|
No comments:
Post a Comment