Workshops

Still stuck in an RPG/400 world? Well, this exciting Workshop will show you how modern programming practices and tools can transform your old monolithic RPG applications into a modern, highly modularized form that will position your business for the future. Rather than just throw hours of theory at you, this seminar takes a sample application and follows it through the process of converting from RPG/400 or basic RPG IV to full usage of RPG IV and ILE features, modularizing the code, adding DB2 UDB features and even replacing the green-screen with a graphical or browser-based interface.

Who Should Attend
Programmers and Analysts who wish to modernize their existing applications.

Agenda

• Introduction
• Use the Right Tools
• Making Use of RPG IV - Beyond the Basics
• Triggers
• Moving RPG to ILE - the Basics
• Really Moving RPG to ILE - subprocedures
• Referential Integrity
• Externalizing
• Ready for the Web

This is the fastest way to get your iSeries applications talking to the web. You don't need Java, ASPs, JSPs or Websphere. You already have everything you need in RPG IV and the APache Server for i. You will see how to:

• code HLL programs to write data to a web page
• understand and write HTML
• use the CGI APIs
• use the CGIDEV2 APIs

Who Should Attend

Programmers and Analysts who wish to leverage their existing skills. The course is taught in an RPG environment, but what you will learn can be applied equally to any i HLL.

Agenda

• Introduction
• Tools and References
• Apache Server on i
• Basic HTML
• The CGI APIs
  (the underlying principle)
• Getting Started with CGIDEV2
• Printing to the Web
• Interacting with a Browser
• HTML Forms
• Maintenance with CGIDEV2
• More on CGIDEV2
• Debugging and other Bits and Pieces
• In Conclusion

The workshop introduces RPG IV and ILE from the point of view of experienced RPG III (RPG/400) programmer.

Who Should Attend

Experienced RPG III (RPG/400) programmers

Agenda

• Background
• Conversion Options
• Format and Limit Changes
• Data Types
• H-Spec
• Compiler Directives
• F-Spec
• D-Spec (Overview)
• C-Spec
  • Normal
  • Extended
  • Free form
• Expressions
• Built in Functions
• Indicators
• Dates, Times and Timestamps

SQL is being used more and more by the RPG programmer. Not only is SQL replacing DDS for defining databases but it is being used extensively within RPG programs themselves. This workshop introduces SQL for the RPG Programmer with a lot of emphasis on the use of Navigator for i. The workshop is designed for experienced RPG IV programmers. You will see how to:

• Get started with SQL
• Use SQL in Navigator for i
• Use SQL's Data Manipulation (DML)
• Use SQL's Data Definition Language (DDL)
• Use embedded SQL

Who Should Attend

Programmers and Analysts who wish to leverage their existing database and programming skills.

Agenda

• Overview and Terminology
• SQL and the iSeries
• Data Manipulation (DML)
  • Retrieving Data (SELECT, FROM, WHERE, ORDER BY)
  • Updating Data (INSERT, UPDATE, DELETE
  • GROUP BY, HAVING, Column Functions
  • Special Operators (BETWEEN, IN, LIKE, IS NULL)
  • SQL Functions
  • Selecting From Multiple Files
  • Sub Queries
• Embedded SQL
  • Why use embedded SQL?
  • Basic Syntax
  • Using host variables
  • Using a SELECT statement
  • Using a Cursor
  • Identifying and handling errors
  • The power of INSERT, UPDATE and DELETE
  • Compile options
  • When to use dynamic SQL
  • Using PREPARE and EXECUTE
  • Performance tips
• Data Definition (DDL) (Create/Drop COLLECTION, TABLE, VIEW)

As RPG programmers continue to move to RPG IV and ILE they bring a lot of old RPG III habits with them. Old habits die hard and, even though they may be making use of some of the new language features, are they making full use of what RPG IV and ILE have to offer?

This workshop discusses some of the language features and methodologies programmers should be embracing and some of the more traditional approaches they should be discarding.

We'll explore some of the following topics:

• Useful Built-in Functions you may have missed
• Is Free Form for you?
• Why numbered indicators should be banned from your code
• How and why to replace Call, Parm, Parm, Parm
• Using subprocedures to structure your code
• What you need to learn about ILE