Top "Db2" questions

sort query result without selecting that column but sort by that column?

I have a query, I have to sort the result from the DB2 database. The query will select the columns …

sql database sorting db2

How to write a query to ensure email contains @

I'm creating a database in db2 and I want to add a constrain to validate whether the user inserting a …

sql db2 check-constraints

How to combine date and time into a timestamp in db2?

In a db2 database I have a DATE column and a TIME column, how can you combine these into a …

sql date time db2 timestamp

How can we View the DB2 Procedure and How can we execute the DB2 Procedure and just see the output of the procedure using DB2

How can we View the DB2 Procedure (I mean what logic they have written ) and How can we execute the …

db2 db2-400

DB2 vs PostgreSQL vs SQL Server

Has anyone used all three of these databases? What are your experiences with them? PostgreSQL looks pretty tempting for a …

sql-server postgresql db2

SQL query of multi-member file on AS400

On AS400 in interactive SQL in a 5250 session, select * from myfile returns rows from one member only when myfile has …

sql jdbc db2 ibm-midrange jt400

Connect to IBM DB2 with SQuirreL "Reply.fill(). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001"

I have now tried 2 days to connect to external DB2 database with SQuirreL. I always get error: [jcc][t4][2030][11211][3.58.82] A …

jdbc db2 squirrel-sql

java.lang.UnsatisfiedLinkError while loading DB2 JDBC driver

I try to use jboss-seam with a db2 database, the following error occurs com.ibm.db2.jcc.a.SqlException: [jcc][10389][12245][3.52.95] …

java macos jdbc db2

how can I rename a table / move to a different schema in sql DB2?

I am trying to rename a table in db2 like so rename table schema1.mytable to schema2.mytable but getting …

db2 rename db2-luw

pad varchar numbers with 0s in db2

Is there a way to pad 0s before numbers stored as VARCHAR in DB2? Like this: some_column result ----------- …

db2 padding