-1

NULL INDICATOR VARIABLE REQUIRED FOR OUTPUT HOST VARIABLE NUMBER nnn

-2

EMPTY QUERY STRING

-3

CANNOT REVOKE FROM YOURSELF

-4

OVERFLOW:DATATYPE <x> OPERATION <x>

-5

TABLE tablename IN DDD AND NOT IN CXX

-6

STRING CONSTANT TOO LONG

-7

INCOMPLETE STRING. CHECK FOR MISSING QUOTES

-8

CANNOT GRANT TO YOURSELF

-9

ILLEGAL COLUMN NAME: aaaa

-10

UNABLE TO ALLOCATE MEMORY

-12

COLUMN FUNCTIONS NOT ALLOWED IN SET CLAUSE OF QUERY

-14

TABLE/VIEW DOES NOT EXIST:(table/new-name) AUTHID:(auth-id)

-15

AUTHID (auth-id) NOT DEFINED

-16

DEPENDENT PLAN (auth-id.plan-name) IN USE

-17

MODIFICATION OF COLUMN TO INCOMPATIBLE DATATYPE IS NOT ALLOWED

-18

CHECK OPTION IS NOT ALLOWED ON NON-UPDATABLE VIEWS

-19

INDEX AND TABLE AUTHIDS DO NOT MATCH: aaaa, bbbb

-20

SYNTAX-LAST TOKEN(S): description

-21

DEFAULT CHARACTER STRING TOO LONG

-24

VIEWS CONTAINING FUNCTIONS OR GROUP BY CANNOT BE JOINED

-25

INCOMPLETE COMMENT

-26

EXCEEDS MAX NUMBER OF TABLES/VIEWS PERMITTED IN SUBSELECT

-27

CANNOT USE GROUP BY IN QUERY THAT REFERENCES A GROUPED VIEW

-30

SQL IDENTIFIERS MAY NOT EXCEED 32 BYTES IN LENGTH

-31

CANNOT REFERENCE A VIEW CONTAINING SELECT DISTINCT IN THIS STATEMENT

-32

STATEMENT IS TOO LARGE TO COMPILE

-33

AMBIGUOUS COLUMN REFERENCE: x...x

-34

ILLEGAL CORRELATION NAME nnnn

-35

TTM IS UNUSABLE: SQLCODE xxx, DB RC yy(zzz) ON INITIALIZATION

-36

BAD FOREIGN KEY: reason code,A,B,C,D,E,F,G

-37

CONSTRAINT REBIND FAILED: A,B,C,D,E,F

-38

DB2 TRANSPARENCY OPTION IS NOT INSTALLED

-39

NEGATIVE RESULT FOR UNSIGNED DECIMAL TARGET

-40

CONSTRAINT AUTO-REBIND IN PROGRESS. PLEASE TRY AGAIN.

-41

DATATYPES OF OPERATION op-string NOT COMPATIBLE

-42

INVALID USE OF ESCAPE CHARACTER IN PATTERN OF LIKE PREDICATE

-43

COLUMN FUNCTION ON INVALID TYPE

-44

INPUT HOST VARIABLE NUMBER <xxx> HAS INVALID DATA TYPE <zzz>

-53

STRING TOO LONG FOR COLUMN nnn

-54

UNEQUAL NUMBER OF COLUMNS AND VALUES

-55

DUPLICATE NAMES IN INSERT/ALTER/CREATE LIST: aaaa

-56

entity-type entity-name ALREADY EXISTS

-57

SPECIFIED MORE COLUMNS OR VALUES THAN THE TABLE HAS

-58

COLUMN aaaa TYPE INCOMPATIBLE WITH bbbb TYPE

-60

nnnn IS GREATER THAN MAXIMUM ALLOWABLE NUMBER OF COLUMNS

-66

ILLEGAL NUMBER nnnn IN ORDER SPECIFICATION

-67

COLUMN FUNCTIONS NOT ALLOWED IN WHERE CLAUSE OF QUERY

-69

TOO MANY SET CLAUSES IN UPDATE COMMAND

-70

ORDERING BY COLUMN aaaa THAT IS NOT SELECTED

-71

SELECTING MORE THAN ONE ITEM IN A SUBQUERY

-72

CANNOT NEST COLUMN FUNCTIONS

-73

SELECTED COLUMNS MUST BE IN THE GROUP BY CLAUSE

-75

CANNOT USE COLUMN FUNCTIONS WITH NO GROUP BY CLAUSE

-76

colName IN HAVING NOT GROUP COLUMN OR COLUMN FUNCTION ARGUMENT

-79

UPDATE/DELETE WHERE CURRENT OF cursorname ON READ ONLY CURSOR

-80

ONLY ONE DISTINCT CLAUSE ALLOWED PER QUERY

-82

EACH QUERY IN A UNION MUST HAVE THE SAME NBR OF PROJECTED COLUMNS

-83

DATA TYPES IN COLUMN aaaa DO NOT MATCH

-84

ORDER BY ITEMS MUST BE CONSTANTS FOR UNION OF QUERIES

-85

ORDER BY MUST FOLLOW ALL QUERIES WHEN PERFORMING A UNION

-86

NULL NOT ALLOWED IN COLUMN aaaa

-87

CANNOT USE <UNION> AND <UNION ALL> IN SAME STATEMENT

-101

A SYNONYM ON A SYNONYM IS NOT ALLOWED

-103

MUST USE COLUMN FUNCTIONS IF HAVING CLAUSE WITH NO GROUP BY

-105

aaa IN bb

-110

ORDER BY IS NOT ALLOWED IN A VIEW DEFINITION

-111

THE VIEW IS NOT UPDATABLE BECAUSE IT CONTAINS A SUBQUERY

-113

THE VIEW'S COLUMN IS NOT UPDATABLE: aaaa

-117

RAAT/CBS ERROR: CMD=xxxxx TBL=ttt DBID=nnnn KEY=kkkkk RC=rr (iii)

-118

DSF dsf-code ERROR OCCURRED DURING SQL DSF PROCESSING

-119

product_name: error_text

-120

PROGRAM TIMESTAMP timestamp-in-decimal NOT = PLAN TIMESTAMP timestamp-in-decimal

-121

STATEMENT REBIND ERROR

-122

STATEMENT aaaa NOT FOUND

-123

PLAN ALREADY EXISTS

-124

PLAN authid.planname DOES NOT EXIST

-125

PLAN CURRENTLY IN USE

-126

NO MORE WORK SPACE

-127

sql-object-name NOT FOUND

-128

LUW ABORTED

-129

RRS COMMIT ROLLBACK

-130

CURSOR NOT UPDATEABLE

-131

RESULT TABLE LENGTH TOO LONG

-132

INVALID PLAN OPTION: STRING DELIMITER

-133

CURSOR NAME aaaa NOT DECLARED

-134

UNKNOWN DYNAMIC/CURSOR STATEMENT-ID (aaaa)

-135

INVALID CURSOR STATE (STMT-ID=aaaa)

-136

SQLDA TRUNCATED - NEEDED aaaa ENTRIES

-137

PLAN OPTION CBSIO EXCEEDED

-138

INVALID PLAN OPTION: PRIORITY

-139

INVALID PLAN OPTION: TIMEMIN

-140

INVALID PLAN OPTION: TIMESEC

-141

INVALID PLAN OPTION: CLOSE OPTION

-142

MORE THAN 1 ROW SELECTED

-143

INVALID PLAN OPTION: DECPOINT

-144

TRX ISOLATION LEVELS UNMATCHED

-145

INVALID PLAN OPTION: ISOLEVEL

-146

AUTHORIZATION ID LENGTH > 18

-147

OP. NOT ALLOWED AT ISOL. LEVEL U

-148

SUBQUERY AT LVL aaaa NBR bbbb RETURNED MORE THAN 1 ROW

-149

PLAN CAN'T SPECIFY DATACOM SQLMODE WHEN MUF OPTION SPECIFIES ANSI

-150

AUTHORIZATION ID MUST MATCH SCHEMA'S AUTHORIZATION ID

-151

INVALID PRECISION OR SCALE SPECIFICATION ON aaaa

-152

MAXIMUM NUMBER OF TABLES EXCEEDED FOR OPERATION

-153

DUPLICATE CURSOR NAME DETECTED

-155

NUMBER OF COLUMNS IN VIEW NOT EQUAL TO NUMBER IN QUERY

-156

VIEW xxx WITH CHECK OPTION VIOLATION

-157

TTM INIT. FAILED. SQL CODE xxx, DB RC yy(zzz).

-158

CANNOT CREATE SYNONYM FOR INVALID VIEW aaaa

-159

HOST VARIABLE INCOMPATIBLE WITH COLUMN AT POSITION aaaa

-161

colname datatype(prec,scale) INVALID DATA: hh

-162

CANNOT INSERT AND SELECT ON THE SAME TABLE

-163

MORE THAN 1 DEFAULT SPECIFIED FOR A COLUMN

-164

CHARACTER DEFAULT MORE THAN 20 BYTES

-165

DUPLICATE CONSTRAINT NAME: nnnnnnnn mmmmmmmm

-166

TBL authid.tblname CHECK PENDING

-167

DOMAIN CONSTRAINT nnnnnnnn.mmmmmmmm VIOLATION

-168

THE TABLE ALREADY HAS A PRIMARY KEY, ONLY ONE MAY BE DEFINED

-169

THE REFERENCED COLUMNS DID NOT REFER TO A CANDIDATE KEY

-171

THE REFERENCED TABLE DOES NOT CONTAIN A PRIMARY KEY

-172

THE NUMBER OF REFERENCING AND REFERENCED COLUMNS DOES NOT MATCH

-173

THE REFERENCING AND REFERENCED COLUMNS ARE NOT EQUIVALENT

-174

UPDATE/DELETE CANNOT HAVE CORRELATED SUBQRY

-175

FOREIGN KEY <authid.constraintname> REFERENCE VIOLATION

-176

FOREIGN KEY <authid.constraintname> VALUE VIOLATION

-177

PRIMARY/UNIQUE CONSTRAINT CANNOT BE DROPPED DUE TO REFERENCE

-178

WITH CHECK OPTION CANNOT BE DROPPED FROM A VIEW DEFINITION

-179

CONSTRAINT NOT FOUND mmmmm nnnnn

-180

ROW HELD BY PREVIOUS LOGICAL UNIT OF WORK WAS DELETED

-181

ROW HELD BY PREVIOUS LOGICAL UNIT OF WORK WAS UPDATED

-182

UNIQUE/PRIMARY CANNOT BE SPECIFIED DUE TO NULL ON nnnnnn

-183

MUST SPECIFY DATACOM SQLMODE FOR CURSORS TO SURVIVE UNITS OF WORK

-184

COLUMN NAME LIST REQUIRED ON CREATE VIEW CONTAINING NON-SIMPLE COLUMN

-185

accessor-id HAS NO action-type AUTHORITY ON object

-188

TABLE CANNOT BE DROPPED BECAUSE IT IS REFERENCED

-189

NO RESULT FORMAT SPECIFIED

-190

OPERAND 1 OR RESULT FORMAT MUST BE INTERNAL TO DO CONVERSION

-191

BOTH OPERANDS MUST BE IN INTERNAL FORMAT

-192

RESULT FORMAT MUST BE INTERNAL TO DO VERIFICATION

-193

CENTURY nn IS LARGER THAN 99

-194

IT IS INVALID TO ADD xx AND zz DATATYPES

-195

IT IS INVALID TO SUBTRACT xx AND zz DATATYPES

-198

YEAR yy IS LARGER THAN 99

-199

MONTH mm IS NOT BETWEEN 1 AND 12 INCLUSIVE

-201

HOUR hh OUT OF RANGE

-202

MINUTE mm OUT OF RANGE

-203

SECOND ss OUT OF RANGE

-204

MICROSECOND ssssss GREATER THAN 99

-205

INVALID DATATYPE xx FOR SCALAR FUNCTION nn

-206

OP2 NOT ALLOWED IF OP1 IS A TIMESTAMP FOR SCALAR FUNCTION CHAR

-207

RESULT DATATYPES IN CASE/COALESCE/NULLIF EXPRESSION ARE INCOMPATIBLE

-208

CASE EXPRESSION MUST CONTAIN AT LEAST ONE NON-NULL RESULT EXPRESSION

-209

operation DISALLOWED ON object

-210

ROLLBACK INCOMPATIBLE WITH USE OF RESOURCE RECOVERY SERVICES

-214

ARRAY INDEX MUST BE A LITERAL IN THIS CONTEXT

-215

<COLUMN-NAME> INDEX INDEX-value MUST BE BETWEEN lower-limit AND upper-limit INCLUSIVE

-216

BAD ARRAY VALUE: reason

-217

disallowed-language-element NOT ALLOWED disallowed-context

-219

JULIAN DATE HAS GONE NEGATIVE: dddd

-223

A TIME STRING CANNOT CONTAIN MORE THAN ONE A: aa

-224

A TIME STRING CANNOT CONTAIN MORE THAN ONE P: pp

-225

A TIME STRING CANNOT CONTAIN MORE THAN ONE BLANK BEFORE THE A OR P

-226

NO M AFTER THE A OR P OR TOO MANY COLONS IN A TIME STRING

-227

THERE MUST BE AN M AFTER THE A OR P IN A TIME STRING

-228

TOO MANY NODES IN CHARACTER STRING: node count is n

-229

TOO MANY DIGITS PER NODE IN STRING: xxxx

-230

THE VALUE OF A NODE IS OUT OF RANGE: xxxx

-231

NUMBER OF SLASHES IS n, ONLY TWO ALLOWED: xxxx

-232

NO AM OR PM FOUND IN TIME CHARACTER STRING WITH ONE COLON: xxxx

-233

NUMBER OF COLONS MUST BE 1 OR 2. FOUND n

-234

FOUND AN M BUT NO A OR P TO GO WITH IT: xxxx

-235

NUMBER OF PERIODS CAN ONLY BE 2. FOUND n

-236

NUMBER OF DASHES CAN ONLY BE 3. FOUND n

-237

NUMBER OF DIGITS FOR MICROSECONDS CANNOT EXCEED 6, FOUND n: xxxx

-238

UNRECOGNIZABLE DATE/TIME FORMAT: xxxx

-241

SQL REFERENTIAL INTEGRITY IS NOT ALLOWED ON A DL1/T TABLE

-242

CONFLICT ALTERING COLUMN xxx

-243

ANSI EXTENSION

-244

REJECT OF NON-ANSI SQL-86 FEATURE (SQLMODE=ANSI/FIPS)

-245

CONFLICTING SECURITY MODES

-246

INVALID AREA NAME

-247

accessor-id HAS NO CREATE SCHEMA AUTHORITY

-248

accessor-id HAS NO AUTHORITY TO USE "GRANTED BY" FORM OF REVOKE

-249

REFERENCED TABLE aaa.ttt PLUS n OTHERS IN CHECK STATUS

-250

EXCEPTION TABLE authid.tblname NOT FOUND

-251

TABLE HAS NO CONSTRAINTS

-252

TABLE NOT IN A CHECK STATE

-254

REVOKE WOULD CASCADE BUT "CASCADE" NOT SPECIFIED

-255

COLUMN xxx NOT NULL WITHOUT DEFAULT

-256

RQA TOO LARGE FOR TABLE ttt

-257

FOREIGN KEY COLUMN xxx NOT FOUND

-258

TABLE FULL - DBID=nnnn INTERNAL NAME aaa

-259

INDEX FULL - DBID=nnnn

-260

UNIQUE CONSTRAINT constraint-name DUPLICATES KEY key-name

-261

UNIQUE constraint-name COLUMN column-name NOT FOUND

-262

REFERENCING TABLE xxx.xxx IN CHECK-RELATED STATE

-263

DUPLICATE KEY <keyname> VALUE REJECTED DBID <dbid> TBL <tbl>

-264

INDEX ALREADY EXISTS xxx

-265

INDEX DOES NOT EXIST xxx

-269

FOREIGN KEY LOOP

-272

ERROR DURING AUTOMATIC REBINDING OF VIEW authid.viewname

-273

GRANT AND REVOKE STATEMENTS NOT ALLOWED

-274

CANNOT CREATE AN INDEX ON A VIEW

-275

TOO MANY HOST VARIABLES nnn

-276

TOO FEW HOST VARIABLES nnn

-277

aaaa RECEIVED UNKNOWN DURATION TYPE

-278

INVALID PREC(xxx) OR SCALE(zzz) FOR DECIMAL DATATYPE

-279

INVALID DATE TABLE INDEX (xxx)

-280

INVALID TIME TABLE INDEX (xxx)

-281

INVALID TIMESTAMP TABLE INDEX (xxx)

-282

NO OPERAND NODE RECEIVED

-283

NO OPERAND VALUE RECEIVED

-284

NON-NUMERIC ITEM FOUND <x> IN STRING <aaaa>

-286

SUBSTR FUNCTION ARGUMENTS <START=aaaa, LENGTH=bbbb> ARE OUT OF RANGE

-287

DL1/T CONSTRAINT ENFORCEMENT MODULE DLSERV NOT FOUND

-289

<x> LITERAL <y> TOO LARGE/SMALL

-290

DATATYPE OF FIRST OPERAND OF LIKE NOT CHARACTER STRING

-291

INDEX <xxxxx> NOT IN SEQUENCE

-292

<nnn> HOST VARIABLES FOR <nnn> SELECT LIST COLUMNS

-293

PREDICATE INVALID BECAUSE HOST VARIABLE <nnn> HAS THE NULL VALUE

-294

INVALID MIXED DATA IN VALUE ASSIGNED TO column_name

-296

INVALID MIXED DATA IN COLUMN column_name

-297

INVALID MIXED DATA IN LIKE PATTERN

-298

INVALID MIXED DATA IN VARGRAPHIC OPERAND

-299

LIKE ESCAPE OPTION NOT ALLOWED WITH MIXED DATA

-300

CANNOT EXECUTE UNPREPARED/INVALID STATEMENT statement_name

-301

PREPARE OF SELECT REJECTED - CURSOR cursor_name IN OPEN STATE

-302

INVALID USE OF PARAMETER MARKER

-303

STATEMENT-NAME OF CURSOR cursor_name NOT PREPARED SELECT STATEMENT

-304

CANNOT DESCRIBE UNPREPARED STATEMENT statement_name

-305

SQLDA HAS count HOST VARIABLES - STATEMENT HAS count PARAMETER MARKERS

-306

STATEMENT TYPE CANNOT BE PREPARED

-307

STATEMENT-NAME statement_name CAN ONLY BE USED WITH ONE CURSOR

-308

PREPARE HOST VARIABLE SOURCE STATEMENT LENGTH INVALID

-309

HOST VARIABLES CANNOT BE USED IN DYNAMICALLY PREPARED STATEMENTS

-310

COMBINATION OF CHECKPLAN=checkplan_value, CHECKWHO=checkwho_value, AND CHECKWHEN=checkwhen_value IS INVALID

-311

EMBEDDED UPDATE OR DELETE REFERENCES DYNAMIC CURSOR

-312

NO SQLDA FOR EXECUTE OF A STATEMENT WITH PARAMETER MARKERS

-313

NO SUCH PRIVILEGE IS grantable or revokable ON object_name

-314

EXTERNALLY SECURED PLANS REQUIRE AUTHID.PLAN-NAME < 26 BYTES

-315

ONLY THE PLAN CREATOR MAY MODIFY PLAN SECURITY OPTIONS DURING REBIND

-316

%s.%s OUTSIDE SCOPE OF JOINED TABLE

-317

CURSOR cursor-name ERROR: MULTIPLE stmt-type STATEMENTS ATTEMPTED

-317

CURSOR REQUIRED ERROR: CURSOR REQUIRED FOR NON-DYNAMIC SELECT

-318

URI=YES IS REQUIRED FOR SQL TO USE TABLE (DATACOM-NAME) ttt DBID nnnny

-319

LUW IS TIMING OUT - TRY AGAIN (LUWID=luw-id-string, TASK=task-nbr, JOB=job-name)

-320

message describing user error

-321

INVALID SQLCODE sqlcode HAS BEEN GENERATED

-322

INVALID SQLSTATE

-323

LUW STATEMENT LIMIT OF x STATEMENTS EXCEEDED - TRY A COMMIT

-324

INVALID NUMERIC LITERAL n

-326

MAXIMUM NUMBER (number) OF DIAGNOSTICS AREAS EXCEEDED

-435

USER CONDITION user-cond-name SIGNALLED WITH NO ATTACHED ERROR MESSAGE

-436

RESIGNAL FOR SQLSTATE sqlstate REQUESTED WHEN HANDLER NOT ACTIVE

-437

NO HANDLER EXISTS FOR USER-DEFINED CONDITION NAME name-string

-438

SQLSTATE sqlstate-value WAS SIGNALLED WITH NO ATTACHED ERROR MESSAGE

-439

sqlstate-value IN handler-name:error-description

-502

CURSOR ALREADY OPEN

-503

SQL REJECTED INVALID INPUT FOR REASON

-504

PLAN OPTION ERROR: error-string

-505

ON-CLAUSE ERROR: x NOT ALLOWED

-530

PROC authid.name: msg-string

-531

PROC authid.name: msg-string

-532

TRIG authid.name: msg-string

-533

TRIG authid.name: msg-string

-534

msg-string

-535

PROC authid.name: msg-string

-537

msg-string

-559

SECURITY NOT ENABLED

-560

TEMPORARY TABLE AREA (TTM) FULL

-561

TTM TOO SMALL, SEE ERROR ACTION

-562

INVALID DATACOM NAME

-563

INVALID ORDER: <aaa>---USE 'ASC' OR 'DESC'

-564

ONLY ONE PRIMARY KEY MAY BE DEFINED

-565

HEX LITERALS MUST HAVE EVEN NUMBER OF HEX DIGITS: xxx

-566

INVALID HEX DIGIT IN HEX LITERAL <xxxx>--USE 0-9, A-F

-985 -998

SQLnnnn: xxxx ...

-999

INTERNAL ERROR (file-name LINE line-number): specific-error