As an application programmer we use TABLES, COLUMNS, ROWS & Indexes.
For more details click on below video.
- Table is a combination of Rows and columns
- Columns are called as ATTRIBUTES. Rows are called as TUPLES.
- Every Table is identified by unique table name, formed between 1-30 alphanumeric characters.
- Every column is identified by unique column name, formed between 1-30 alphanumeric characters.
- Every column should be created with data type length.
DB2 DATA TYPES
- INTEGER
- SMALL INTEGER
- DECIMAL
- CHAR
- VARCHAR
- DATE (YYYY-MM-DD)
- TIME(HH:MM:SS)
- TIMESTAMP(YYYY-MM-DD:HH:MM:SS:NNNNNN)
- GRAPH
- VARGRAPH
For more details click on below video.
ConversionConversion EmoticonEmoticon