Db2 SQL codes for SQL DI
Db2 updates the following SQL codes to support SQL DI.
Error (−) SQL codes
- -154
- THE STATEMENT FAILED BECAUSE VIEW OR TABLE DEFINITION IS NOT VALID. See -154 for details.
- -356
- COLUMN OR KEY EXPRESSION expression-number IS NOT VALID, REASON CODE = reason-code. See -356 for details.
- -390
- OBJECT object-name, SPECIFIC NAME specific-name, IS NOT VALID IN THE CONTEXT WHERE IT IS USED. See -390 for details.
- -20058
- THE FULLSELECT SPECIFIED FOR MATERIALIZED QUERY TABLE table-name IS NOT VALID. See -20058 for details.
- -20474
- PERMISSION OR MASK CANNOT BE CREATED FOR THE object-name OBJECT OF THE object-type TYPE. REASON CODE reason-code. See -20474 for details.
- -20524
- INVALID PERIOD SPECIFICATION OR PERIOD CLAUSE FOR PERIOD period-name. REASON CODE = reason-code. See -20524 for details.
- -20577
- SQL DATA INSIGHTS HAS NOT BEEN CONFIGURED IN Db2, REASON reason-code. See -20577 for details.
- -20578
- MODEL COLUMNS CANNOT BE DETERMINED FOR FUNCTION function-name. See -20578 for details.
- -20579
- IN FUNCTION function-name MODEL COLUMN column-name FROM MODEL model-name CANNOT BE USED, REASON reason-code. See -20579 for details.
- -20580
- IN AI FUNCTION function-name, ARGUMENT n IS NOT USABLE, REASON reason-code. See -20580 for details.
Success (0) and warning (+) SQL codes
- +20577
- The function-name FUNCTION RETURNS A WARNING. REASON reason-code. See +20577 for details.