Tags

23 pages

SQL

Find time between records in a logging table with DB2

Find Nullable Columns in DB2 with no Null Values

How to Truncate a DB2 Table

DB2: When were index stats last updated on a table?

DB2 Stored Proc Performance Analysis

DB2 Get Current MAX value for all IDENTITY Columns

DB2: How to find records with non-printable characters (SQLSTATE 01517)

How to concatenate multiple columns in a DB2 select statement to return a single column

Extract and insert tables (or portions of them) in DB2 – similar to BCP for Sybase and SQL Server

DB2 Duplicate Key Debugging