 | Accessing the iSeries Database Using SQL (S6137) |
|
iSeries Application Programming Facilities Workshop (S6149) |
|
or have equivalent skills to: |
|
Use SQL Data Definition Language (DDL) to describe tables and views |
|
Use SQL UPDATE, INSERT, ALTER and DELETE statements to modify SQL tables |
|
Use the SQL SELECT statement to extract data from tables and views |
|
Code SQL queries that include column and scalar functions |
|
Code SQL queries that include inner and outer joins |
|
Navigate iSeries menus and use iSeries commands |
|
Use Program Development Manager (PDM) and Source Entry Utility (SEU) to code programs |
|
Experience coding applications in the RPG IV language is strongly recommended, but an RPG III background is acceptable. Experienced RPG III (RPG/400) programmers should complete: |
|
Moving from RPG/400 to iSeries RPG IV (S6126) |
|
or have equivalent skills to: |
|
Use the Integrated Language Environment (ILE) Source Debugger |
|
Code RPG programs on the iSeries |
|
RPG IV language features are taught in this course. If you have no knowledge of RPG IV, you may get less value from this course than an experienced RPG IV programmer. Experienced programmers who do not know RPG should complete: |
|
iSeries RPG IV Version 5 Programming Fundamentals Workshop (S6197) |
|
iSeries RPG IV Version 5 Programming Intermediate Workshop (S6198) |
|
For an overview of DB2 UDB for iSeries you should complete: |
|
DB2 UDB for iSeries Fundamentals (S6145) |
