|
iSeries400 Programming Courses Course Name : iSeries 400 Concepts & Programming WorkshopDuration : 5 Days Delivery Method : Classroom (Hands-on Lab) Skill Level : Basic Language : English Overview : This course applies to the iSeries 400, AS/400e, and AS/400 systems. Learn iSeries 400 and AS/400e concepts, and how to use the following programming facilities: Programming Development Manager (PDM), Source Entry Utility (SEU), Screen Design Aid (SDA), Data File Utility (DFU), Structured Query Language (SQL),Operations Navigator,Query/400, and Query Manager. Hands-on labs gives you the opportunity to use these facilities. Who Should Take This Course : Data processing (DP) managers, system analysts, system programmers, and application programmers. This course is not intended for system operators. What You Are Taught: Implement an iSeries 400 or AS/400e database using Data Description Specifications(DDS), SQL, and Operations Navigator Describe basic OS/400 Work Management Create OS/400 objects, such as user profiles, libraries, and job descriptions Describe basic iSeries and AS/400e security Use PDM and SEU to create and maintain source code for database files, display files, and programs Compile source code and manage the resulting objects using PDM Create, modify, and test display files and menus using SDA Access and update database files using DFU Write basic Control Language (CL) programs that run and manage application programs Use these iSeries 400, or AS/400e functions: device files, file overrides, and copy file Describe iSeries 400, or AS/400e save and restore functions and other availability and recovery functions Use Query/400 and Query Manager to produce reports
Course Name : DB2/400 Database Coding and ImplementationDuration : 2 Days Delivery Method : Classroom (Hands-on Lab) Skill Level : Intermediate Language : English Overview : Learn how to code, create and maintain DB2/400 physical and logical files using native Data Description Specifications (DDS) and Command Language (CL) commands. This course also gives you a DB2/400 relational database foundation if you intend to write application programs for the AS/400 system, however it does not discuss SQL implementation of DB2/400. In this course, you learn many techniques that, if implemented, enhance the performance of applications using the database. Who Should Take This Course: People responsible for creating and maintaining a DB2/400 database. What You Are Taught: Code the DDS and create the physical and logical files necessary to implement a DB2/400 relational database Describe the advantages of a field reference file, code the necessary DDS and create a field reference file Explain how the choices made while coding the DDS and creating the file affect the performance of the system and the programs using the files Describe the considerations for using DB2/400 referential integrity and triggers Topics Include:
Prerequisites:
Course Name : iSeries 400 Control Language Programming WorkshopDuration : 4 Days Delivery Method : Classroom (Hands-on Lab) Skill Level : Intermediate Language : English Overview : This course applies to the iSeries 400, AS/400e, and AS/400 systems. Learn to write easy to use, and efficient Control Language (CL) programs that require little, or no involvement by system operators. Also, learn how to write user commands, and how to modify commands provided by IBM. You practice these skills in hands-on exercises. In some instances, you are provided with several exercises and it is suggested that you choose the one that best meets your needs. Who Should Take This Course: Application and system programmers. What You Are Taught: Write interactive and batch CL programs Write CL programs that control the execution sequence of high level language applications programs; automatically handle exceptions, errors, and inquiry messages; interrogate and change job attributes and system values; conditionally execute and branch within a CL program; perform arithmetic and logic operations; prompt for the parameters of a command within a CL program at execution time; use data areas,data queues, and messages to communicate to other jobs on the system. Use the interactive source debugging facilities of STRDBG Create user defined commands to run applications. Write your own utility programs to handle repetitive and one time system control and management tasks Write never ending batch programs that become active when work arrives Describe the parameters on the CRTCLPGM command, and the parts of a Control Language compile listing Use the appropriate reference manuals, online Help text, and Infoseeker Perquisites : You should complete: iSeries 400 Concepts & Programming Workshop Course Name : iSeries 400 Interactive Program DesignDuration : 2 Days Delivery Method : Classroom (Hands-on Lab) Skill Level : Intermediate Language : English Overview : This course is the Pre-Req for RPG IV and RPG/400 and explains how to control job execution and process access group, introduces to structured programming, multifunction structured program, subprogram, filesharing, ODP sharing, to code ILE programs, Data area, Data Queue, Group jobs, Screen Interface, Application Help, Subfiles and PRTF. Who Should Take This Course: Application and system programmers. What You Are Taught: Write interactive and batch CL programs to control Job and PAG Write Structured Program using MFSP, Sub program How to share File and ODP Write ILE Programs Using Data Area,Data Queue and Group Jobs Perquisites : You should complete: AS/400 Control Language Program Workshop Course Name: iSeries 400 and AS/400e RPG IV Programming WorkshopDuration : 5 Days Delivery Method : Classroom (Hands-on Lab) Skill Level : Advanced Language : English Overview : This course applies to the iSeries 400, AS/400e, and AS/400 systems. Learn the basics of the Report Program Generator (RPG) IV language, and how to develop applications on the AS/400 using RPG IV. This course is not introductory in content, and is designed to challenge you. This course does not teach the RPG III language. Review some topics, such as database access, that are required for writing applications, but are not part of the RPG IV language itself. Receive a comprehensive exposure to the main features and functions of RPG IV. The course does not introduce either information processing or programming in general. Who Should Take This Course: Experienced programmers who are new to AS/400 RPG IV. What You Are Taught: Develop AS/400 applications in the RPG IV language Maintain existing applications written in the RPG IV language Use the Integrated Language Environment (ILE) Source Debugger tool to determine the cause of incorrect results Topics Include : RPG IV Introduction Coding Specifications for RPG IV Data Representation and Definition Manipulating Data in Calculations Printer Files Using the ILE Source Debugger Structured Programming, Subroutines and Calls Accessing the DB2 Database Using RPG IV Interactive Programming Using Arrays Data Structures and Data Areas Prerequisites: You should complete: iSeries 400 and AS/400e Interactive Program Design
Venue (For all the above programs)
Payment Details :The fees for the course is Rs.33,060 (inclusive of 10.2% service tax). Payments should be made in the form of DD drawn in favour of ‘ IBM Global Services India Pvt Ltd .' payable at Bangalore, India. Last date for enrolling to the above programs is 21st Nov 2005 . Last date for paying fees is 21 st Nov 2005 . Kindly send your confirmation as soon as possible to suman@silverlake.co.in Please get in touch, if you require any further clarifications. Assuring you the best of service – Always Thanks and Regards, Suman. M *** |