DB2 TIPS

DB2 is the short name used for DATABASE 2. It is relational database product developed by IBM. This relational database management system was released by IBM in 1983 for MVS operating system. A RDBMS system represents all information in the form of tables. A table is a two dimensional array with horizontal rows and vertical columns.

DB2 TIPS

This section contains some very basic DB2 tips. Please keep coming to this page for more such tips.

DB2 query to select first or last N rows

Description of a DB2 Table

Difference in number of days

CONTOKEN Verification

Update Table using other Table

Update a column using other column in Table

Adding Primary Key on exisitng DB2 Table

Changing the primary key on existing DB2 Table

Create a DB2 Table

; ; ; ;

Creating Primary Key while creating DB2 Table

Drop Index of a DB2 Table

Drop Primary Key on DB2 Table

Drop Table DB2

Wildcard character percent in DB2

Wildcard character underscore in DB2