reason-code |
Description |
2 |
TABNO is invalid |
3 |
TNAME is not specified |
4 |
TNAME is ambiguous |
5 |
TABNO doesn't agree with TNAME |
6 |
QBLOCKNO doesn't agree with TNAME |
7 |
PAGE_RANGE is invalid |
8 |
PREFETCH is invalid |
9 |
METHOD is invalid |
10 |
SORTN_JOIN is invalid |
11 |
SORTC_JOIN is invalid |
12 |
ACCESSTYPE is invalid |
13 |
ACCESSCREATOR or ACCESSNAME is invalid |
14 |
TYPE 1 index can't be used with isolation level 'UR' |
15 |
Specified index can't be used as requested |
16 |
Multi-index access can't be done |
17 |
Invalid ACCESSTYPE combination |
18 |
METHOD specified for first table accessed |
19 |
Nested-loop join can't be done as requested |
20 |
Merge join can't be done as requested |
21 |
Hybrid join can't be done as requested |
22 |
PARALLELISM_MODE requested can't be done |
23 |
PARALLELISM_MODE is invalid |
24 |
ACCESS_DEGREE is invalid |
25 |
JOIN_DEGREE is invalid |
26 |
A table is missing |
27 |
A table is redundant |
28 |
PRIMARY_ACCESSTYPE is invalid |
29 |
ACCESS_PGROUP_ID is not specified |
30 |
JOIN_PGROUP_ID is not specified |
31 |
PARALLELISM_MODE is not specified |
32 |
CREATOR or TNAME is invalid |
33 |
Join sequence is incorrect |
34 |
Full outer join requires merge join method |
35 |
WHEN_OPTIMIZE is invalid or inconsistent |
99 |
Unexpected error |
