Natural Advanced with DB2

LENGTH OF COURSE:
5 Days

DESCRIPTION: This course will provide an in-depth study of Natural commands and development environment. Students will create advanced programs, reports and maps. In addition, Natural SQL database calls to IBM's DB2 Database Management System will be discussed. After completing the course, students will feel comfortable developing an application in the Natural environment that is both well tested and efficient.

PREREQUISITES: Some knowledge of Natural programming, CICS/TS, and the Operation System (i.e.: OS/390, OS/2) in which the Natural Application will be built is required.

INSTRUCTION TECHNIQUES: A combination of Lecture, Demonstrations, and Labs (when/where available).

AUDIENCE

This course is designed for Project Leaders, System Analysts and Programmers that have some experience and/or understanding of the Natural programming language. Intermediate and experienced level users of Natural benefit most with this in-depth study of Natural's Fourth Generation features and functions plus DB2 and Abacus.
KEY HIGHLIGHTS:
  • Programmatic Functions
    • Conditional Processing Overview
    • Logical Condition Criteria
    • Making a Decision
    • Loop Control
    • Data Manipulation
    • Calculating Values
    • Assigning Values
    • Combining and Separating Values
    • Evaluating Field Values and Patterns
    • Array Processing
    • Array Usage
    • Defining Arrays in Maps
    • Using Tables in Maps
  • Report Creation
    • Topic
    • Example Program
    • DISPLAY and WRITE Statements
    • Session Parameters
    • PRINT Statement
    • Keeping Groups of Data Together
  • Data
    • Overview of Data Types
    • Data Areas
    • User-Defined and System Variables
    • Using Data Areas in Programs
    • Database Access (ADABAS C Version)
    • ADABAS C Concepts and Components
    • ADABAS C Data Access
    • ADABAS C Sorting
    • Database Access (DB2 Version)
    • DB2 Concepts and Components
    • DB2 Data Access
    • DB2 Sorting


  • Using NATURAL Objects Effectively
    • Overview of Modularization
    • Modularization Approach
    • Function of the Buffer Pool and Database
    • How to Use NATURAL Objects Effectively
    • External Data Areas
    • GDAs
    • PDAs
    • LDAs
    • Maps
    • Programs
    • Subroutines
    • Subprograms
    • Copycode
    • Executing Objects
    • Object Types Summary
    • Object Interaction
    • Additional Reading: Cross-Referencing Facility
  • Testing and Debugging for Quality
    • The NATURAL Utilities
    • Testing/Debugging Procedures
    • Testing/Debugging Facility
    • Structured Code Walk-throughs




FROM OUR STUDENT EVALUATIONS...
"Good course!"

Bob Johnson
Covia Technologies

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.