Top "Db2" questions

DB2 is a family of database servers developed by IBM.

DB2 - How to run an ad hoc select query with a parameter in IBM System i Access for Windows GUI Tool

I would like to run some ad hoc select statements in the IBM System I Navigator tool for DB2 using …

sql db2 ibm-midrange iseries-navigator
Configure SQuirreL for DB2

How to configure SQuirreL for DB2 access. In SQuirreL I do see two DB2 drivers. But they are both marked …

db2 squirrel-sql
DB2: Purge large number of records from table

I am using DB2 9.7 FP5 for LUW. I have a table with 2.5 million rows and I want to delete about 1 …

database performance db2 db2-luw
DB2 SQL code to extract stored procedures

My colleagues and I have several hundred SQL stored procedures sitting on a hosted DB2/z database (version 8.1). We have …

sql db2 mainframe zos
DECLARE GLOBAL TEMPORARY TABLE Vs CREATE GLOBAL TEMPORARY TABLE in DB2

am creating a GLOBAL TEMPORARY TABLE in DB2. and when i surfed i got a two way to create 1. Declare 2. …

performance stored-procedures db2 temp-tables
How to get the last insert ID from a table

I want to get the value of the last ID insert in a table. How I can do this?

sql db2
db2 query condition where column not in () while the column value is null

Good day, I have a row of data with a column, call status, the value inside is null. If I …

sql null db2 where-in
Query validation using C#

I am looking for a query validator in C#, which allows me to parse the SQL text from a textbox …

c# sql sql-server db2
DB2 Drop table if exists equivalent

I need to drop a DB2 table if it exists, or drop and ignore errors.

sql db2 sql-drop
What does a timestamp in T-Sql mean in C#?

I'm trying to develop a model object to hold a Sql Server row, and I understand perfectly how to do …

c# sql-server tsql db2