The course provides all the information required to enable the students to design and code Natural Version 2 and Version 3 Structured Mode programs that process data in an Adabas database. The course includes practical exercises.
5 days
1 Overview of Natural and Adabas 2 The Natural Development Environment 3 Defining Data - Variables and Data Areas. - Defining database views. - Defining user variables. - Redefinition of variables. - The Data Editor. - Using the data area. 4 Basic Programming - The Program Editor. - Listing and deleting objects. - Move and Assign statements. 5 Accessing Data on the Database - The Find statement. - The With clause. - The Sorted By clause. - The Read and Histogram statements. - Nested database loops. - The Find Number statement. - The Where clause. - The Get statement. 6 Simple Reports - The Display statement. - Column headings and spacing. - Vertical display. - The Newpage, Skip, and Write statements. 7 Simple Transactions - The Input statement. - The Map Editor. - Using data areas in maps. - Editing fields. - Using the maps. 8 Conditional Processing and Loops - The If, Decide On, and Decide For statements. - Nested conditional statements. - The Repeat and Escape statements. - The For statement. - The Accept and Reject statements. - The Reinput statement. 9 Array Processing - User variable arrays. - Database arrays. 10 Arithmetic Processing - The Add and Subtract statements. - The Multiply and Divide statements. - The Compute statement. - Mathematical functions. - Array arithmetic. 11 Updating Database Records - Store, Delete, and Update statements. - Holding records. - Avoiding transaction timeouts. 12 Programs, Subroutines and Subprograms - Subroutines and Subprograms. - The Fetch statement. 13 Batch Processing - Reading and writing work files. - Printing in batch. 14 Advanced Report Writing - Titles and Trailers. - Break processing. - Using maps for reports. 15 Map Editor Advanced Functions - Help maps and help routines. - Processing rules. - Defining arrays in maps. 16 Odds and Ends