Duration
2 days
OBJECTIVE
Designed for SQL users and programmers who are responsible for reproducing application programs to manipulate AS/400 SQL databases
PREREQUISITE
- Having attended the OS/400 Operating System course
- Having basic knowledge and experience of programming and concepts.
AUDIENCE
- AS/400 programmers and data administrators
WHAT WILL YOU LEARN
- Understanding the concepts of SQL/400 programming in IBM AS/400
- Creating, retrieving and manipulating information from RDMS table
- Incorporating SQL statements in an application program.
Day 1
9:00am-10:30am
Module 1: Understanding SQL/400 Concepts
- Static SQL
- Dynamic SQL
10:30am-10:45am Morning break
10:45am-12:30pm
- Interactive SQL
- Query Manager
12:30pm-1:30pm Lunch
1:30pm-3:30pm
Module 2: Quick Tour of Query Manager
3:30pm-3:45pm Afternoon break
3:45pm-5:00pm
Day 2
9:00am-10:30am
Module 4: User & Data Security
10:30am-10:45am Morning break
10:45am-12:30pm
Module 5: Creating A Collection/Tables/Indexes
12:30pm-1:30pm Lunch
1:30pm-3:30pm
Module 6: SQL Select Clause & Built-In Functions
3:30pm-3:45pm Afternoon break
3:45pm-5:00pm
Programme scope, delivery arrangements and suitability are confirmed during enquiry.