This part presents different information types utilized in DB2.

Introduction

In DB2 Database tables, every segment has its own information type contingent upon designer's prerequisites. The information type is said to be type and scope of the qualities in segments of a table.

Built-in data types

• Datetime
  • TIME: It speaks to the time in hours, minutes and seconds.
  • TIMESTAMP: It speaks to seven estimations of the date and time as year, month, day, hours, minutes, seconds and microseconds.
  • DATE: It speaks to date of the day in three sections as year, month and day.
• String
  • Character

• CHAR (fixed length): Fixed length of Character strings.
  • Varying length
• VARCHAR: Varying length character strings.
• CLOB: large object strings, you use this when a character string might exceed the limits of the VARCHAR data type.
  • Graphic
• GRAPHIC
  • Fixed length: Fixed length graphic strings that contains double-byte characters
  • Varying length
• VARGRAPHIC: Varying character graphic string that contains double bye characters.
• DBCLOB: large object type
  • Binary
• BLOB(varying length): binary string in large object
• BOOLEAN: In the form of 0 and 1.
• Signed numeric
  • Exact
• Binary integer
  • SMALLINT [16BIT]: Using this you can insert small int values into columns
  • INTEGER [32BIT]: Using this you can insert large int values into columns
  • BIGINT [64BIT]: Using this you can insert larger int values into columns
• Decimal
  • DECIMAL (packed)
  • DECFLOAT(decimal floating point): Using this, you can insert decimal floating point numbers
  • Approximate
• Floating points
  • REAL(single precision): Using this data type, you can insert single precision floating point numbers.
  • DOUBLE(double precision): Using this data type, you can insert double precision floating point numbers.
• eXtensible Mark-up Language
  • XML: You can store XML data into this data type column.