sql « db2 « Java Database Q&A

1. Best Approach for Cloning database records using SPs    stackoverflow.com

I have to write code to clone a database entry with associated data in other tables and assign it a new ID. Simplified I have a MAIN Table ...

2. How can I treat a sequence value like a generated key?    stackoverflow.com

Here is my situation and my constraints:

  1. I am using Java 5, JDBC, and DB2 9.5
  2. My database table contains a BIGINT value which represents the primary key. For various reasons that ...

3. Is "LIKE ?" More efficient than LIKE '%'||?||'%'    stackoverflow.com

Recently one of my colleagues made a comment that I should not use

LIKE '%'||?||'%'
rather use
in the SQL and then replace the LIKE ? marker ...

4. How to Set CSSID in jdbc db2 using java    stackoverflow.com

My current task is to migrate a remote database to a localhost database. Everything seems fine up to now. The problem is when I'm checking whether the data are the same, ...

5. Application ID from db2 8.1.5 on Z/OS    stackoverflow.com

I have been searching how to get application Id from db2 8.1.5 on Z/OS(remote). I found this link: http://www.ibm.com/developerworks/data/library/techarticle/0302stolze/0302stolze.html In this link, it is said that there is not built-in function(application_id) ...

6. SQL dialect in H2    stackoverflow.com

I have a file which contains SQL "insert" statements. I open this file, read it and then try to insert it in the database(table is already there). Statements are of the ...

7. How to run .sql file in db2?    coderanch.com

8. Dynamic SQL Parallelism with DB2    coderanch.com

9. DB2 Update Sql based on calculation    coderanch.com

11. Difference between DB2 and SQL    coderanch.com

12. db2 SQL    coderanch.com