Table 1. SQL errors 10000 - 10920
| Error code | SQLSTATE value | Class condition | Subclass message |
|---|---|---|---|
| 10002 | 02503 | No data | Tuple not found for the specified TID. |
| 10012 | n0n12 | Flag | ETPL_SCAN_EOP flag is set. |
| 10013 | 02514 | No data | No more records to be fetched. |
| 10100 | 2150b | Cardinality violation | Too many fields specified. |
| 10101 | 02701 | No data | No more records exist. |
| 10102 | 5050c | FairCom DB SQL RDS error | Duplicate record specified. |
| 10104 | 22505 | Data exception | Field size is too high. |
| 10106 | m0m06 | FairCom DB SQL RSS error | Specified index method is not supported. |
| 10107 | n0n07 | Flag | EIX_SCAN_EOP flag is set. |
| 10108 | 2350i | Integrity constraint | Duplicate primary/index key value. |
| 10301 | m030a | FairCom DB SQL RSS error | Table is locked and LCKF_NOWAIT. |
| 10309 | m030a | FairCom DB SQL RSS error | Row locked and NOWAIT specified. |
| 10400 | 22501 | Data exception | Invalid file size for alter log statement. |
| 10920 | 22521 | Data exception | Already existing value specified. |
Table 2. SQL errors 11000 - 11301: RDS
| Error code | SQLSTATE value | Class condition | Subclass message |
|---|---|---|---|
| 11100 | 5050b | FairCom DB SQL RDS error | Indicates invalid transaction ID. |
| 11102 | 5050d | FairCom DB SQL RDS error | Indicates TDS area specified is not found. |
| 11103 | 50504 | FairCom DB SQL RDS error | Indicates TDS not found for binding. |
| 11104 | 50505 | FairCom DB SQL RDS error | Indicates transaction aborted. |
| 11105 | 50506 | FairCom DB SQL RDS error | Indicates active Transaction error. |
| 11109 | 50510 | FairCom DB SQL RDS error | Indicates invalid Transaction handle. |
| 11111 | 50912 | FairCom DB SQL RDS error | Indicates invalid isolation level. |
| 11112 | 50913 | FairCom DB SQL RDS error | Indicates isolation level cannot be changed within active transaction. |
| 11300 | m0m00 | FairCom DB SQL RSS error | Indicates specified INFO type is not supported. |
| 11301 | m0m01 | FairCom DB SQL RSS error | Indicates specified index type is not supported. |