PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
CONTENT AND OBJECTIVES:
Db2 QMF Facilities and Queries
Examine the concepts and terminology of a RDMS.
Use a human resource system to produce sample reports.
Invoke and customize QMF.
Set the defaults for the query type, log dataset names, and printer information.
Saving Queries and Temporary Storage Areas
Execute queries and display reports.
Run a series of queries by drawing requests.
Modify the queries and convert to SQL.
Db2/SQL and QBE
Examine and use QMF commands.
Run commands to save the queries, reports, and data into sequential datasets.
Create and execute interactive scripts to run reports.
Execute batch QMF for printing reports.
Detailed Report Formatting
Display and modify a report.
Modify the form to include additional heading and footings.
Modify the size of column.
Change column headings.
Use report generation options and execute scripts.
Modify the form to include break logic, statistics, and detail/summary reports.
Use the Table Editor to add, delete, and change rows in a table.
Identify and resolve run-time errors.
Distinguishing columns with the same name UNION.
Nesting SQL statements.
Replacing null values in a report with other values.
Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.