15.10 - EMPLOYEE Table - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K

Data for the new EMPLOYEE table is shown below. This information is in the LABSDATA file.

 

EMPLOYEE NUMBER

MANAGER EMPLOYEE NUMBER

DEPARTMENT NUMBER

JOB CODE

LAST NAME

FIRST NAME

HIRE DATE

BIRTH DATE

SALARY AMOUNT

1001

1003

401

412101

Hoover

William

76/06/18

50/01/14

25525.00

1002

1003

401

413201

Brown

Alan

76/07/31

44/08/09

43100.00

1003

801

401

411100

Trader

James

76/07/31

47/06/19

37850.00

1004

1003

401

412101

Johnson

Darlene

76/10/15

46/04/23

36300.00

1005

801

403

431100

Ryan

Loretta

76/10/15

55/09/10

31200.00

1006

1019

301

312101

Stein

John

76/10/15

53/10/15

29450.00

1007

1005

403

432101

Villegas

Arnando

77/01/02

37/01/31

49700.00

1008

1019

301

312102

Kanieski

Carol

77/02/01

58/05/17

29250.00

1009

1005

403

432101

Lombardo

Domingus

77/02/01

45/11/15

31000.00

1010

1003

401

412101

Rogers

Frank

77/03/01

35/04/23

46000.00

1011

801

402

421100

Daly

James

77/03/15

49/12/11

52500.00

1012

1005

403

432101

Hopkins

Paulene

77/03/15

42/02/18

37900.00

1013

1003

401

412102

Phillips

Charles

77/04/01

63/08/10

24500.00

1014

1011

402

422101

Crane

Robert

78/01/15

60/07/04

24500.00

1015

1017

501

512101

Wilson

Edward

78/03/01

57/03/04

53625.00

1016

801

302

321100

Rogers

Nora

78/03/01

59/09/04

56500.00

1017

801

501

511100

Runyon

Irene

78/05/01

51/11/10

66000.00

1018

1017

501

512101

Ratzlaff

Larry

78/07/15

54/05/31

54000.00

1019

801

301

311100

Kubic

Ron

78/08/01

42/12/11

57700.00

1020

1005

403

432101

Charles

John

78/10/01

49/06/21

39500.00

1021

1025

201

222101

Morrissey

Jim

78/10/01

43/04/29

38750.00

1022

1003

401

412102

Machado

Albert

79/03/01

57/07/14

32300.00

1023

1017

501

512101

Greene

Peter

79/03/01

62/10/29

26500.00

1024

1005

403

432101

Brown

Allen

79/05/01

54/01/16

43700.00

1025

801

201

211100

Short

Michael

79/05/01

47/07/07

34700.00