COMMON: A Users Group
 LANSA
FaceBook
Twitter
LinkedIn
 






IBM i
AIX
Linux
 
PowerVM



 
 
 
Pre-Conference Workshops
 

Add in-depth learning with a Pre-Conference Workshop! When you register for the conference, consider signing up for additional education by registering for an all-day pre-conference workshop (additional fee required). In-depth technical workshops are either labs or lecture, and take place the day before the start of the conference (Sunday, May 2, 2010), beginning at 8 a.m. There will be a morning coffee break, a lunch break, and all workshops will end at 4:00 p.m.

You can sign up for the workshop of your choice when you register for the conference. Space in each workshop is limited and available on a first-come, first-served basis.

 

Getting Started with DB2 Web Query
Speaker: Gene Cobb, IBM

This workshop is designed for the developer and database administrator who would like a modern query and reporting tool to deliver timely and quality reports, graphs, and dashboards to meet the reporting requirements of their company. This session introduces, DB2 Web Query for IBM i, the strategic query and reporting tool for the IBM i operating system. The instructor uses lecture, demonstrations, and labs to help attendees understand the capabilities of the new product and the steps and skills necessary to deliver this content back home in their production environment.

Learning Objectives:

  1. The attendee will learn how to create metadata and understand the advantages of this abstraction layer.

  2. The attendee will learn how to take existing Query/400 objects and "webify" them using the DB2 Web Query import tools.

  3. The attendee will learn how to create reports and graphs using the DB2 Web Query development tools.

  4. The attendee will learn best practices, several tips and techniques to enhance the implementation, and pitfalls to avoid.

Workshop Syllabus/Agenda:

  • DB2 Web Query demo
  • Metadata
  • Labs that will show you how to create reports and graphs using the development tools
  • Modern report output formats such as HTML, Excel spreadsheets, PDF, and Active Reports
  • DB2 Web Query Tips and techniques

Audience: This workshop is designed for programmers and database administrators who understand the query and reporting needs of their company and need a modern tool to deliver those requirements. Attendees should have an understanding of the DB2 for i database and the general database design of their company. Knowledge of SQL is helpful but not required.

Pricing: $345 for members, $395 for non-members


Systems Management
Speaker: Larry Bolhuis, Frankeni Solutions

This workshop will cover:

  1. HMC, what it does, when you need one, general care and feeding.
  2. FSP updates, why, when, how (two ways: with and without HMC).
  3. PTFs for i5/OS, gettin' 'em and loadin' 'em, and knowing what you have! (including Fix Central overview).
  4. VMI - Tape and Optical. The care and feeding of image catalogs and how to clean a virtual tape drive.
  5. Management central - performance monitoring, PTF distribution, central site inventory.
  6. Storage Management - How much disk is enough (rhetorical question!). Adding disk, managing ASPs (including iASPs)
  7. RCLSTG and why you need one.
  8. Various System values.
  9. Spool file maintenance including use of iASPs, Joblog Servers, and disconnected spool file functions.

Pricing: $345 for members, $395 for non-members


LAB - HTML, XHTML, CSS, and JavaScript
Speaker: Bill Hansen, Manta Technologies

This workshop covers the following technologies, which are critical to any modern web-based application:

  • HTML, the Hypertext Markup Language, is the basis for communication between a web server and a browser. It is through HTML documents that you determine what a user sees when visiting your web site. Because of this, every web developer needs a basic understanding of HTML coding, even if you use tools to create most of your HTML pages.
  • The eXtensible HyperText Markup Language (XHTML) is a successor to HTML that follows the rules of XML. In today's web environment, developers need to know both languages.
  • Cascading Style Sheets (CSS) are used to control how HTML, XML, and XHTML elements are displayed by a browser. 
  • JavaScript is a scripting language that a web developer can use within an HTML or XHTML document to perform functions on the user's machine.  Using JavaScript, you can develop client-side routines to validate input, store data on the user's PC, and perform related tasks. 
By the end of the workshop, you will have the skills you need to develop the HTML pages and forms that are used in typical ebusiness web sites.

Workshop Syllabus/Agenda:

After completing thisworkshop seminar, you should be able to:

  • Describe the difference between HTML and XHTML
  • Code the XHTML elements to identify the following document components:
    • Headings
    • Paragraphs
    • Line breaks
    • Preformatted text
    • Boldface and italic text
    • Superscripts and subscripts
    • Special characters
    • Internal and external links
    • Mail-to links
    • Ordered or unordered lists
    • Tables
    • Frames
    • Images
    • Horizontal rules
    • Forms
  • Define a Cascading Style Sheet, specifying rules that apply to all elements of a given type or only to selected elements
  • Given a display formatting requirement for a specified XHTML element, identify the CSS property that can be used to achieve the desired result
  • Use the [div] and [span] elements to apply a style rule to a group of elements
  • Code the XHTML elements to support the following field types within an online form:
    • Text boxes
    • Radio buttons
    • Check boxes
    • Text areas
    • Buttons
    • Passwords
    • Hidden fields
  • Code the HTML/XHTML element to identify a JavaScript program that is stored within the same document or in a separate file
  • Describe the basic syntax rules for coding JavaScript statements
  • Code comments in a JavaScript program
  • Name and describe the JavaScript-supported data types
  • Declare a JavaScript variable
  • Assign a value to a JavaScript variable
  • Perform common arithmetic operations, including addition, subtraction, multiplication, and division
  • Concatenate string variables
  • Convert data from one type to another
  • Declare and use an array
  • Use common JavaScript string methods, including toUpperCase, toLowerCase, indexOf, charAt, subst, and substring
  • Use common JavaScript Math methods, including max, min, sqrt, and round
  • Use JavaScript Date methods to determine the current date and time
  • Implement the following control structures in a JavaScript program:
    • If
    • If/Else
    • Case
    • Do While
    • Do Until
    • For
  • Define a JavaScript function
  • Cause a JavaScript function to be invoked as the result of a browser event
  • Code JavaScript statements to perform the following tasks:
    • Reference an object within the same window, a subwindow, the parent window, or a frame
    • Display a message in an independent browser window
    • Create, write to, and close a subwindow
    • Replace the document displayed in the browser window
    • Prompt the user for an input value or a confirmation
  • Reference form components from a JavaScript program
  • Check user-supplied form data for validity
  • Modify an HTML form to invoke a JavaScript function
  • Code JavaScript functions to create, retrieve, update, or delete a cookie

Audience: This workshop should be taken by the individuals responsible for implementing an organization's web site. The audience includes webmasters, content developers, application programmers, and system administrators.

Pricing: $445 for members, $495 for non-members


The RPG Programmer's PHP
Speaker: Erwin Earley, IBM

This workshop will focus on RPG use of PHP.

The session starts with PHP web front-ends for RPG from the simple parameter *PGMs to complex data *SRVPGMS, then on we go with RPG and PHP sharing the web with technologies like REST and POX, and finally we reverse the whole flow with RPG calling PHP scripts from most any RPG application.

Lots of sample code will be presented along with various tips and tricks that you may place in your programming tool belt.

Our instructor will be your virtual fingers on the programming keyboard as you journey from concepts to sample programs.

Pricing: $345 for members, $395 for non-members

 

 

Check back often as we continue to add more information and details about this exciting conference event.
 
www.common.org/annualmeeting
 
Webmaster | Privacy | Copyright