IBM DB2 - PowerPoint PPT Presentation

1 / 9
About This Presentation
Title:

IBM DB2

Description:

IBM DB2 DB2 for iSeries 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 DB2 Administration: iSeries ... – PowerPoint PPT presentation

Number of Views:274
Avg rating:3.0/5.0
Slides: 10
Provided by: jpw8
Category:
Tags: ibm | db2 | iseries

less

Transcript and Presenter's Notes

Title: IBM DB2


1
IBM DB2
  • DB2 for iSeries

2
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
  • DB2 Administration iSeries Navigator
  • Download Access for Windows V5R4
  • Getting start

3
The iSeries Navigator
4
Add Connection
5
Add Database Component
6
Install Database Components
7
Run SQL Scripts
8
Create COMPANY Objects
  • Create and populate COMPANY tables by running
    script company_create.sql
  • Open Run SQL Script window
  • File ? Open ? company_create.sql ? Open
  • Modify the first line to
  • Set current schema your schema name
  • Run ? All
  • Drop COMPANY tables by running script
    company_drop.sql

9
Create COMPANY Objects
Write a Comment
User Comments (0)
About PowerShow.com