logo  
Google
 

DB2 SQL-Error: -142

SQLState: 42612

Short Description: THE SQL STATEMENT IS NOT SUPPORTED

An SQL statement was detected that is not supported by the database. The statement might be valid for other IBM relational database products or it might be valid in another context. For example, statements such as VALUES and SIGNAL or RESIGNAL SQLSTATE can appear only in certain contexts, such as in a trigger body or in an SQL Procedure. Additionally, This SQL code will also be issued if a distributed private protocol application uses SQL statements that were implemented after Version 7. DB2 limits the SQL statements that a distributed private protocol application can use to Version 7 or lower SQL statements. See Part 4 of DB2 Application Programming and SQL Guide for more information. System action: The statement cannot be executed. Programmer response: Change the syntax of the SQL statement or remove the statement from the program.

 <-  BACK TO INDEX