ComCon
Contact
    HOME  |  ABOUT US  |  COMMUNITY  |  DOWNLOAD
 
March 17-19, 2015 in Dallas          


    Services
    Courses
    Workshops
    Sessions
    Articles
    Books

Query

Duration

1 day

What the Course Covers

The course introduces the concept of database files and explains all aspects of the Query tool. There are extensive hands-on exercises.

How Can You Apply the Skills You Will Learn?

After completing the course you will be able to explore and create Queries over standard DB2 database files. This will include reporting over multiple files and creating data extracts.

Who Should Attend

Query is a tool that is equally useful to programmers and users. Anybody who needs to view database data for any reason will benefit from attending.

Prerequisites

Familiarity with using a 5250 screen

Agenda

The following topics will be covered
  • Query Commands and Menus
  • Managing queries
  • File selection
  • Creating fields
  • Selecting and sequencing fields
  • Selecting records
  • Collating sequence
  • Column functions
  • Summary functions
  • Database output
  • Printed output
  • Display output
Home | About Us | System i Community | Contact
ComCon © 1994 - 2017. This site is hosted on an  i