Top "Db2" questions

DB2 is a family of database servers developed by IBM.

How to check db2 version

How to check db2 version on Z/OS using only SQL commands? Thanks, Melita

sql db2
DB2 SQL error sqlcode=-104 sqlstate=42601

I am relatively new to DB2 but not to SQL. I am experiencing the below error when trying a SELECT …

sql db2
Equivalent of LIMIT for DB2

How do you do LIMIT in DB2 for iSeries? I have a table with more than 50,000 records and I want …

db2 limit ibm-midrange
Exporting result of select statement to CSV format in DB2

Is there any way by which we can export the result of a select statment to CSV file, just like …

csv db2 export
IsNull function in DB2 SQL?

Is there a performant equivalent to the isnull function for DB2? Imagine some of our products are internal, so they …

sql null db2
SQL Statement with multiple SETs and WHEREs

I am wondering if this is a valid query: UPDATE table SET ID = 111111259 WHERE ID = 2555 AND SET ID = 111111261 WHERE ID = 2724 …

sql db2
determine DB2 text string length

I am trying to find out how to write an SQL statement that will grab fields where the string is …

sql db2
How do I connect to a Websphere Datasource with a given JNDI name?

I'm using Websphere Portal 7.0 and creating a portlet with RAD 8.0. My portlet is trying to make a db2 connection to …

java db2 websphere jndi ibm-rational
INNER JOIN in UPDATE sql for DB2

Is there a way to use joins in update statements for DB2? Google has really let me down on this …

sql db2
insert multiple rows into DB2 database

I want to insert multiple rows into a DB2 table. I have a query that looks like this insert into …

sql db2