Top "Db2" questions

SQL Developer "disconnected from the rest of the join graph"

I have the following SQL: select <misc things> from pluspbillline left outer join workorder on workorder.siteid=pluspbillline.…

sql db2 oracle-sqldeveloper

Regular Expressions in DB2 SQL

(Other than using a UDF) Any REGEXP-In-SQL support for DB2 9.7 ?

sql regex db2

Update 1 field in a table from another field in a different table (OS400, not a 1 to 1 relationship)

Im trying to update a field in a table from another field in a different table. The table being updated …

sql db2 sql-update ibm-midrange

how to connect hibernate and DB2

I am running an application that used struts and hibernate. I am currently using Derby database. Now i have to …

java hibernate struts db2

JdbcTemplate.update() insert return values

JdbcTemplate.update() returns number of rows affected - so you not only know that delete/update was sucessfull, you also …

java spring-mvc db2 spring-jdbc jdbctemplate

Cannot use group by and over(partition by) in the same query?

I have a table myTable with 3 columns. col_1 is an INTEGER and the other 2 columns are DOUBLE. For example, col_1={1, 2}, …

sql group-by db2 partition-by

Is Null Greater Than Any Date Data Type?

I have this query in DB2 SELECT * FROM SOMESCHEMA.SOMETABLE WHERE SYSDATE > @A If the SYSDATE is NULL, would …

sql null db2

Select Query by Pair of fields using an in clause

I have a table called players as follows: First_Id Second_Id Name 1 1 Durant 2 1 Kobe 1 2 Lebron 2 2 Dwight 1 3 Dirk I wish …

sql database db2 in-clause

java.lang.ClassNotFoundException: Class com.ibm.db2.jcc.DB2Driver not found in Worklight platform or project

I try to test an sql adapter that connects to db2 but I get the following result: java.lang.ClassNotFoundException: …

java db2 ibm-mobilefirst

How can I set the current schema for DB2 using Hibernate/JDBC?

I used to use currentSchema=MYSCHEMA; in my JDBC URL connection, but the version of DB2 we're using no longer …

jdbc schema db2