DB2 SQL Exception while executing query

Posted by puki on Stack Overflow See other posts from Stack Overflow or by puki
Published on 2010-03-15T04:24:35Z Indexed on 2010/03/15 4:29 UTC
Read the original article Hit count: 183

Filed under:

sqlexception

|

db2

|

sql

|

error

in DB2 while executing a query i got

SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016

does someone knows what this code means?

© Stack Overflow or respective owner

Related posts about sqlexception

How to throw a SqlException(need for mocking)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am trying to test some exceptions in my project and one of the Exceptions I catch is SQlException. Now It seems that you can't go new SqlException() so I am not sure how I can throw a exception especially without somehow calling the database(and since it is unit tests it is usually advised… >>> More
'Invalid column name [ColumnName]' on a nested linq query.

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got the following query: ATable .GroupBy(x=> new {FieldA = x.FieldAID, FieldB = x.FieldBID, FieldC = x.FieldCID}) .Select(x=>new {FieldA = x.Key.FieldA, ..., last_seen = x.OrderByDescending(y=>y.Timestamp).FirstOrDefault().Timestamp}) results in: SqlException: Invalid column name… >>> More
Oracle JDBC connection with Weblogic 10 datasource mapping, giving problem java.sql.SQLException: Cl

as seen on Stack Overflow - Search for 'Stack Overflow'
Oracle JDBC connection with Weblogic 10 datasource mapping, giving problem java.sql.SQLException: Closed Connection I am using weblogic 10 JNDI datasource to create JDBC connections, below is my config http://www.bea.com/ns/weblogic/920.xsd" XL-Reference-DS jdbc:oracle:oci:@abc.XL.COM … >>> More
java.sql.SQLException: SQL logic error or missing database

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I ahve created database connection with SQLite using JDBC in java. My sql statements execute properly. But sometimes I get the following error while i use conn.commit() java.sql.SQLException: SQL logic error or missing database Can anyone please help me how to avoid this type of… >>> More
java.sql.SQLException: SQL logic error or missing database, SQLite, JDBC

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I ahve created database connection with SQLite using JDBC in java. My sql statements execute properly. But sometimes I get the following error while i use conn.commit() java.sql.SQLException: SQL logic error or missing database Can anyone please help me how to avoid this type of… >>> More

Related posts about db2

link DB2 AS/400 (system i) and DB2 AIX

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, everybody. I have two different database in DB2, a in DB2 AS400 and other in DB2 AIX, is possible link this database, similar to link by Oracle? Thank you in advance. erva. >>> More
Speed-start your Linux App: Using DB2 and the DB2 Control Center

as seen on Internet.com - Search for 'Internet.com'
This article guides you through setting up and using IBM DB2 7.2 with the Command Line Processor. You'll also learn to use the graphical Control Center, which helps you explore and control your databases, and the graphical Command Center, which helps you generate SQL queries. Other topics covered… >>> More
DB2 LUW Security - The DB2 DBA as a Locksmith

as seen on Internet.com - Search for 'Internet.com'
Database security should have multiple locks at multiple layers with multiple keys (and perhaps some barbed wire, an electric fence, a moat and a mean junkyard dog as well). With all these locks and keys, some locksmith skills are certainly useful. Rebecca Bond introduces some of her favorite DB2… >>> More
Why can't Perl's DBD::DB2 find dbivport.h during installation?

as seen on Stack Overflow - Search for 'Stack Overflow'
We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error: ERROR BUILDING DB2.pm [lijumathew@intblade03 DBD-DB2-1.78]$ make make[1]:… >>> More
DBI::DBD package not getting installed for Perl?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error. ERROR BUILDING DB2.pm [lijumathew@intblade03 DBD-DB2-1.78]$ make make[1]:… >>> More