ibm db2 db2 for iseries. jiangping wang ibm db2 for iseries ibm db2 family z/os, i5/os,...
TRANSCRIPT
![Page 1: IBM DB2 DB2 for iSeries. Jiangping Wang IBM DB2 for iSeries IBM DB2 Family z/OS, i5/OS, Linux/Unix/Windows IBM DB2 for LUW V9.7 IBM DB2 for iSeries V5R4](https://reader036.vdocuments.us/reader036/viewer/2022082505/56649ef45503460f94c08032/html5/thumbnails/1.jpg)
IBM DB2
DB2 for iSeries
![Page 2: IBM DB2 DB2 for iSeries. Jiangping Wang IBM DB2 for iSeries IBM DB2 Family z/OS, i5/OS, Linux/Unix/Windows IBM DB2 for LUW V9.7 IBM DB2 for iSeries V5R4](https://reader036.vdocuments.us/reader036/viewer/2022082505/56649ef45503460f94c08032/html5/thumbnails/2.jpg)
Jiangping Wang
IBM DB2 for iSeriesIBM DB2 Family
z/OS, i5/OS, Linux/Unix/Windows
IBM DB2 for LUWV9.7
IBM DB2 for iSeriesV5R4DB2 Administration: iSeries NavigatorDownload Access for Windows V5R4Getting start
Webster University
![Page 3: IBM DB2 DB2 for iSeries. Jiangping Wang IBM DB2 for iSeries IBM DB2 Family z/OS, i5/OS, Linux/Unix/Windows IBM DB2 for LUW V9.7 IBM DB2 for iSeries V5R4](https://reader036.vdocuments.us/reader036/viewer/2022082505/56649ef45503460f94c08032/html5/thumbnails/3.jpg)
Jiangping Wang
The iSeries Navigator
Webster University
![Page 4: IBM DB2 DB2 for iSeries. Jiangping Wang IBM DB2 for iSeries IBM DB2 Family z/OS, i5/OS, Linux/Unix/Windows IBM DB2 for LUW V9.7 IBM DB2 for iSeries V5R4](https://reader036.vdocuments.us/reader036/viewer/2022082505/56649ef45503460f94c08032/html5/thumbnails/4.jpg)
Jiangping Wang
Add Connection
Webster University
![Page 5: IBM DB2 DB2 for iSeries. Jiangping Wang IBM DB2 for iSeries IBM DB2 Family z/OS, i5/OS, Linux/Unix/Windows IBM DB2 for LUW V9.7 IBM DB2 for iSeries V5R4](https://reader036.vdocuments.us/reader036/viewer/2022082505/56649ef45503460f94c08032/html5/thumbnails/5.jpg)
Jiangping Wang
Add Database Component
Webster University
![Page 6: IBM DB2 DB2 for iSeries. Jiangping Wang IBM DB2 for iSeries IBM DB2 Family z/OS, i5/OS, Linux/Unix/Windows IBM DB2 for LUW V9.7 IBM DB2 for iSeries V5R4](https://reader036.vdocuments.us/reader036/viewer/2022082505/56649ef45503460f94c08032/html5/thumbnails/6.jpg)
Jiangping Wang
Install Database Components
Webster University
![Page 7: IBM DB2 DB2 for iSeries. Jiangping Wang IBM DB2 for iSeries IBM DB2 Family z/OS, i5/OS, Linux/Unix/Windows IBM DB2 for LUW V9.7 IBM DB2 for iSeries V5R4](https://reader036.vdocuments.us/reader036/viewer/2022082505/56649ef45503460f94c08032/html5/thumbnails/7.jpg)
Jiangping Wang
Run SQL Scripts
Webster University
![Page 8: IBM DB2 DB2 for iSeries. Jiangping Wang IBM DB2 for iSeries IBM DB2 Family z/OS, i5/OS, Linux/Unix/Windows IBM DB2 for LUW V9.7 IBM DB2 for iSeries V5R4](https://reader036.vdocuments.us/reader036/viewer/2022082505/56649ef45503460f94c08032/html5/thumbnails/8.jpg)
Jiangping Wang
Create COMPANY ObjectsCreate and populate COMPANY tables by running script company_create.sql
Open Run SQL Script windowFile Open company_create.sql OpenModify the first line to
Set current schema {your schema name}
Run All
Drop COMPANY tables by running script company_drop.sql
Webster University Distributed Database Design
![Page 9: IBM DB2 DB2 for iSeries. Jiangping Wang IBM DB2 for iSeries IBM DB2 Family z/OS, i5/OS, Linux/Unix/Windows IBM DB2 for LUW V9.7 IBM DB2 for iSeries V5R4](https://reader036.vdocuments.us/reader036/viewer/2022082505/56649ef45503460f94c08032/html5/thumbnails/9.jpg)
Jiangping Wang
Create COMPANY Objects
Webster University Distributed Database Design