Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - File Manager/Db2 - IBM

Home

distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services



MFUTD23

File Manager/Db2 - IBM
DURATION: 1 day

FEE: $595

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.

AUDIENCE:

  • Programmer
  • System Analyst
  • Database Administrator
  • IT Professional
 
   

DATES:

CONTENT AND OBJECTIVES:
    1. FM/Db2 with Db2
      • Navigate through the panels to examine the edit, copy, and print utilities.
      • Examine the utilities for: 1- Listing Db2 objects. 2- Managing Db2 privileges. 3- Generating JCL to run Db2 stand-alone utilities. 4- Exporting and importing Db2 tables to or from QSAM or VSAM datasets. 5- Creating data to populate Db2 tables. 6- Prototyping SQL SELECT statements.
    2. Working with Templates
      • Use templates to provide a formatted view of data; this will provide the capability to view, edit, and manipulate data according to the columns and datatypes provided in the instructor supplied tables.
    3. Viewing Db2 Data
      • Given a table provided by the instructor, view the content; review the information provided for NULL columns.
      • Examine the column information provided by FM/Db2.
      • Filter all NULL values.
    4. Changing Db2 Data
      • Specify the start position for the FM/Db2 editor session.
      • Set options for the current FM/Db2 editor session.
      • Validate and save changes to the FM/Db2 editor session.
      • Insert, update, and delete row in a table.
    5. Creating and Dropping Db2 Objects
      • Create a table with its associated indexes.
      • Create a DISTINCT type.
    6. Populating a Db2 Table with Data
      • Copy a table from another table.
      • Copy a table from a QSAM dataset.
    7. Lists of Db2 Objects
      • Use the Object Panels to display and perform operations on the tables.
      • Use this utility to determine table attributes.
    8. Managing Db2 Privileges
      • Use FM/Db2 to display and grant privileges.
    9. Db2 Batch
      • Perform a Db2/FM export of a Db2 table.
      • Copy the EMP table to a DSNCOPY.EMP.
      • Update any rows in the target table that generate duplicate key errors; the threshold is a maximum of 100 duplicate key errors.
    10. Working with SQL Statements
      • Prototype a series of Db2 SQL statements.
      • Create a dataset with SQL statements and execute the statements in the dataset.

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

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.