DATA TYPES 10162021 1 10162021 2 1 Elementary

  • Slides: 21
Download presentation
DATA TYPES 10/16/2021 1

DATA TYPES 10/16/2021 1

10/16/2021 2

10/16/2021 2

1) Elementary System Defined Data Types Character (C) Numeric Text(N) Integer(I) Packed(P) Float(F) Date(D)

1) Elementary System Defined Data Types Character (C) Numeric Text(N) Integer(I) Packed(P) Float(F) Date(D) Time(T) Hexadecimal(X) 10/16/2021 3

2) Structured System Defined Data Types All Database Tables 10/16/2021 4

2) Structured System Defined Data Types All Database Tables 10/16/2021 4

3) Elementary User Defined Data Types 10/16/2021 5

3) Elementary User Defined Data Types 10/16/2021 5

4) Structured User Defined Data Types Internal Tables & Field Strings 10/16/2021 6

4) Structured User Defined Data Types Internal Tables & Field Strings 10/16/2021 6

Elementary System Defined Data Types 10/16/2021 7

Elementary System Defined Data Types 10/16/2021 7

Character (C) Data Type Data a(5) type c. Data a(5). Data b. Data :

Character (C) Data Type Data a(5) type c. Data a(5). Data b. Data : a(5), b. a = ‘ABCD’. b = ‘A’. move ‘ABCD’ to a. move ‘A’ to b. Data : a(5) value ‘ABCD’, b value ‘A’. 10/16/2021 8

Numeric Text (N) Data Type Data a(3) type n. a = ‘ 123’. Data

Numeric Text (N) Data Type Data a(3) type n. a = ‘ 123’. Data b(6) type n value ‘ 500029’. Data : c(3) type n value ‘ 123’, d(6) type n value ‘ 500029’. Data e(3) type n. move ‘ 123’ to e. 10/16/2021 9

Integer (I) Data Type Data a type i. a = 125. Data b type

Integer (I) Data Type Data a type i. a = 125. Data b type i value 130. Data : c type i value 135, d type i value 140. Data : e type i. move 145 to e. 10/16/2021 10

Packed Number (P) Data type Data a type p decimals 2. a = ‘

Packed Number (P) Data type Data a type p decimals 2. a = ‘ 123. 45’. Data b type p decimals 2 value ‘ 234. 56’. Data : c type p decimals 2 value ‘ 123. 45’, d type p decimals 2 value ‘ 234. 56’. 10/16/2021 Data e type p decimals 2. 11

Float (F) Data Type Data a type f. a = ‘ 123. 45’. Data

Float (F) Data Type Data a type f. a = ‘ 123. 45’. Data b type f value ‘ 234. 56’. Data : c type f value ‘ 123. 45’, d type f value ‘ 234. 56’. Data e type f. move ‘ 123. 45’ to e. 10/16/2021 12

Date (D) Data Type Data a type d. a = ‘ 20000225’. Data b(8)

Date (D) Data Type Data a type d. a = ‘ 20000225’. Data b(8) type d. b = ‘ 20011226’. Data : c type d value ‘ 20000328’, d(8) type d value ‘ 20011221’. Data : e type d. move ‘ 20011212’ to e. 10/16/2021 13

Time (T) Data Type Data a type t. a = ‘ 081152’. Data b(6)

Time (T) Data Type Data a type t. a = ‘ 081152’. Data b(6) type t. b = ‘ 090231’. Data : c type t value ‘ 081152’, d(6) type t value ‘ 090231’. Data : e type t. move ‘ 101010’ to e. 10/16/2021 14

Hexa Decimal (X) Data Type Data a type x. a = ‘ 01’. Data

Hexa Decimal (X) Data Type Data a type x. a = ‘ 01’. Data b type x value ‘AB’. Data : c(2) type x value ‘ 1234’, d type x value ‘AC’. Data e type x. move ‘A 1’ to e. 10/16/2021 15

Structured System Defined Data Types 10/16/2021 16

Structured System Defined Data Types 10/16/2021 16

Tables sflight. Tables : sflight, sbook. 10/16/2021 17

Tables sflight. Tables : sflight, sbook. 10/16/2021 17

Elementary Types 10/16/2021 User Defined Data 18

Elementary Types 10/16/2021 User Defined Data 18

Types Data Types name(5). Data : name 1 type name, name 2 type name,

Types Data Types name(5). Data : name 1 type name, name 2 type name, name 3 type name, name 4 type name. 10/16/2021 19

Structured User Defined Data Types 10/16/2021 20

Structured User Defined Data Types 10/16/2021 20

Structured User Defined Data Types Internal Tables & Field strings (Will be covered Later)

Structured User Defined Data Types Internal Tables & Field strings (Will be covered Later) 10/16/2021 21